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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Uploading to an Addon Domain

To upload to an addon domain with an FTP client you have 2 options : 1. login via FTP to your...

I've exceeded my Disk Space

Your UK Web Hosting comes with an overall disk quota. If you exceed this quota, some aspects of...

What is an Alias Domain

An Alias domain is a domain that is pointed to your main website. For example, You purchase a...

Changing File Permissions

We recommend that you set your files to 644 and your folders to 755. If you are using a PHP...

Hits And Page Views

Hits are the number of files that are requested from the server. This includes images, graphics,...