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.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Curmudgeon
Registered User
Posts: 32
Joined: Thu Jun 14, 2012 9:51 am

Recovering from a crash

Post by Curmudgeon » Tue Dec 13, 2016 4:23 pm

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 Member
Community Team Member
Posts: 6754
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Recovering from a crash

Post by JimA » Tue Dec 13, 2016 5:34 pm

The tool phpMyAdmin is not usable for importing large database back-ups, try Bigdump. :)
Knowledge Base - Using Bigdump to restore large database dumps
Image Jim Mossing Holsteyn - Community Team Member
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: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Recovering from a crash

Post by Lumpy Burgertushie » Tue Dec 13, 2016 5:55 pm

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 am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

Curmudgeon
Registered User
Posts: 32
Joined: Thu Jun 14, 2012 9:51 am

Re: Recovering from a crash

Post by Curmudgeon » Wed Dec 14, 2016 12:13 am

Thanks! I'll give it a go.

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: Sogou [Spider], Yahoo [Bot] and 64 guests

cron