Is it better to drop a MySQL database before doing a restore?
Solution 1:
If DB's structure wasn't modified between dump/restore drop table
or even truncate table
is enough. If some modification has been made then you can get some residues from the previous versions without drop database
.
Anyway drop database
is significantly faster as far as mysql do not have to keep DB's "ACID"ity.