How to Backup and Restore a MySQL database using mysqldump

How to Backup and Restore a MySQL database using mysqldump

## To dump the database "javauser" at server sisifo:
[javauser@sisifo MYSQL]$ mysqldump -u root -padm3FEDORA javauser > sisifo_javauser_dump.sql
[javauser@sisifo MYSQL]$

## Transferring the dump file sisifo_javauser_dump.sql from server sisifo to server thanatos:
[javauser@sisifo MYSQL]$ sftp javauser@thanatos
Connecting to thanatos...
sftp> put sisifo_javauser_dump.sql
Uploading sisifo_javauser_dump.sql to /home/javauser/sisifo_javauser_dump.sql
sisifo_javauser_dump.sql                                                                                                              100%   21MB  21.3MB/s   00:01
sftp> quit

[javauser@sisifo MYSQL]$

## To restore the database "javauser" at server thanatos, using this file sisifo_javauser_dump.sql:
mysql> use javauser;
Database changed

mysql> source  sisifo_javauser_dump.sql