backup doesn't restore mysql

uadm

Well-Known Member
May 19, 2003
97
0
156
Hi,

We have a daily backup of all our sites. We tried to restore one account today but the database was not restored. We paid attention to marking "restore mysql" but eventualy we had to restore the database using pma.

In /usr/local/cpanel/log/error_log we see:
warn [whostmgr5] program "/usr/local/cpanel/3rdparty/attracta/scripts/pkgacct-restore" is not executable at /usr/local/cpanel/Cpanel/Hooks.pm line 199
not sure if that's related but anyhow...


Please advise.

Thanks.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello :)

What method did you use when restoring the account? Did you notice any particular error messages in the UI or command line output during the restore process itself?

Thank you.
 

uadm

Well-Known Member
May 19, 2003
97
0
156
Hi,

I go to
Backup Restoration
|
Restore by Account
|
pick date
|
Additional Options

Restore Subdomains
Restore Mail Configuration
Restore MySQL

Add Account to Queue

Restore

it's working then it show Completed

It restore the files in homedir but the mysql database isn't updated.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
To update, it was determined this issue was isolated to accounts that existed before the restore process started. Thus, the databases were not overwritten. This is the intended behavior of the new backup system, however a feature request is open to change this behavior:

Overwrite existing MySQL database on backup restore | cPanel Feature Requests

In the meantime, the workaround is to remove the databases from the account before restoring the backup archive.

Thank you.