How to backup MySQL Database in command line with compression

advertisement

For those who looking for way to backup mysql database,
you can use mysqldump to backup mysql database.

Below is the script example to backup mysql database in command line:-

If your mysql database is very big, you might want to compress your sql file.
Just use the mysql backup command below and pipe the output to gzip,
then you will get the output as gzip file.

If you want to extract the .gz file, use the command below:-

Technorati Tags: , , , , , , , , , , ,

Related posts:

How to install LAMP (Apache, PHP and MySQL in Linux) using Yum
How to create mailing list in Thunderbird
Debian: "There is no public key available for the following key IDs"
How to extract .deb file in Linux / Mac
How to disable ssh root login?
Symfony 1.4: How to sort foreign key record?
How to move Firefox tab bar to bottom
How to sort drop down - Admin Generator - Symfony 1.4






14 Responses to “How to backup MySQL Database in command line with compression”

  1. Bruno says:

    Perfect thx :)

  2. Fisher says:

    much easier way is using any convenient gui tool like dbforge studio for mysql to make a backup.

  3. Luis Pichardo says:

    Thank you for the tip, much appreciated. I use to move big MySQL backups and sometimes you cannot handle those with phpmyadmin.

  4. chad says:

    why says not helpful when majority said the better results out of that command?

  5. Chris says:

    Hi,

    Having installed xampp in my pc, I am ready to work on my various large database or dump files before I upload them to the live webhost/server.

    1. Now, how do I load a large database into the database created in phpmyadmin in xampp on my pc using mysql shell command??
    I have tried using phpmyadmin but was not successful due to exceeding the max limit.

    2. once it has been loaded successfully, then I can export or backup this same large database/dump again but this time, I want to backup into smaller parts (say there are total 30 tables and I want to backup into 3 x 10tables ) total 3 parts.
    How can I do this and what’s the shell command path or command strings to do such?

    Thank you in advance for any kind guidance and assistance.

    Regards,
    Chris

  6. Aus says:

    Very good! I’ll use it in my backup script:

    #create (if not exist) backup folder
    mkdir -p /home/aus/project_bak
    cd /home/aus/project_bak

    # backup the project software
    tar cvf $(date +%Y-%0m-%0d_%0H%0M.CPP.bak.tar) /home/aus/Project

    # backup the web application
    tar cvf $(date +%Y-%0m-%0d_%0H%0M.WEB.bak.tar) /var/www

    # Thanks to Techie Corner, back up the database
    mysqldump -hlocalhost -uroot -proot users > $(date +%Y-%0m-%0d_%0H%0M.sql)

  7. pjammer says:

    what kind of ass says not helpful? geeks. I liked this and was helpful.

  8. Nick says:

    obvious but still helpful, thanks

  9. oztrout says:

    works for me … thank you … :)

  10. Stefan says:

    Thanks bro!

  11. vinayak says:

    well, im using mysql query browser, and i want to update fields and tables, so.. how can i back up my old field contents?? i dont want to retype them

  12. rr says:

    well, im using mysql query browser, and i want to update fields and tables, so.. how can i back up my old field contents?? i dont want to retype them

  13. Matt says:

    was helpful

  14. aa says:

    not helpful at all!

Leave a Reply