开发者

MySQL Export exports Views first - and crashes immediately on Restore

开发者 https://www.devze.com 2023-03-07 23:23 出处:网络
I have a production MySQL server that I need to dump a database out of.The problem is that whenever I make this dump, it generates the View info开发者_如何学运维rmation first.When I try to restore thi

I have a production MySQL server that I need to dump a database out of. The problem is that whenever I make this dump, it generates the View info开发者_如何学运维rmation first. When I try to restore this backup, it errors immediately as the tables that back it don't exist yet.

Is there any quick fix to this issue? I'm dumping the database via PHPMyAdmin.

Thanks! Rob


phpmyadmin generates incorrect backups (no table locks or REPEATABLE READ isolation level), so for serious backups you should really use mysqldump. It is also much, much faster.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号