I just learned that Linux version of Plesk doesn't have backup and restore option, only export and import. The problem is that when I run import in order to restore some exported user DB, I have to delete all data in the existing database first, otherwise I get duplicate entry PRIMARY key errors... This is very awkward restore/backup solution, it is both inconvenient and risky if something is wrong with the exported file.
I understand that one can create a copy of the destination database and then delete all data in it prior to import but it is a kludge. Is there any clean solution? I am wondering what people use to solve this?
P.S. I guess I was spoiled with cPanel, where DB backup and restore takes 2 clicks :-(
I understand that one can create a copy of the destination database and then delete all data in it prior to import but it is a kludge. Is there any clean solution? I am wondering what people use to solve this?
P.S. I guess I was spoiled with cPanel, where DB backup and restore takes 2 clicks :-(