I am having troubles importing my SQL database, it’s too big!

This can happen as the HTTP post size is limited to a smaller number. The best way to restore your SQL database is by logging into your account using a SSH client. Be sure that you’ve already created your MySQL Database from inside of the control panel before continuing.

  1. Using a FTP client, upload your SQL file to your root directory /home/username/
  2. Start PuTTy or your favourite terminal client.
  3. Connect to your primary domain name with a port number of 22
  4. Enter your cPanel username and password when prompted
  5. Once logged into a console, run the following command: mysql -u your_mysql_user -p your_mysql_db < /home/username/sqlfile.sql **Ensure you replace the fields with your db username/database name and location of the sql file.**
  6. Enter in your mysql user’s password and press enter.

If you are still having troubles importing your database due to size, please open a ticket from inside yourAccount Manager and include details of the .sql filename and which database you would like imported to and one of our agents will complete this for you.