R
Railway11mo ago
ethan

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
Percy11mo ago
Project ID: a1e95c16-7570-4ef7-ae16-7e63d25d038f
ethan
ethan11mo 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
Want results from more Discord servers?
Add your server