Comando para realizar o backup do Mysql

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql Backup de todas as bases: # mysqldump -u root -ptmppassword --all-databases > /tmp/all-database.sql