You can also use Terminal in cPanel to import a .sql file if phpMyAdmin does not work for you, using the following command:

 

> mysql -p -u username database_name < file.sql

 

username = The database user

database_name = The database you are trying to import to

file.sql = The .sql file you are trying to import

 

You will be prompted for a password and the password is the database user you entered.

Was this answer helpful? 0 Users Found This Useful (0 Votes)