How to dump MySQL database and split into 10 MB files on the fly
Recently I had to dump a database that was too big to dump with with phpMyAdmin and I couldn’t just use mysqldump tool from command line because there was a 10 MB file size limit on the server.
How to increase 2MB limit on import in phpMyAdmin?
PhpMyAdmin by default allows you to import only 2 MB file. In many cases this is just way too little.
In order to increase the values you need to alter your php.ini settings.
