sql error

[a7aa7a]

[13:11:14.109] > WARNING: max_allowed_packet might be set too low for binary map
storage.
[13:11:14.109] Use the following query to raise max_allow_packet: SET GLOBAL max
_allowed_packet = 16776192;

 

[Limos]

Increase the value of max_allowed_packet in my.ini (UniServer/usr/local/mysql/my.ini) and restart.

 

[a7aa7a]

i am using mysql but i can't understand what you mean

 

[Limos]

Open the file my.ini in your uniserver folder. Go to usr, local, mysql and there you find my.ini.
You can use ctrl f to find max_allowed_packet and then increase that value.

 

[a7aa7a]

i dont have uniserver folder folder or i dont know where i can find it

 

[Limos]

If you use XAMPP for mysql, then look in that mysql folder.

 

[a7aa7a]

then after mysql folder

 

[Limos]

xampp/mysql/bin/my.ini

 

[a7aa7a]

dont have it

 

[Limos]

Just type in search in your xampp folder: my.ini.

 

[a7aa7a]

i swer i cant find it

 

[Limos]

Type my.ini in the search bar in your xampp folder, or you can also type it in search at start.

 

[Printer]

Just go to your phpmyadmin and execute the query in the database:

SET GLOBAL max_allowed_packet = 16776192;

 

[a7aa7a]

still the same error @Printer

@Limos
i have found 2 lines but in file called (MY) not my.ini
1-
[mysqldump]
quick
max_allowed_packet = 16M

2-
[mysqld]
basedir = "C:/xampp/mysql/"
datadir = "C:/xampp/mysql/data/"
port = 3306
socket = "MySQL"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

 

[Limos]

Increase the value of the part you made red.

 

[a7aa7a]

max_allowed_packet = 1M >> max_allowed_packet = 10M
like this ?

 

[Evil Puncker]

yes but to 16m

 

[a7aa7a]

the same
[16:58:00.421] > WARNING: max_allowed_packet might be set too low for binary map
storage.
[16:58:00.421] Use the following query to raise max_allow_packet: SET GLOBAL max

 

[Limos]

Restart MySQL aswell, not only your server.