Jump to content

Suggestion: Add "DROP TABLE" to the backup job


Recommended Posts

I think that the SQL dump generated by the backup process should include a DROP TABLE query before CREATE TABLE
Like:
DROP TABLE IF EXISTS `table_name`;

Without it, I cannot use the control panel provided by my host, since I am getting an error "table already exists" when using the import function that the host CP provides.

I need to go to phpMyAdmin, delete all tables from the DB, and only then import - this will cause a longer outage to the site than if the sql dump dropped the table itself.

No?

Link to comment
Share on other sites

×
×
  • Create New...