Pages

Backup and Restore Mysql Database using mysqldump Command

mysqldump is a effective tool to backup and restore mysql databases. Using mysqldump command we can backup one or many databases or tables.

You have to use command prompt[Windows users] or kernel[Linux users,MacOS] to backup databases.

Backup Mysql Database

  • Backup a single database
mysqldump -u root -p[root_mysql_password] [database_name] > [path_to_save_with_sql_extension]

ex:
mysqldump -u root -p123 test > D:/backups/test_backup.sql


  • Backup Multiple databases
mysqldump -u root -p[root_mysql_password] --databases [database_name] [database_name] .. > [path_to_save_with_sql_extension]

ex:
suppose we have two databases called test and tutorial
mysqldump -u root -p123 --databases test tutorial > D:/backups/test_tutorial.sql


  • Backup all the databases

mysqldump -u root -p[root_mysql_password] -all-databases > [path_to_save_with_sql_extension]

  • Backup a specific table 
Suppose we have a demo table in test database.

mysqldump -u root -p123 test demo \ > D:/backups/demotables.sql

Restore Mysql Database

To restore mysql database use following command.

mysql -u root -p[root_mysql_password] [database_name] < D:/backups/test.sql

These can be useful for backup and restore mysql databases.
Labels: ,

6 comments:

  1. Abdul KareemFebruary 17, 2013 at 8:34 PM

    does this commands use for all mysql version on windows.

    ReplyDelete
    Replies
    1. UnknownJanuary 9, 2022 at 6:07 AM

      Great Article android based projects

      Java Training in Chennai Project Center in Chennai Java Training in Chennai projects for cse The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training Project Centers in Chennai

      Delete
  2. Abdul KareemFebruary 17, 2013 at 8:35 PM

    I am using mysql 5.1

    ReplyDelete
  3. Mind Therapy - Open universeJuly 1, 2013 at 1:58 AM

    i have this error using sql restore..

    'mysql' is not recognized as an internal or external command,
    operable program or batch file.

    help me.
    tnx u
    lahiru

    ReplyDelete
  4. UnknownMay 22, 2016 at 1:06 PM


    Nice Article !
    This is my pleasure to read your article.
    Really this will help to people of MySQL Community.

    I have also prepared one article about, perform backup and restore MySQL database using mysqldump tool.
    You can also visit my article, your comments and reviews are most welcome.
    http://www.dbrnd.com/2016/01/mysql-backup-and-restore-database-using-mysqldump/

    ReplyDelete
  5. Harry jacobDecember 7, 2019 at 3:52 AM

    feliz año nuevo 2020 Thanks for sharing I like this post because we can get some useful information from your blog.

    ReplyDelete

Subscribe to: Post Comments (Atom)