Using SSH to Import and Export your Data and Databases

You can export your database by using the “mysqldump” command.

From the SSH command line, enter the command:

mysqldump your_db_name > your_db_name.dmp

This will push all data from the specified database into a dump file for backup.

To import data from a dump file you can simply direct it into the MySQL command.

mysql your_db_name < your_db_name.dmp

Important Note: Replace your_db_name with the name of your own database