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}
Written by Vincent Lamanna
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#