Importing Databases via SSH

Here is a quick explanation of how to import a MySQL database that has been dumped into a text file.

1. Create a new database and mysql user in Cpanel. Refer to our Cpanel documentation for more info. Make sure the user has full permissions on the database.

2. Upload your sql file via FTP to the root of your account.

3. Login via SSH and enter the following command...

mysql -u USER -p DBNAME < dump.sql

Where USER is the database user you created, DBNAME is the name of the database you created and dump.sql is the name of the file you uploaded.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Dreamweaver FTP Settings

Dreamweaver uses your standard FTP settings to connect to your website. These were sent to you in...

Uploading Your Site Files

This article is concerned with file management. It outlines the available methods for uploading...

My Site Displays "Index Of"

This is caused by not having a home page file inside your public_html folder - named...

Uploaded Files But Can't See My Site

When you upload your files, make sure you use the correct directory. All the files that you want...

Old Pages At My Site

If you have updated your website but you still see the old pages, double check that you uploaded...