by colbyt » 08. March 2008 17:10
I was fairly frustrated when I posted the message above as I could not import a rather small file (41KB).
While searching for the answer to the question I posted above I found a lot of people experiencing this problem; but, I found no definate answers.
According to the posts I read there are 3 factors that may affect the ability of phpmyadmin to import lagre files. All of them are set in in php.ini. According to one post I read here the post_max_size may need to be larger than the upload_max_filesize The default settings for the Xampp distribution is the same as the defaults and they are:
memory_limit 32M
post_max_size 16M
upload_max_filesize 32M
What I discovered was that changing the values in the php.ini file which is located in the PHP directory had absolutely no affect on the values recognized by phpmyadmin. Maybe there is a glitch in my installation or maybe not. Copying that file to the phpmyadmin also did not work.
When I copied the php.ini file to the main Xampp directory the new values were read and utilized. I had no problem importing I used the following values in the php.ini:
memory_limit 128M
post_max_size 128M
upload_max_filesize 96M
Next I plan to see what values I need to import a really large dump of 401KB. If there is any interest, I will update this thread afterwards.
Colbyt