Create database dump
1. Login to the system
ssh <username>@<ip>
2. create a dump
mysqldump --opt -p -u <user> <database> > filename.sql
-p = use a user password
> filename.sql = the file will be created if it not exists
Load database dump
1. Login to the system
ssh <username>@<ip>
2. load a dump
mysql -v -u <user> -p <database> < filename
-v = show the output
< filename = the name of the dump file (can be filename.sql too)