"Restoring Files" Hangup - A Story of Restoring

[AvatarPortal]

Hi all, been a bit since I've been here. Last time I was here though this place proved very helpful. I've searched for an answer to this, but it may require more help.

So here's my current problem: My VPS server corrupted, and then for a good, square, follow-up kick to the giblits, my remote backup of the server corrupted, too. I only run one domain on the VPS and it is this domain I want to restore. I've gotten my WHM back up and I've created my old domain account.

I've been left with a cPanel backup of this account from about 9 months ago. Though I am unsure if it is a home directory or a database. The filename is [account name]_phpb1.sql.gz.

So I've tried to restore it through Backup Wizard > Restore home directory. It runs, then the webpage refreshes to a little icon of a harddrive and the words "Restoring files," and it stays like that. Been that way for the last 20 minutes or so. Then I try Backup Wizard > Restore database. This time it tells me a fatal error occurred.

My ultimate goal is just to restore my phpBB forum from that backup. Everything else I can handle.

As you might have guessed, my experience is limited in this. Any help is appreciated.

 

[Infopro]

The filename is [account name]_phpb1.sql.gz.

That looks like its just the database to me. How large is this file?

Restoring this .gz file should be possible via the Backups section of cPanel > Restore a MySQL Database. If that file is intact and usable of course.

 

[AvatarPortal]

Ah I had figured. It's shy of 70mb. Not large by any means. I do hope it is able to be restored, otherwise the gods really have it out for me.

 

[AvatarPortal]

That looks like its just the database to me. How large is this file?

Restoring this .gz file should be possible via the Backups section of cPanel > Restore a MySQL Database. If that file is intact and usable of course.

I've attempted to restore the backup several ways, still no luck. Any ideas anyone? Much appreciated for the response, Infopro.

 

[Infopro]

Can you go into a few more details? Try unpacking that file locally to make sure the compressed file is not corrupt.

 

[AvatarPortal]

I've unpacked it locally (file ~ 220MB) leaving me with an .sql file. How might I check it is corrupted?

So far, after my server was back up, I restored the sole account on my VPS for my site (I'll call it 'James' for now) with the cPanel software for that account, naming it the same and everything. So I have a James_phpb1.sql.gz file I've been trying to restore using cPanel backup/restore feature but to no avail.

 

[Infopro]

Well, it might be a bit much depending on your computer but you could try opening it like any text file might be opened. 220MB might take a bit of time to open. If it is corrupt you might get some indication of that by viewing it.

Sounds like you manually restored your files.

Do you have root access to this server? If that database is seemingly ok, you might upload it tot he server and restore is via command line logged in as root user.

Assuming you have zero databases setup on this account right now, what happens, what error messages do you get when you attempt restoring it normally?

 

[AvatarPortal]

I've attempted to open it as a text file, though my now 3+ year old laptop is struggling to open it and it's been hung up for about a half hour now.

I do have root, which is how I've restored the James account and cPanel. I've also tried to restore via command line but am likely doing it wrong, how might I do it in this case?

And when I restore via cPanel, it hangs up on "Restoring files" when I try to restore as a database for over a half hour. Perhaps I am just not being patient enough? And it will be the only database I have on that account.