MySQL Backup and Restore

Backups

Backup all databases

# mysqldump -p -uroot --all-databases > [sql_server_name].sql

Backup a specific database

# mysqldump -p -uroot [database name] > [database name].sql

Restore

Restore from a MySQL Dump

# mysql -p -uroot [database name] < [database name].sql

Further Reading

Backing up and Restoring Your MySQL Database