1 A database dump :
mysqldump -u username --password=***** --databases db_name --add-drop-database --set-charset --default-character-set=UTF8 > ~/dbdump.sql
2 Create a TAR archive
tar -czvf db_name.tar.gz dbdump.sql
3 Securely Transferring dbdump.sql between a local and a remote host
scp ./db_name.tar.gz root@00.000.000.000:~/tmp
4 Connect to a server
ssh root@00.000.000.000
cd /tmp
5 Extracting the file from a tar file:
tar -xvf db_name.tar.gz ./
6 Import database from sql dump file
mysql -u db_name -p < ~/tmp/dbdump.sql