EmergencyEMERGENCY? Get 24/7 Help Now!

Recovery after DROP & CREATE

 | August 22, 2012 |  Posted In: MySQL

In a very popular data loss scenario a table is dropped and empty one is created with the same name. This is because  mysqldump in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE”:

If there were no subsequent CREATE TABLE the recovery would be trivial. Index_id of the PRIMARY index of […]

Read More