SQL file too big for phpMyAdmin? No problem!

The other day I was confronted with a problem, a 109MB SQL file. The problem was (and still is) phpMyAdmin won’t accept anything bigger than 51,200KB and my file was over twice that.

I was about to go hunting for the shell command to import my file, but I stopped and thought, “Somebody must have created something in PHP to do this”.

And there was my answer, Big Dump!

Yeah the name conjured up some strange images in my head too…

…But anyway.

It’s just one PHP file that took me 2 seconds to upload. Just point your browser at the file, big dump reads all the files in the directory and determines whether it is a file that can can be imported into MySQL. You just click import and you can enjoy the import process with a progress bar (something that phpMyAdmin could benefit from).

The tool was created by Alexey Ozerov and you can download it at http://www.ozerov.de/bigdump.php

Filed under: Helpful resources, echo 'Programming'; by Ryan