Open the \xampp\php\php.ini file and change this line (about 735) to look like this
- Code: Select all
post_max_size = 16M
You may need to increase the size depending on the largest import sql file you have but do not increase it greater than the line at about 886 upload_max_filesize currently set at the default of 128M
After editing the php.ini file save it and then restart Apache and MySQL and in the import tab in phpMyAdmin you should now see the maximum file has changed from Max: 8MiB to Max: 16MiB if using my example above.
I just tested this on my 1.7.7 installation and it showed the above increase in maximum file size.
Just to add, if you get a time out when importing a large database then you would need to change these 2 lines to read something like 300 seconds from the defaults of 30 and 60 seconds
- Code: Select all
max_execution_time = 300
max_input_time = 300
and as usual save and restart Apache and MySQL.
Let me know back if that helps your case.
Good luck.