If you ever tried to import a huge database to your localhost installation, you might have experienced the following error:
No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.
That above code basically means that your import failed since there was no data received by phpMyAdmin to import int your database. However, the reason lies in the next line. It is:
In order to fix this, first, we’ll need to make sure we have named the database file correctly. Just reload the page and try to import it again. If this fails again, then it means you will need to increase the upload limit set on your database. Now, there are times when you cannot increase the maximum upload limits for whatever reason. In such situation, you can follow the following steps to manually import the
.sql file into your database.
mysql/bindirectory present in your WordPress installation. Usually, the path would be
mysql -u root -p db-name < db-file.sql
You can use a different username instead of root, if you've already created a different user. You also need to replace
db-file.sql with the proper database name and sql file name respectively
\mysql\bindirectory in your xampp folder
-pin the next line)
mysql -u root -p
/path/to/sql/db-file.sql with the database name and the full file path along with the file name of the sql file that you're trying to import respectively
Please leave a comment if you have any issues following the above steps, or if you want to provide any feedback regarding this post.