Xampp - PHPMyAdmin upload large files?
mysql, phpmyadmin, xampp
Solution
Apply in php.ini
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M
Then restart wamp/lampp/xampp for the changes to take effect It will take long time. If you get following error "Script timeout passed if you want to finish import please resubmit same zip file and import will resume"
Then in phpMyAdmin
phpMyAdmin\libraries\config.default.php
/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 0;
Change it
Problem
I've been trying to upload large data into my testing server, I've modified a few files so far: 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 ``` I can upload larger files, about 50mb, but I still receive the following error when trying to upload files around 200mb: Fatal error: Out of memory (allocated 1161822208) (tried to allocate 462046611 bytes) in C:\Program Files\xampp\phpMyAdmin\libraries\insert_edit.lib.php on line 1879