Web Hosting Forum | Lunarpages

Author Topic: Can't Restore PHPBB  (Read 2940 times)

Offline Greyryder

  • Intergalactic Cowboy
  • *****
  • Posts: 57
    • Quantum Rip
Can't Restore PHPBB
« on: September 23, 2015, 05:28:44 AM »
Through a series of misadventures that could have been prevented, if I'd just kept the thing updated, I have managed to overwrite my forum with a fresh install. I'm still hoping that my IP address doesn't get blacklisted, for all the odd traffic, and FTP log ins.

Anyway; due to the fact that I recently had to have support move my site to a new server, I was able to access the old site with some hosts file shenanigans, and back up the copy of the forum, there. I can't get the forum on the new server to restore from that back up. This is not the database backup in the cPanel. I backed that up before I started the install, but restoring it doesn't seem to have done anything. This is PHP BB's own built in backup and restore function. It starts the process, then gives me this error "Fatal error: Maximum execution time of 30 seconds exceeded in /home/quant17/public_html/forum/includes/acp/acp_database.php on line 2228"

I don't know if this is a setting I can change, or something I'll have to bother support for, or if I'm just SOL. Help? :-?

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6225
Re: Can't Restore PHPBB
« Reply #1 on: September 23, 2015, 08:40:14 AM »
So a PHP script is timing out (exceeds 30 seconds) while trying to restore the database? Is there any reason you can't use phpMyAdmin to directly IMPORT the backup (skipping the PHP script)? If it's the same version of phpBB that you're trying to restore to, you ought to be able to copy the files over and import (restore) the backup. If even that times out, you might have to break up the backup (.sql file) into several chunks, each with part of the tables. You also might have to contact support and get them to relax the timeout interval so the job can go through. They might have to do the restore for you, in that case. If the backup doesn't include commands to create the tables, you'll have to find out database schema is expected, and do something to create the empty tables. Finally, don't forget to update any configuration files in phpBB, for account name, site domain, changed directory structure, or whatever.

If phpBB's backup is not in standard .sql command format, but is some unique data collection, you may be out of luck (phpMyAdmin can't handle it). Maybe support can work with you to relax the time limit this one time.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline Greyryder

  • Intergalactic Cowboy
  • *****
  • Posts: 57
    • Quantum Rip
Re: Can't Restore PHPBB
« Reply #2 on: September 23, 2015, 02:03:30 PM »
I'm pretty sure this is more than a database restore. It's a .gz file. (I could also have saved it as a .zip) I've already tried restoring the database, in the Backup function. I've never been able to figure out how to do anything in phpMyAdmin. It just looks like a lot of things for me to break.

As little used as as that forum was, maybe I should just write it off....

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6225
Re: Can't Restore PHPBB
« Reply #3 on: September 23, 2015, 04:38:29 PM »
It's common for an .sql backup file to be compressed (.gz, .gzip, or .zip format), so you might be able to turn it into an .sql file via gnuzip or some other "unzip" utility. phpMyAdmin might even be able to read it directly, if you haven't tried it already. It might be worth a shot before you throw it away.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline MichaelT

  • Support
  • Jabba the Hutt
  • *****
  • Posts: 579
Re: Can't Restore PHPBB
« Reply #4 on: September 25, 2015, 01:00:58 AM »
I'm pretty sure this is more than a database restore. It's a .gz file. (I could also have saved it as a .zip) I've already tried restoring the database, in the Backup function. I've never been able to figure out how to do anything in phpMyAdmin. It just looks like a lot of things for me to break.

As little used as as that forum was, maybe I should just write it off....

If you have the backup of your database (even if its inside a full cPanel backup) support should be able to extract that and import it into your database for you. Just open a ticket and upload the database file to your account (the .gz .zip or or .sql file) and provide them with the name and location of that file as well as the name of the database to have the backup imported into.

 

Share |