How do I import a database (Command Line)?

**SSH access is needed for this process. For this you may raise a support ticket and request the same.

Also you will need the file in .sql format, meaning it can not be compressed in a .zip or .tar.gz file.

1) Once you have your sql file you will need to upload it to your server.

2) You will need to create the database if you have not done so already.

3) Once this database is created and your .sql file is on the server log into the server through SSH

4) Once in SSH navigate to the directory where your .sql file is.

5) Once there run this command:

# mysql -uusername -ppassword database_name < file.sql

Note:There is no space between '-u' and the username, or between '-p' and the password

username is the username of the user with rights to the database if you are unsure what the is you can use your username you used to sign into SSH.

Password also follows same guide lines.

Make sure your database name has your username prefix with the _ (underscore) after it and the database name.

This command with ONLY work if you are in the directory where the .sql file is.

6) Execute this command and your database will import.

 

If you have any problems submit a help ticket.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Do you allow remote MySQL access in your servers?

Yes, to manage your databases remotely you will need to add an "access host" via the MySQL...

Do you provide PostgresSQL for your accounts?

Yes. We do provide PostgresSQL interface for all cPanel users.- CSpace Hostings /...

Do you support MS SQL?

No, we do not support MS SQL.- CSpace Hostings / https://cspacehostings.com

How do I connect to my database using a program?

If you wish to administer your database from your own computer, via a program like navicat or...

How do I create a MySQL back-up?

1. First log in to your Cpanel 2. Click MySQL Databases 3. Click phpMyAdmin 4. Click Export...