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.
精彩评论