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!

Restoring Database from Backup Problem

Discussion in 'Database Discussion' started by simon87, Aug 24, 2016.

Tags:
  1. simon87

    simon87 Registered

    Joined:
    Aug 24, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Argentina
    cPanel Access Level:
    Root Administrator
    Hi, I recently had a problem with a database that got corrupted (it has InnoDB tables).

    I tried restoring a backup, didn't know that on my settings I had the option 'per account only'. By the way, I am getting desperate because I see only one table is being restored, missing the rest of the tables and posts (it is a Wordpress site). Any ideas how to fix this?

    Thank you so much for any help.
     
    #1 simon87, Aug 24, 2016
  2. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    604
    Likes Received:
    43
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,

    May I know which backup you have configured on your server. I mean it's Incremental Backup or Compress Account Backups ?

    If it's Compress Backups then you have to extract the backup and restore database.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 SysSachin, Aug 24, 2016
  3. simon87

    simon87 Registered

    Joined:
    Aug 24, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Argentina
    cPanel Access Level:
    Root Administrator
    Hi SysSachin, thanks so much for your answer.

    It is a Compressed backup, I already did that, but for some reason the mysql file is just a 5kb dump with the structure of one table, it has no sense. Any ideas?
     
    #3 simon87, Aug 24, 2016
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

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

    It's possible the InnoDB corruption prevented a successful backup of the database. Do you have any other backups available? If not, you may want to try repairing the InnoDB using the instructions in the following thread if the database still exists in it's corrupted state:

    InnoDB Corruption Repair Guide

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Aug 24, 2016
  5. ruzbehraja

    ruzbehraja Well-Known Member

    Joined:
    May 19, 2011
    Messages:
    392
    Likes Received:
    11
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    One possibility is that before restoring that table, you have missed

    Code:
     mysql> SET FOREIGN_KEY_CHECKS=0;
    But if your backup is not complete, then there's no question of trying to restore it successfully.
     
    #5 ruzbehraja, Aug 26, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - Restoring Database Backup
  1. greatwitenorth

    Restoring accounts from backup and database users

    greatwitenorth, Jan 15, 2019 at 10:31 AM, in forum: Data Protection
    Replies:
    2
    Views:
    71
    cPanelLauren
    Jan 17, 2019 at 12:19 PM
  2. Ezequiel Lima

    Restoring incomplete database?

    Ezequiel Lima, Dec 28, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    118
    cPanelMichael
    Dec 29, 2018
  3. Martin Hinrichsen

    Restoring Backups Fails With Not Stored Locally Error

    Martin Hinrichsen, Jan 12, 2019, in forum: Data Protection
    Replies:
    1
    Views:
    110
    cPanelMichael
    Jan 15, 2019 at 10:39 AM
  4. ImperialTrader

    Restoring account backup (Home Directory) issue

    ImperialTrader, Oct 7, 2018, in forum: Data Protection
    Replies:
    19
    Views:
    455
    ImperialTrader
    Oct 11, 2018
  5. Dedan Irungu

    Restoring Accounts from /home Folder due to corruption

    Dedan Irungu, Oct 3, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    161
    cPanelLauren
    Oct 8, 2018

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.
    Accept Learn More...
    Dismiss Notice