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!

Problem Restoring Database Properly

Discussion in 'Data Protection' started by carock, Jun 17, 2016.

Tags:
  1. carock

    carock Well-Known Member

    Joined:
    Sep 25, 2002
    Messages:
    259
    Likes Received:
    7
    Trophy Points:
    168
    Location:
    St. Charles, MO
    I was tasked with restoring a user's MySQL database from backup.

    The user was not in the normal backups, but their database was backed up in the system backup.

    The problem I had is their database was InnoDB, so you can't just copy the files and make magic happen.

    I would like to suggest maybe a SQL dump of the entire MySQL install instead of just copying files. Even copying the MyISAM can be tricky for restores.

    Unless I'm missing something, the file backups of InnoDB databases are just about useless.

    Chuck
     
  2. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    556
    Likes Received:
    16
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Twitter:
    A MySQL dump of the entire system would be bad and take forever. It'd be next to impossible to restore as well. I mean, that would be one giant .sql file

    cPanel does have the option for 'per account and MySQL directory'. This is what you want

    When this is checked, cPanel will do what is expected, produce an SQL dump of each account's database, as well as the entire MySQL directory.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,197
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    The following guide is available for information on recovering an InnoDB database:

    InnoDB Corruption Repair Guide

    Let us know if this guide is helpful.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. carock

    carock Well-Known Member

    Joined:
    Sep 25, 2002
    Messages:
    259
    Likes Received:
    7
    Trophy Points:
    168
    Location:
    St. Charles, MO
    Yes, that is what I was looking for. That document didn't show up when I started this thread or searched, I don't know why.

    Thank you both for the help.

    The customer is now in the regular backups, so I hope I don't need to restore InnoDB the hard way anytime soon, knock on wood.

    Chuck
     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,197
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm happy to see the document was helpful. 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