Last Updated: September 09, 2019
·
1.303K
· vlamanna

Effective way of dumping a MySQL Table

This is way faster than a MySQL Dump for a single table as a zipped csv.

mysql --host={DB host} --user={user} --password={password} --quick -e {sql} | sed \'s/\t/","/g;s/^/"/;s/$/"/\' | gzip -9 -c > {file}