If you’re ever moving big mysql databases around using PHPMyAdmin, you’ll probably fall into trouble when uploading due to file size limitations. (Downloading is no probs.) If you’re a command line jockey or php.ini expert, you can mostly likely handle this quandary with ease. But I ain’t that geeked, yet. Though it’s definitely on my to-do to up my skills in comman line mysql.
Recently I was duplicating a client blog site on my local machine to investigate an XML-RPC bug and I wanted to get the entire database loaded up, despite it being of huge proportions – something like 50MB. PhpMyAdmin on localhost wasn’t letting me upload anything over 2MB – after some time futzing with php.ini files to no avail, I started searching Google for an alternative solution. Soon enough I found Big Dump, a smooth little php scrit that safely staggers your database upload in sections. During first attempt I got an error because I had exported the DB with extended inserts. But after re-exporting the DB without this option the upload worked fine.