Support Login

How do I import my MySQL database via command line or shell? Print

  • 0

For databases larger than 100MB, we suggest uploading via the command line using Terminal in cPanel.

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?

« Back