MySQL Backup and Restore
Jump to navigation
Jump to search
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