changes in my.cnf not taking effect? max_allowed_packet prob

Irgendwelche Probleme mit XAMPP für Mac OS X? Dann ist hier genau der richtige Ort um nachzufragen.

changes in my.cnf not taking effect? max_allowed_packet prob

Postby psychomachine » 22. February 2006 19:35

hi.

i'm trying to execute a large sql script (2MB), and I'm getting a max_allowed_packet error. which makes sense.

so I changed the value of max_allowed_packet to 8M in my.conf, but now when i do

show session variables

the value displayed is

1048576

why is the change not taking effect? is there anything else i can do? i'm still getting the same error when i try to execute the script.

all best,
psych
psychomachine
 
Posts: 15
Joined: 05. August 2005 11:09

Return to XAMPP für Mac OS X

Who is online

Users browsing this forum: No registered users and 3 guests