Xampp Shell command

ToDie4

Well-known member
(hopefully it's cool to discuss localhost issues here!)

I need some help with a problem please, I have asked this before but I am still having problems in Xampp (localhost) with the styles template cache rebuild causing a time-out error (says maximum packet size exceeded) every time I create a new style or delete a new style on my xendev site on local-host (I have 23 styles installed there).

Every time I work with styles on my dev site I have to run a Xampp shell command:
Code:
SET GLOBAL max_allowed_packet=512*1024*1024;

The command line I am executing is not changing anything permanently on my Xampp environment, I am reasoning my command line is faulty. Does anyone know the correct command line or lines I should be using to avoid this time out problem on a more permanent basis please.
 
Would you mind sharing what you did to resolve this?

No, of course I wouldn't mind sharing.

Turns out I was using version 1.7.3 which had some problems, so I upgraded to Xampp 1.7.4 which actually turned out to be version 2.5 (lost me there too), any way, there are several files that need editing to overcome the packet size problem:

windows/my.ini
increment max_allowed_packet (suggest min 32M)

xampp/bin/my.ini

increment max_allowed_packet (suggest min 32M)

xampp/php/php.ini-production

increment post_max_size (suggest min 32M)
increment upload_max_filesize (suggest min 32M)


xampp/php/php.ini

increment post_max_size (suggest min 32M)
increment memory_limit (suggest min 32M)
increment upload_max_filesize (suggest min 32M)


xampp/mysql/my-huge.ini

increment (2 instances of!) max_allowed_packet (suggest min 32M)


xampp/mysql/my-innodb-heavy-4G.ini

increment (2 instances of!) max_allowed_packet (suggest min 32M)


xampp/mysql/my-large.ini

increment (2 instances of!) max_allowed_packet (suggest min 32M)


xampp/mysql/my-medium.ini

increment (2 instances of!) max_allowed_packet (suggest min 32M)


xampp/mysql/my-small.ini

increment (2 instances of!) max_allowed_packet (suggest min 32M)


xampp/phpmyadmin/libraries/config.default.php

increment value of $cfg['ExecTimeLimit'] (suggest 36000)

I hope this is of help to some of you, wasn't easy tracking this lot down I can tell you. :)
 
Top Bottom