No dump or Big Dump?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
DV1
Registered User
Posts: 333
Joined: Sun Jul 11, 2010 8:49 pm
Location: Nevada
Contact:

No dump or Big Dump?

Post by DV1 »

I'm transferring the forum to a new server/host.

In a video tutorial it was mentioned that max on importing a database was 32MB, anything over that then BG is needed. Yet the phpBB thread re transferring a forum to new server/database says Big Dump would be needed if the database is over 2 MB. My forum database is less than 32MB yet over 2MB. Can someone please clarify this?

Thank You
User avatar
Lumpy Burgertushie
Registered User
Posts: 68294
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: No dump or Big Dump?

Post by Lumpy Burgertushie »

don't know where you saw a max of 32MB .

the thing is that php ( not phpbb ) has a default max upload size of 2MB. that is a server setting and you can't do anything about it unless you have access to the server setup files.

therefore, things like bigdump can be used to import/restore a database backup bigger than 2MB because it breaks the file up into smaller chunks and automatically uploads them one after the other.

How to use BigDump to restore your phpBB database.


The best way I have found to restore a phpbb database ( or any other mysql database) is to use a program named BigDump:
Big Dump
http://www.ozerov.de/bigdump.php
It is free and makes restoring mysql database files of any size a breeze.
Download it and unzip it to your computer.

Follow these steps to restore your database backup file using BigDump:

1. Copy your current config.php to your computer

2. Open the bigdump.php file in a text editor ( wordpad is fine )

3. Where it asks for the database info, put in what is in your config.php file
bigdump.php:

Code: Select all


// Database configuration

$db_server   = "your info here";
$db_name     = "your info here";
$db_username = "your info here";
$db_password = "your info here";
Now, in the bigdump.php file, make sure these two settings are as
follows:

Code: Select all

$linespersession  = 3000;
$delaypersession  = 300;
then save the file.

4. Using ftp, go to your server and create a folder in your phpbb folder, name it dump.

5. Upload your backup sql file and the bigdump.php file to that "dump" folder

6. In your browser, go to: yourdomain.com/yourphpbb/dump/bigdump.php

You should see the name of your backup file and a link to start the restore

Click on that link and wait. It will take some time for large files, but as long as you get no errors and
it does not stop, you will get a success message.

7. When you have a successful restore, be sure to delete or rename the dump folder as it is a security issue if you don't.

That is all there is too it.
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?
DV1
Registered User
Posts: 333
Joined: Sun Jul 11, 2010 8:49 pm
Location: Nevada
Contact:

Re: No dump or Big Dump?

Post by DV1 »

Thanks, LB.

I will follow your suggestion. Btw, I've also read here and there about "extended inserts" should that be checked or unchecked in the backup to be transferred?

And here is the video re the 32MB. 25 seconds into it.

http://wesbos.com/import-large-mysql-da ... gdump-php/
User avatar
Lumpy Burgertushie
Registered User
Posts: 68294
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: No dump or Big Dump?

Post by Lumpy Burgertushie »

bigdump will not work with a database backup file that has extended inserts.

you need to make sure your backup file has the whole INSERT line and then the values etc. like this:

Code: Select all

INSERT INTO `phpbb_categories` (`cat_id`, `cat_title`, `cat_order`) VALUES (1, 'Test category 1', 10);
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
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Re: No dump or Big Dump?

Post by noth »

I have just used this for the first time ever

I noticed that final MB is about 9 x the MB that phpmyadmin tells you it is, anyway IT WORKS
Elias wrote:Have a read at the following:
Knowledge Base - Using Bigdump to restore large database dumps

Thanks
thank you to Elias for reminding me of the above, the only tweak I had to do was
Syntax to use when inserting data:
include column names in every INSERT statement
Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
insert multiple rows in every INSERT statement
Example: INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
both of the above
Example: INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)
neither of the above
Example: INSERT INTO tbl_name VALUES (1,2,3)
my phpmyadmin on old host was by default set to both of the above

I changed it to just include column names in every INSERT statement in the old host phpmyadmin, otherwise it wouldn't work

save the database again, big dump then worked perfectly

when you go to the BIG DUMP site there is a paypal icon, I just fired $50 to the author ALEXEY. the bloke is a genius!! after all these years his script is still as good :mrgreen: top man
aeneas1
Registered User
Posts: 451
Joined: Wed Jan 27, 2016 5:58 pm

Re: No dump or Big Dump?

Post by aeneas1 »

EDIT: resolved by host (siteground), their security blocked the script, they temporarily removed it which gave me immediate access to the bigdump.php directory...

i get this page when trying to access the bigdump.php file (root/dump/bigdump.php)"

The page you are trying to access is restricted due to a security rule.

if i put root/dump in the address bar i get:

Index of /dump
[ICO] Name Last modified Size Description
[PARENTDIR] Parent Directory -
[TXT] backup_1470584220_36..> 2016-08-10 08:04 80M
[ ] bigdump.php 2016-08-10 04:53 38K

any thoughts?
User avatar
Lumpy Burgertushie
Registered User
Posts: 68294
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: No dump or Big Dump?

Post by Lumpy Burgertushie »

siteground is known for having some strange server setups.

if this won't work, then you can try a program called mysqldumper you can get here:
http://www.mysqldumper.net/
you install it on your server and then use it for database backups /restores etc.

however, I would contact support and find out why the bigdump does not work on your server. I have used it on many different hosting company server setups over the years and have never heard of anything like this.


robert
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
Mick
Support Team Member
Support Team Member
Posts: 22919
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket probably.

Re: No dump or Big Dump?

Post by Mick »

I've followed the transferring your board and bigdump tutorials hundreds of times using both the new and old phpMyAdmin and bigdump settings and I've never had a failure unless it was my fault with typo's etc.
"The more connected we get the more alone we become" - Kyle Broflovski©
Locked

Return to “[3.0.x] Support Forum”