1. BigDump Staggered MySQL Dump Importer

BigDump Staggered MySQL Dump Importer

  |   6
BigDump Staggered MySQL Dump Importer
To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can’t access the server shell and you can’t import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server.

BigDump does staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

Developer website: http://www.ozerov.de/bigdump/

Instruction:
  1. Bigdump script bigdump.php from the download link
  2. Dump file(s) of your database created by phpMyAdmin I’ll call it my_dle_backup.sql from now on. You can also use GZip compressed dump files, lets call it my_dle_backup.gz.
  3. Access account for your mySQL database
  4. Access account for some web server with PHP 4.1.0 or later installed. This web server must be able to connect to the mySQL database. This ability is probably present if your web server and the mySQL server are from the same ISP.
  5. Some text editor like Notepad to edit the configuration file
  6. Some FTP client to upload the files to the web server
  7. Common knowledge about files, PHP, mySQL databases, phpMyAdmin, FTP and HTTP


Before you upload bigdump.php file to your server, open the file and find:

Add the information for your database server and then upload to your server...

Information!You must register before you can view this text. Please register or Login
The alternative great software is "Mydumper A high-performance MySQL backup tool"
Developer Website and latest version downloads: http://www.mydumper.org/
Dear visitor, you are browsing our website as Guest.
We strongly recommend you to register and login to view hidden contents.

Details

+4

Comments 6

romeoluv56
Commented By romeoluv56 on August 26, 2011 (9:41 am)
Great share thanks, i was using this with my old phpbb forum.
tbenmcp
tbenmcp
DLE TEAM
Commented By tbenmcp on August 26, 2011 (5:58 pm)
yes, I used it a lot lately, even it's still beta but it's simply the best script out there...last night i-386 asked me while he was helping friend, so I gave him this script...small but very powerful and effective...
20 150Forum topics : 11Forum replies : 248Forum likes : 32

"A True Friend is Someone Who Sees the Pain in Your Eyes while Everyone Else Believes the Smile on Your Face"
Let me Google for you!
wadibahi
wadibahi
Members
Commented By wadibahi on January 16, 2012 (10:04 pm)
is this working perfect with DLE BIG DATABASE sites
N/A 1Forum topics : 1Forum replies : 1Forum likes : 0
sawanbanna
sawanbanna
DLE TEAM
Commented By sawanbanna on January 17, 2012 (7:38 pm)
Quote: wadibahi
is this working perfect with DLE BIG DATABASE sites
Tested with 300MB and 1.2 GB database...yes it works
31 409Forum topics : 23Forum replies : 979Forum likes : 150

« Live as if you were to die tomorrow. Learn as if you were to live forever! »
newchap
newchap
V.I.P.
Commented By newchap on February 8, 2012 (1:32 am)
hmmm... im stuck, every time i try to restore progress bar stay the same at 30%-40%. any help..
1 61Forum topics : 6Forum replies : 34Forum likes : 0
sawanbanna
sawanbanna
DLE TEAM
Commented By sawanbanna on February 8, 2012 (1:20 pm)
it maybe the connection issue on your sql server on the fly, if the problem remains, try to increase the server memory and max connection...the possible problems:
- the connection timed out due to idle time limit
- the server or mysqld was shut down or rebooted
- There might possibly be an issue of the MySQL server exceeding resource limits

Possible solution:
- Set max_allowed_packet= to higher number like 16M, 32M, 64M or 128M
- Check the server log for the error that cause the issue...then you can go from there...
31 409Forum topics : 23Forum replies : 979Forum likes : 150

« Live as if you were to die tomorrow. Learn as if you were to live forever! »
Information!Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.