URGENT - Why failed to restore backup from remote server?

SuperBaby

Well-Known Member
Nov 27, 2003
343
0
166
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.
 

SuperBaby

Well-Known Member
Nov 27, 2003
343
0
166
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
 

larry2148

Member
Aug 16, 2006
6
0
151
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.