his 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 your Account 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.