Backup and restore database

database.sh

rsync /var/lib/mysql [email protected]:/var/lib/ -a

Or:

//Export Database
mysqldump -uUsername -p Database > db_backup.sql
 
//Export Multiple databases
mysqldump -uUsername -p --databases db_name1 [db_name2 ...] > db_backup.sql
 
//Export All databases
mysqldump -uUsername -p --all-databases > db_backup.sql
 
//Export a table
mysqldump -uUsername -p Database Tablename > table_backup.sql
 
//Export multiple tables
mysqldump -uUsername -p Database Table1 [Table2 ...]  > tables_backup.sql