- Start by uploading the .sql file onto the CCIHosting server
- If you haven't already done so, create the MySQL database via the cpanel. Click Here for video tutorial
- Using SSH, navigate to the directory where your .sql file is.
- Next run this command:
mysql -p -u username database_name < file.sql
To import a single table into an existing database you would use the following command:
mysql -u username -p -D database_name < tableName.sql