MySQL Backup and Restore Commands for Database Administration

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.95/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Ravi Saive

I am Ravi Saive, creator of TecMint. 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. Follow Me: Twitter, Facebook and Google+

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

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

44 Responses

  1. siva says:

    Hi Ravi, backup and restore commands are really useful.

    I was looking for the command to know the backup status. can you please help on that.

    • Ravi Saive says:

      @Siva,

      There isn’t any command that shows backup status, you need to check manually after taking backup manually or through script…or you can set a ‘mail to’ in script to get email notification once backup is complete..

  2. Bashir Deen says:

    This is such a helpful article with regarding to mysql backups.
    thanks.

  3. 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..

  4. Cyrille Tarla says:

    Thanks this was really good and it did help me alot

  5. Gibran says:

    How to repair single database and all databases

  6. 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 !

Got something to say? Join the discussion.

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