backup doesn't restore mysql

[uadm]

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]

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]

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]

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.

 

[uadm]

ticket number is 4460655

 

[cPanelMichael]

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.