MySQL Backup and Restore Commands for Database Administration

If you have any questions or problems regarding this article and want help within 24 Hours? Ask Now

Support TecMint: Did you find this tutorial helpful?. Please help to keep it alive by donating. Every cent counts! - Donate Now

Ravi Saive

Simple Word a Computer Geek and Linux Guru who loves to share tricks and tips on Internet. Most Of My Servers runs on Open Source Platform called Linux.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

Receive Your Free Complimentary eBook NOW! -

Download Free Linux eBooks

Advanced Bash-Scripting Guide
Linux Bible
A Newbie's Getting Started Guide to Linux
Introduction to Linux - A Hands on Guide

You may also like...

41 Responses

  1. Tad Osborn says:

    Your last item regarding mysqlimport is not accurate. Two problems:
    1) < character is not used
    2) mysqlimport is for importing text files (csv) and the file name needs to be the table name. The program will automatically use the string in front of the period as the table name…so it errors out because it can't find a table named rsyslog in the database rsyslog.

    • Ravi Saive says:

      @Tad,

      Thanks for pointing out, yes it should be mysql or mysqladmin for restoring databases. I will make the changes as suggested..

  2. Cyrille Tarla says:

    Thanks this was really good and it did help me alot

  3. Gibran says:

    How to repair single database and all databases

  4. Abmysql http://www.abmysql.com is a free web service,
    with abmysql you can run automatically some backup when you want on a secure server (provide by abmysql) and to another FTP server, google drive, Dropbox,etc.

    Try now http://www.abmysql.com, it’s free !

Leave a Reply

Your email address will not be published. Required fields are marked *

Join Over 95000+ Linux Users
  1. 66,682
  2. 3,836
  3. 31,647

Enter your email to get latest Linux Howto's