How to Import Large Database Files in XAMPP

Date Posted: May 10, 2014, 2:03 pm


xampp-max-size-error

Make changes in xampp\php\php.ini

Look for the following:

1
2
3
4
5
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:

1
2
3
4
5
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.

About author


Carl Victor Fontanos

A fine gentleman specializing in front-end and back-end development with extensive experience building high performance web applications that keeps users engaged and help businesses grow.

 
Hire Me