Fix Error Xampp - PHPMyAdmin upload large files

Here i talk about how to Fix Error Xampp - PHPMyAdmin upload large files. I was facing this issue today when uploading 500k++ a CSV data onto MySQL table through PHPMyadmin. A common issue but we're need to concer about.

xampp for large files uploads

If you fall in this error too, just edit php.ini and my.ini file with this parameters.

php.ini

memory_limit=2048M
php_value post_max_size 2048M
php_value upload_max_filesize 2048M

my.ini

key_buffer = 32M
max_allowed_packet = 2048M
sort_buffer_size = 32M
net_buffer_length = 32M
read_buffer_size = 32M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 64M

that's all will solve your problem until now.

The another problem appear when we're using VPS about security and another issue. For retreat that, keep backup anything what you have before make change in any configuration file. When you finish uploading / import the data rollback all config file to before one.

Thanks for reading, hope you find any solution here. Keep trying and uptodate, ok!