Mysqldump – Backup and Restore

Backup

mysqldump -u devise -ppassword -h 127.0.0.1 database_name > backup.sql

Restore

mysql -u -ppassword database_name < backup.sql

Leave a Reply

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