Mysql – PHPMyAdmin Import large (70 MB) file

MySQLPHP

I am trying to import a 70 MB .sql file in PHPMYADMIN but it give me the limit error:

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

I have changed the values of upload_max_filesize, memory_limit and post_max_size in the php.ini and have restarted xampp but its still not working ??? please help

Best Answer

Maybe the phpmyadmin import formulary is block your upload. Look next to upload form field the max value, if it is less then 70mb you can increase it on MAX_FILE_SIZE hidden field.

Related Solutions

Nginx – Broken pipe on nginx

How big is your upload? Did you check the free space on the client_body_temp_path (http://wiki.nginx.org/NginxHttpCoreModule#client_body_temp_path) Or the other nginx client_body* items?

Linux – upload_max_filesize not getting updated after httpd restart

Make sure to edit the right php.ini file. Run the following command to find the right config file -

php -i | grep php.ini

The output will show you the Loaded Configuration File and modify the upload_max_filesize there.

Best Answer

Related Solutions

Nginx – Broken pipe on nginx

Linux – upload_max_filesize not getting updated after httpd restart

Related Topic