mysqldump -h localhost -u user -ppassword -r/tmp/mysql_backup.data nomdatabase

mysql -h localhost -u user -ppassword nomdatabase < /tmp/mysql_backup.data