backup and restore mysql

Backup all databases

mysqldump -u [mysql_user] -p [mysql_user_password] --all-databases > /home/user/backups/databases.sql

Backup mysql single database

mysqldump -u [mysql_user] -p [mysql_user_password] database > /home/user/backups/databases.sql

Backup mysql two databases

mysqldump -u [mysql_user] -p [mysql_user_password] --databases databases1 databases2 > /home/user/backups/databases.sql

Backup mysql a specific table

mysqldump -u [mysql_user] -p [mysql_user_password] database table_name > /home/user/backups/table_name.sql

Restoring mysql

mysql -u [mysql_user] -p [mysql_user_password] database < /home/user/backups/databases.sql