Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    2
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,786
    Likes Received:
    82
    Trophy Points:
    78
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. chrisnagios

    chrisnagios Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,660
    Likes Received:
    1,787
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. xrvel

    xrvel Member

    Joined:
    Oct 25, 2014
    Messages:
    17
    Likes Received:
    2
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    what is your suggestion about reliable backup -- at least DB backup.
    What service should i use?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. xrvel

    xrvel Member

    Joined:
    Oct 25, 2014
    Messages:
    17
    Likes Received:
    2
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,660
    Likes Received:
    1,787
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice