Backup and Restore Database MySQL

For backup all databases

  mysqldump -u username -ppassword --all-databases > /tmp/alldatabases.sql

For backup spesific database

 mysqldump -u username -ppassword --databases databasename > /tmp/filename.sql

For restore

mysql -u username -ppassword databasename < /tmp/filename.sql