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.

backup doesn't restore mysql

Discussion in 'Data Protection' started by uadm, Jan 20, 2014.

  1. uadm

    uadm Well-Known Member

    Joined:
    May 19, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    We have a daily backup of all our sites. We tried to restore one account today but the database was not restored. We paid attention to marking "restore mysql" but eventualy we had to restore the database using pma.

    In /usr/local/cpanel/log/error_log we see:
    warn [whostmgr5] program "/usr/local/cpanel/3rdparty/attracta/scripts/pkgacct-restore" is not executable at /usr/local/cpanel/Cpanel/Hooks.pm line 199
    not sure if that's related but anyhow...


    Please advise.

    Thanks.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    What method did you use when restoring the account? Did you notice any particular error messages in the UI or command line output during the restore process itself?

    Thank you.
     
  3. uadm

    uadm Well-Known Member

    Joined:
    May 19, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    I go to
    Backup Restoration
    |
    Restore by Account
    |
    pick date
    |
    Additional Options

    Restore Subdomains
    Restore Mail Configuration
    Restore MySQL

    Add Account to Queue

    Restore

    it's working then it show Completed

    It restore the files in homedir but the mysql database isn't updated.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  5. uadm

    uadm Well-Known Member

    Joined:
    May 19, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    ticket number is 4460655
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To update, it was determined this issue was isolated to accounts that existed before the restore process started. Thus, the databases were not overwritten. This is the intended behavior of the new backup system, however a feature request is open to change this behavior:

    Overwrite existing MySQL database on backup restore | cPanel Feature Requests

    In the meantime, the workaround is to remove the databases from the account before restoring the backup archive.

    Thank you.
     
Loading...

Share This Page