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.
- Using a FTP client, upload your SQL file to your root directory /home/username/
- Start PuTTy or your favourite terminal client.
- Connect to your primary domain name with a port number of 22
- Enter your cPanel username and password when prompted
- 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.**
- 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.