1. Home
  2. Server Questions
  3. MySQL Database Import Is Failing Because The .sql File Is Too Big

MySQL Database Import Is Failing Because The .sql File Is Too Big

Browser-based file uploads can fail if the file size you are attempting to upload is larger than the HTTP post size configuration on the web server.

If a browser-based upload fails, you can restore your MySQL database by logging into your account using an SSH client (or if you prefer, web-based terminal access is available in cPanel).

Once you have created the database and the database user in cPanel, here’s how to import the .sql database file:

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

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

3. Run the following command in the console:

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

Replace mysql_user with your database username, mysql_db with your database name, and database.sql with the name of your uploaded .sql file.

4. Enter the MySQL user password and hit your enter key.

That’s it. If you did not get an error in your terminal client, the database import was successful.

If you are still having trouble importing your database after following these steps, please open a ticket in GreenGeeks and include the .sql file name and the name of the database you are trying to import to. A member of our support staff will assist with the import.

Was this article helpful?

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.