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:
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
Project ID:
a1e95c16-7570-4ef7-ae16-7e63d25d038f
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