Recovering from a crash

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Curmudgeon
Registered User
Posts: 66
Joined: Thu Jun 14, 2012 9:51 am

Recovering from a crash

Post by Curmudgeon »

I screwed up while trying to move forum, couldn't recover old forum/site. Have the forum (new install) up on a new host. Wanting to merge the full sql backup I did prior to crashing the forum.

>> Running the same version of phpBB3 as before: 3.0.12
>> Environment: cPanel-2.2.31, Apache-2.2.31, PHP-5.6.27, MySQL-5.6.32, Perl-5.10.1

Tried to use phpMyAdmin but it only wants a file =/< 50Mb. My backup is ~335Mb.

Any suggestions how how to merge the old and new. The new only has 1 forum and it is a unique name as I read in some conditions duplicate names could cause issues.

Thanks for the assist.
User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7819
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Recovering from a crash

Post by JimA »

The tool phpMyAdmin is not usable for importing large database back-ups, try Bigdump. :)
Knowledge Base - Using Bigdump to restore large database dumps
Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.
User avatar
Lumpy Burgertushie
Registered User
Posts: 68181
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Recovering from a crash

Post by Lumpy Burgertushie »

the new one won't matter since it will all be removed and replaced by the import of the old.

Knowledge Base - Using Bigdump to restore large database dumps

if that won't work, then you can use other means:

Knowledge Base - How to backup and restore your database with SSH

or
mysqldumper
https://www.youtube.com/watch?v=12IGNh-WsIw
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
User avatar
Curmudgeon
Registered User
Posts: 66
Joined: Thu Jun 14, 2012 9:51 am

Re: Recovering from a crash

Post by Curmudgeon »

Thanks! I'll give it a go.
Locked

Return to “[3.0.x] Support Forum”