mysql crashed in the middle of manual cpanel full backup

xrvel

• October 25, 2014 17:32

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

  • October 26, 2014 12:06

  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

  0
• 

  chrisnagios

  • October 26, 2014 13:42

  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 ...

  0
• 

  cPanelMichael

  • October 28, 2014 14:04

  Hello :) Feel free to vote and add input to the existing feature request: [url=http://features.cpanel.net/responses/add-verification-backend-to-backups-restoration-xfers]Add verification backend to backups/restoration/xfers | cPanel Feature Requests Thank you.

  0
• 

  xrvel

  • October 29, 2014 00:16

  ]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?

  0
• 

  xrvel

  • January 19, 2015 18:17

  Just an update, i used this : :)
  mysqldump --opt --single-transaction -uXXXXX -pYYYY DATABASE_NAME > /home/export.sql
  

  0
• 

  cPanelMichael

  • January 20, 2015 15:39

  ]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.

  0

Please sign in to leave a comment.