Topics

Railway•6mo ago

SHOW CREATE VIEW ____ not working for some views

I just migrated my DB from digital ocean to railway, and I'm unable to use the command:

SHOW CREATE VIEW _____

SHOW CREATE VIEW _____

This is only happening for some views, but this is the error I get in mysql workbench: Error Code: 2013. Lost connection to MySQL server during query And in Railway: https://paste.gg/p/anonymous/fe323db414c1458ca418fbff4fd30e96

2 Replies

Percy•6mo ago

Project ID: a1e95c16-7570-4ef7-ae16-7e63d25d038f

ethan•6mo ago

a1e95c16-7570-4ef7-ae16-7e63d25d038f I don't have time to solve the issue with the CREATE VIEW command. I pulled the create view command from my backup to alter the VIEW, and now it works. i'm not sure if it had something to do with the fact that the user who created the view didn't exist when I moved the database over

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

24KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

How to create a database backup on a Strapi deployment?Hi there! I have Strapi depoyed on Railway, and I'd like to create a database backup as explained he Build FailedService ID: 6ed5a183-bf99-43d3-9634-f9efa9b62756 Trying to deploy my frontend application from GitH Trying to deploying from dockerhub failsBeen trying to deploy an image from dockerhub, but it fails to deploy and does not show any logs. Pr Problem with ffmpeg playbackI have been investigating but I can't find where the problem is located, I have made the following c i'm expecting this error Running Celery on RailwayThe task at hand involves the configuration of Celery on the Railway platform, a process that has pr Java Spring boot error on deploy lombokwhen i deploy my app, it's failing bcs it's not finding methods made by lombok anotation deployment Carshedmy django app was running on the server perfectly when i made a push to my github repo and redeploye Custom build command in UIYesterday I was able to add a custom build command in the UI build settings section for my service b Stop ProjectHow can I stop a environment or project without deleting it?