SQL ERROR

[niraklas]

paw na valw to backup mou kai m bgazei error (mysql server has gone away ) 3erei kaneis tpt ?

[pirama]

mipos den exeis bali sosta tin ip h to port sto nav?

ti pack exeis?

[niraklas]

ola ok einai alla m bgazei afto to error mipos epidi einai megalo to sql file?

[pirama]

mazi ma ayto (mysql server has gone away) soy bgazi kai kapio odiko dld error 2006 ?

an nai pios einai o kodikos? gt mexri twra problima sindesis moy kolaei :(

 

den nomizw na einai epidi einai megalo to backup

mipos exeis kateyasi etimo pack kai exei diko toy updater mesa?

[niraklas]

to error einai (2006) m to bgazei 2 fores kiolas to pack m to edwse enas filos m etoimo me ola ta sql se ena backup alla otan paw na valw to sql afto to error exw :/

[pirama]

rikse mia matia edw http://bogdan.org.ua/2008/12/25/how-to-fix-mysql-server-has-gone-away-error-2006.html

 

apo oti katalaba einai to wait_timeout = 600 prepei na to megalosis se wait_timeout = 6000

[niraklas]

dn exei wait time out  :/ p to vriskw ?

[pirama]

sto c:/programfile/mysql/my.ini <-- to anigis me notepad

[niraklas]

dn exei mesa afto to time out

[niraklas]

exw to 5,1 version

[pirama]

an den to exei bres to --- max_allowed_packet= 64M

kai grapse apo kato

max_allowed_packet= 64M

wait_timeout= 6000

 

kane rr to mysql an den doylepsi kai ayto . h moni lisi poy kserw einai na perasis to mysql 5.5 ...

h to idio mysql me to opoio egeine to backup..

[niraklas]

tha valw to 5,5

[niraklas]

pali to idio error

[pirama]

opote twra pigene sto my.ini kai kane tin allagi....

[niraklas]

afto me to max allowed packets emena to exei sto my-huge

[niraklas]

kaneis allos dn 3erei tpt?