mysql crashed in the middle of manual cpanel full backup

[xrvel]

Hello.

I wonder what happened if mysql process is crashed in the middle of manual cpanel full (file + database) backup.
Will the cpanel service resume the backup process once mysql is recovered again?
If so, how cpanel knows what table was previously in progress of backup?

Thank you.

 

[24x7server]

Hello,

cPanel will not stop backup process if your MySQL services is down, You will get the MySQL error in your backup logs file and your databases will get blank databses in that cPanel backup file

 

[chrisnagios]

generally, cPanel backups are not reliable, there are lot of bugs and issues
and things do not work as expected in many cases.

in fact, there is not even a verification that backups are consistent after
creation, its just a blind tarring of files and dump of db, if it works, else who cares ...

 

[cPanelMichael]

Hello

Feel free to vote and add input to the existing feature request:

Add verification backend to backups/restoration/xfers | cPanel Feature Requests

Thank you.

 

[xrvel]

generally, cPanel backups are not reliable, there are lot of bugs and issues
and things do not work as expected in many cases.

in fact, there is not even a verification that backups are consistent after
creation, its just a blind tarring of files and dump of db, if it works, else who cares ...

what is your suggestion about reliable backup -- at least DB backup.
What service should i use?

 

[xrvel]

Just an update, i used this :

mysqldump --opt --single-transaction -uXXXXX -pYYYY DATABASE_NAME > /home/export.sql

 

[cPanelMichael]

Just an update, i used this :

mysqldump --opt --single-transaction -uXXXXX -pYYYY DATABASE_NAME > /home/export.sql

I am happy to see you were able to get the database backed up successfully. Thank you for updating us with the outcome.