[Resolved] [Plugin: Backup Scheduler] Feature Request – DROP TABLE IF EXISTS
Hello Sed Lex,
thank you for your very useful plugin.
I have been experimenting with your plugin taking backups from my multi-site production site and restoring them to my development server.
I have successfully moved both a complete multi-site install and separately one sub domain site to a single wordpress installation.
I first run 2 find and replace to fix the domain name and the media path in the backup sql.
In one of the experiments, I imported a single site backup into a default wordpress single site install but had the import fail because the tables already existed.
I had to manually delete the tables that were the same names as those in the backup sql. Not all wordpress tables were in the backup sql, so this adds to the complexity of a restore, particularly for a restore of a single site to the multi-site production server.
If the CREATE TABLE command were proceeded by the DROP TABLE IF EXISTS command, the import should run without error no matter whether the tables exist or not, and would be much more convenient.
Perhaps I am missing something, but it seems to me that the backups would be much more user friendly to restore if they had this feature.
- The topic ‘[Resolved] [Plugin: Backup Scheduler] Feature Request – DROP TABLE IF EXISTS’ is closed to new replies.