How to dump MySQL database and split into 10 MB files on the fly
A useful trick if your server's configuration is weird
This is more like a note than an article, but I think it might be useful for someone.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.
After some trial and error I came up with the following solution for *nix systems:
mysqldump -uLOGIN -pPASSWORD DATABASENAME | split -b 9000000 - dump
This command will dump the whole DATABASENAME into a series of files.
Comments