Maintaining sanity on the Cloud

Saturday, January 10, 2015

Use gzip to achieve upto 80% compression on the mysqldumps

e.g. from link

Export with date:-

$mysqldump -u {user} -p {database} | gzip > `date -I`.database.sql.gz

Import from the export:-

$gzip -dc < `date -I`.{database}.sql.gz | mysql -u {user} -p {database}
Posted by BalaV at 6:44 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

BalaV
View my complete profile

Blog Archive

  • ►  2016 (3)
    • ►  August (1)
    • ►  June (2)
  • ▼  2015 (59)
    • ►  December (1)
    • ►  September (1)
    • ►  May (17)
    • ►  April (11)
    • ►  March (12)
    • ►  February (8)
    • ▼  January (9)
      • Data Transfer Charges incurred on AWS
      • mysql admin command that shows no. of active conne...
      • s3cmd needs "s3:ListAllMyBuckets" action to be all...
      • Using AWS CLI to stop/start instances from the com...
      • Use gzip to achieve upto 80% compression on the my...
      • Instance started from PV AMI's cannot be modified ...
      • At the moment Route 53 does not support querying o...
      • httpd service restart error:(98)Address already in...
      • Use of max_input_vars in php.ini of your php appli...
  • ►  2014 (131)
    • ►  December (5)
    • ►  November (4)
    • ►  October (11)
    • ►  September (12)
    • ►  August (14)
    • ►  July (4)
    • ►  June (14)
    • ►  May (23)
    • ►  April (17)
    • ►  March (27)
Simple theme. Powered by Blogger.