Our features site is undergoing a refresh! Be sure to explore the revamped site and discover our latest product roadmap launching here on Monday, March 18th.

Overwrite existing MySQL database on backup restore

Nathan Lierbo shared this idea 12 years ago
Completed

In version 11.30 mysql databases are not restored from backup with all other files if under cpanel account already exist database with the same name.

In version 11.28 and all other before MySQL databases was restored altogether with all files.


Currently we can check checkbox "Restore MySQL DBs" before backup restore, but restored databases are only databases deleted from cpanel account before restore, existing databases are skipped and only files are restored.

That partial restore results in broken website, especially when we need restore some CMS like Joomla or Wordpress.


Please add another option "Overwrite existing MySQL DBs" so we can easily restore complete account from backup archive.

Currently we can restore only account files but MySQL databases need manually restore via SSH.


Original thread: http://forums.cpanel.net/f145/case-50724-overwrite-existing-mysql-database-backup-restore-210622.html

Best Answer
photo

This was done in (case 120705 : http://documentation.cpanel.net/display/ALD/11.46+Change+Log) in 11.46 for backup restores and for legacy multi backup restores.


In 11.44 we added the option to choose if they are overwritten or not in the single legacy backup restores.

Replies (5)

photo
1

Yes I have same problem.. I miss the "Overwrite existing MySQL DBs" option in new backup restore.

photo
2

+1 from me


Or, perhaps, a warning on screen when "Restore MySQL" is ticked: "Restoring MySQL will not restore databases that already exist; to overwrite an existing database, you must drop the old one first" - or similar

photo
1

Highly appreciated...

What do you think cPanel? When can we get it?

photo
1

please fix overwrite exsiting user

photo
1

This was done in (case 120705 : http://documentation.cpanel.net/display/ALD/11.46+Change+Log) in 11.46 for backup restores and for legacy multi backup restores.


In 11.44 we added the option to choose if they are overwritten or not in the single legacy backup restores.

Replies have been locked on this page!