Xampp - PHPMyAdmin upload large files?

Question

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

Answer 1

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

Answer 2

Source: How to Import Large Database Files in XAMPP

Make changes in xampp\php\php.ini

Look for the following:

post_max_size       = 8M
upload_max_filesize = 2M
max_execution_time  = 30
max_input_time      = 60
memory_limit        = 8M

then replace the lines with the following:

post_max_size       = 750M
upload_max_filesize = 750M
max_execution_time  = 5000
max_input_time      = 5000
memory_limit        = 1000M

Restart your XAMPP after making the changes, if you are still seeing the same error – try restarting your computer.

Answer 3

Try to import the MySQL data via commandline if possible.

mysql -u user -p database < dump.sql