Apache Friends Support Forum

Xampp for windows (non-installer version).

No matter what I modify in php.ini, I can not seem to raise the allowed import size in phpmyadmin avove 16.???kbi.

Am I not reading or doing something right?

I need to import some large dumps at the local level.


Colbyt

I need to import some large dumps at the local level.

Why don't you use the MySQL command line client?

if you need importing via the web you may want to read phpmyadmin/Documentation.html#faq1_16 (try the upload_dir feature and/or "BigDump").

p.s.
make sure to edit apache/bin/php.ini and don't forget to restart the webserver.

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

sari42 wrote:p.s.
make sure to edit apache/bin/php.ini and don't forget to restart the webserver.

I see!

I was editing the wrong php.ini file!

Thanks!