MySQL Database Import Is Failing, Reason: The .sql File Is Too Big

When attempting to upload a browser-based file, it may not succeed if the file size exceeds the HTTP post size limit set on the web server.

If this occurs, all it takes to restore your MySQL database is to connect into your account using an SSH client (you may also use cPanel’s web-based terminal access if you’d like).

Check out the instructions below to import the.sql database file after creating the database and the database user in cPanel:

1. Using an FTP client or the cPanel File Manager, upload the .sql file to your /public_html directory.

2. Then start a terminal client (PuTTy, etc.) and connect to your account.

3. Execute the below command in the console:

mysql -u mysql_user -p mysql_db < public_html/database.sql

Ensure that you replace mysql_user with your database username, mysql_db with your database name, and database.sql with the name of.sql file that you have uploaded.

4. Enter the MySQL user password and click on your enter key.

Now, if you don’t get an error in your terminal client, it indicates that the database import was successful.

If there is still trouble importing your database after following these steps, please open a ticket in Hostvento and include the .sql file name and the name of the database you want to import to. Our support team will assist you with the import.