Search This Blog

Tuesday, June 26

How to Increase Import Size Limit in phpMyAdmin

I had the same problem with my working correctly by doing the following
changes into the php.ini file
post_max_size = 800M 
upload_max_filesize = 800M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 

If you are working on XAMPP then you can fix the MySQL Server has gone away issue with following changes..
open your my.ini file my.ini location is (D:\xampp\mysql\bin\my.ini)
change the following variable values
max_allowed_packet = 64M
innodb_lock_wait_timeout = 500

No comments:

Post a Comment