Shared Hosting
with cPanel
 
 Return to "MySQL"

Using SSH to Import and Export your Data and Databases


 
The topic of this article is supported in its entirety by our customer support department.

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


 

Related Articles:


Creating a MySQL Database