Zayin Krige

Pretty straightforward

To compress mysqldump output :

mysqldump -uroot -psome_password db_name| gzip -c > db_name.gz

or alternatively, to compress it to a file on another host

mysqldump -uroot -psome_password dbname | gzip -c | ssh user@host -p22 'cat > /root/db_name.sql.gz'

To restore a database from a compressed file

gunzip < db_name.gz | mysql -uroot -psome_password db_name

Bookmark It

Hide Sites

1. zayinkrige says:

   February 16, 2011 at 11:29 am

   New Blog Post -> Gzip mysqldump output and gunzip it for import – http://www.zayinkrige.com/gzip-mysqldump…
2. Yossi says:

   March 7, 2011 at 10:40 am

   That’s awesome, thanks !
3. Sam says:

   March 23, 2012 at 6:48 pm

   THANKS!!!
4. Bash script to zip all files with mysqldump | Programming Notes says:

   May 3, 2012 at 10:59 am

   [...] source: http://www.zayinkrige.com/gzip-mysqldump-output-and-gunzip-it-for-import/ [...]
5. Bala says:

   August 23, 2012 at 1:19 pm

   Thank u so much…… it is very usefull…..:)
6. Backup de mysql con gzip « Blog de Mario Javier says:

   January 11, 2013 at 7:26 pm

   [...] http://www.zayinkrige.com/gzip-mysqldump-output-and-gunzip-it-for-import/ Me gusta:Me gustaSe el primero en decir que te [...]