One way to create a backup of a mysql database on the shell is to use the mysqldump command. Mysqldump creates a dump of the database in form of sql commands.

Backup

mysqldump -u root -p mydatabase > /tmp/backup_mydatabase.sql

This command creates a backup of the database with the name "mydatabase" in the file /tmp/backup_mydatabase.sql

Restore

To restore the backup, use the command:

mysql -u root -p mydatabase < /tmp/backup_mydatabase.sql

Tagged on:     

One thought on “Backup and restore mysql databases on the shell

  • July 14, 2016 at 3:56 pm
    Permalink

    this gave error: The ‘<' operator is reserved for future use.

    Reply

Leave a Reply

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

*