开发者

MySQL Export exports Views first - and crashes immediately on Restore

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜