Restore

in this wiki we have  Backing up and restoring  Database from local server and external server,

Backup Database

Backup from local server

mysqldump -u{username} -p{passoword} {database} | gzip > {path}/backup_filename_$(date +%F).sql.gz

Backup from external server

mysqldump -P {port} -h {host} -u{username} -p{passoword} {database} | gzip > {path}/backup_file_name_$(date +%F).sql.gz

Backup specific tables

mysqldump -u{username} -p{passoword} {database} table1 table2 > {path}/table1_table2.sql