Fri. Mar 29th, 2024

Step #1: Open mydatabase.sql
Just calculate how many lines between 2 “INSERT INTO… VALUE

Step #2: Open bigdump.php file
Change define from 300 to 800
define ('MAX_QUERY_LINES', 800);
//How many lines may be considered to be one query (except text lines)

Step #3: Then start run “bigdump.php” file again.

dumplargedatabaseresult

Notes:  If it stops again, go back to that line and find the number of lines between two “INSERT INTO… VALUE”; re-change the define line above.

bigdump_avoidstopatlineerror

The above image is the result after successful dump my large database file.

*** Remember removing your dump file and bigdump script from server right now.

P.S.:

  • Where to get Bigdump?  Just go to –http://www.hotscripts.com/listing/bigdump/
  • Who is author of this file? –http://www.ozerov.de/bigdump/usage/
  • In case you need text editor to open the large file which our regular text file couldn’t handle it.  I tried to open my large database file in text editor NotePad, but it failed, so I’m using Edit Plus instead.  To get EditPlus executor, just go to  –http://download.cnet.com/EditPlus/3000-2352_4-10018241.html
  • How to Import a Large WordPress Database — An Alternative to phpMyAdmin
    — Part 1 of 2: https://www.youtube.com/watch?v=iWsbOqd-1v4
    — Part 2 of 2: https://www.youtube.com/watch?v=meTSX2qVan4
(Visited 166 times, 1 visits today)

Leave a Reply