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)