Dynamic
websites are becoming popular day by day. If you have a dynamic
website, you are always interested to upgrade that website and add new
features for all the website visitors. Instead of doing these type of
modifications to the live website, I always recommend you to take a back
up all of your full site and install it to your local computer and just
implement the new features which you like to add for your live website.
For doing these, you need to setup a local site on your computer with a
server. To do this, we use a web server, a database and files of that
site. Like me, most users often use wamp like server. So, you just take
the database back up of your live server and then firstly like to import
that database to your local database. But you do all the steps and at
last find the 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. I faced this problem few hours ago when I just copy the database of my website www.hideMyTips.com
and try to import to my local computer database. The size of the
database is not so much and it was like 10MB. Don't worry. If you face
this type of problem, you will get the solution here. In this page, I
will discuss the solution of the problem during database uploading to
your local computer.
If you face this type of problem to upload your large database to your local computer or if you face the error like
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.1, then just try the settings in
C:\wamp\bin\apache\apache2.2.8\bin\php.ini. We just need to find the
following things in the php.ini file:
- post_max_size = 8M
- upload_max_filesize = 2M
- max_execution_time = 30
- max_input_time = 60
- memory_limit = 8M
The above settings are the default settings of php.ini file. Now, we just change the above things like the followings:
post_max_size = 1000M
upload_max_filesize = 1000M
max_execution_time = 10000
max_input_time = 10000
memory_limit = 500M
post_max_size = 1000M
upload_max_filesize = 1000M
max_execution_time = 10000
max_input_time = 10000
memory_limit = 500M
When
you have completed the above settings, then save the file php.ini. Now,
restart the wamp server to take effect with the new configuration.
After completing these steps, try to upload your database again and you
will be able to upload your database to the local computer database or
solve the problem 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.
Thanks!
RispondiEliminaOnly don't forget to restart WAMP to apply the changes.
Cheers!