Paco

Personal Content Organiser

Home / Linux

Navigation

Menu

Search

MySQL backup and restore

Backup

mysqldump --add-drop-table -h mysql_host -u mysql_user -p mysql_databasename > mysql_db.backup.sql

Restore

mysql -h mysql_host -u mysql_user -p myqsl_databasename < mysql_db.backup.sql