The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql crashed in the middle of manual cpanel full backup

Discussion in 'Data Protection' started by xrvel, Oct 25, 2014.

  1. xrvel

    xrvel Member

    Joined:
    Oct 25, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    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.
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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
     
  3. chrisnagios

    chrisnagios Member

    Joined:
    Feb 4, 2010
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    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 ...
     
  4. xrvel

    xrvel Member

    Joined:
    Oct 25, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    what is your suggestion about reliable backup -- at least DB backup.
    What service should i use?
     
  5. xrvel

    xrvel Member

    Joined:
    Oct 25, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Just an update, i used this : :)
    Code:
    mysqldump --opt --single-transaction -uXXXXX -pYYYY DATABASE_NAME > /home/export.sql
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I am happy to see you were able to get the database backed up successfully. Thank you for updating us with the outcome.
     
Loading...

Share This Page