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

• 22 October 2021
• in: MySQL

Uploading browser-based file will fail just in case the file size that you simply try to upload is larger as compared to the HTTP post size configuration on the web server.

In case this happens, your MySQL database can be restored just by logging onto your account via SSH client (or if you would like you’ll be able to get the web-based terminal access in cPanel).

After creating the database and also the database user in cPanel, check the steps below to import the .sql database file:

1. Upload the .sql file to your /public_html directory2 using an FTP client or the cPanel File Manager.

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

3. In the console execute the below command:

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

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

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

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