If the database is larger than 100MB, use the Terminal command line option in cPanel to upload.

The syntax would be:

 

mysql -p -u user_name data_base < new_databse.sql

 


user_name is your cPanel username

data_base is the database to import to

new_databse.sql is the .sql file you are trying to import

 

You will then be prompted for a password. That will be your cPanel password.

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

Most Popular Articles

Connecting to my database remotely?

MySQL/MSSQL connections to our shared/reseller plans are not supported. To manage your...
My script or app is asking for hostname, what do I use?

Usually, you'll need to enter the following hostname when your script or application requests it:...
What do I use for server address?

For your connection settings for a MySQL database server address, simply use: LOCALHOST