Knowledge Base
MilesWeb / MySQL

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

Approx. read time : 2 min

Uploading browser-based file can fail in case the file size that you are trying 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 want you can get the web-based terminal access in cPanel).

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

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:

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 MilesWeb 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.

Also Read:

How to Optimize a MySQL Database Using SSH?

How To Create MySQL Tables In phpMyAdmin?

Avatar
Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent 4.8 out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna