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.

URGENT - Why failed to restore backup from remote server?

Discussion in 'General Discussion' started by SuperBaby, Apr 20, 2010.

  1. SuperBaby

    SuperBaby Well-Known Member

    Joined:
    Nov 27, 2003
    Messages:
    331
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Thailand
    cPanel Access Level:
    Website Owner
    Twitter:
    Due to recent server attack, I have deleted all backup copies under the server (under the secondary hardisk /backup/cpbackup/).

    Today, I accidentally deleted this MySQL file:

    /var/lib/mysql/publish_helpdesk/helpdesk_ticketsWhole.MYD

    I urgently need to restore the whole account (or better still only the above MySQL file).

    I copied the backup (called publish.tar.gz) from my remote backup server and put it under /backup/cpbackup/daily.

    When I tried to restore from WHM, I got this error:

    ==========================================
    Extracting tarball...................
    ...............
    ...............
    ...............
    ...............
    Done

    Extracting Domain....Done

    Sorry, the copy failed. Unable to find the cpanel user file. Is the archive missing (cwd: /backup/cpbackup/daily loaded publish/cp/publish)?
    Account Restore Failed...

    How do I restore the whole account from a copy under the remote backup server?

    I tried to untar publish.tar.gz and it gave me error half way.
     
  2. SuperBaby

    SuperBaby Well-Known Member

    Joined:
    Nov 27, 2003
    Messages:
    331
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Thailand
    cPanel Access Level:
    Website Owner
    Twitter:
    I also found this under the partially untar backup copy:

    -rw-r--r-- 1 root root 7999019 Apr 11 03:10 publish_helpdesk.sql

    Will this restore the WHOLE helpdesk database if I were to upload it under:

    cPanel >> Backup >> Restore a MySQL Database
     
  3. larry2148

    larry2148 Member

    Joined:
    Aug 16, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    yes that .sql is probably a dump of the entire database whereas you only deleted a table it looks like. Regardless probably the best way to try and restore would be to restore that .sql file. If you really want to keep the other data you can hire someone to import only the data you need from that .sql file.
     
Loading...

Share This Page