Backup e restore mysql

Backup:

mysqldump -u NOMEUSUARIO -p PASSWORD database > PATH_PARA_BACKUP

Exemplo:

mysqldump -u root -p PASSWORD dotproject > C:\dotproject.backup


Restore:

mysql -u NOMEUSUARIO -p PASSWORD < path/do/arquivo.sql

mysql -u sadmin -p pass21 Customers < custback.sql