«

»

May
06
2013

How to increase PHP file size import limit for PHPMyAdmin

If you have a local/server installation PHP and MySQL then you might often required to import database backups into your MySQL application. Most of the DB backup file sizes will easily go up to 5-10MB. If you import try to import such backups from some interface such as PHPmyAdmin then you will get an error that the file size exceeds the allowed limit.

The error will look 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…

This limit would also apply if you attempt to upload files into PHP based applications.

To overcome this error you will have to increase the PHP import limit by editing the PHP.ini configuration file.

If you are working with local IIS server then PHP would be installed in default location such as “C\Program files”. For example, in windows 7 the default PHP installation location will be

C:\Program Files (x86)\PHP\v5.4\

Visit this location and open the file named PHP.ini

Search for keyword upload_max_filesize or visit the line number 800 and adjust the value of attribute upload_max_filesize to the value you want. The default import limit will be 2MB.

How to increase PHP/PHPmyAdmin import limit

Now refresh your PHP application or PHPmyAdmin application and try to import your file again. If you still receive the error message about file size limit then you may need to restart your entire IIS service.

[Update] – Even after increasing the upload_max_filesize field if the upload limit sticks around 8MB then increase the value of post_max_size to a higher number

If you are not able to locate the PHP.ini you can simply refer the <?php phpinfo(); ?> code to check the location in the report or simply search on your C: drive for filename PHP.ini

 

Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Current ye@r *