Print Page - has any1 seen my-sql server ??

Title: has any1 seen my-sql server ??
Post by: plop on 14 March, 2004, 02:11:39

 Database nuke  - Table nuke_bbposts_text  running on localhost

Error

MySQL said:

#2006 - MySQL server has gone away

i need him and he didn't tell me where he went. lol

plop

Title:
Post by: lynyrd on 14 March, 2004, 11:38:45

humm tricky problem..
maybe he was running on a locohost
or on date with mrs.sql
i just hate when that happens ;)

Title:
Post by: [NL]Pur on 14 March, 2004, 11:43:45

rofl

#2006 - MySQL server has gone away

sorry

maby it's this:

http://www.nukecops.com/postt22957.html (http://www.nukecops.com/postt22957.html)

Title:
Post by: plop on 14 March, 2004, 23:00:07

QuoteOriginally posted by [NL]Pur
rofl

#2006 - MySQL server has gone away

sorry

maby it's this:

http://www.nukecops.com/postt22957.html (http://www.nukecops.com/postt22957.html)

hey thx, that was indeed the problem, the file i was triggering on the database was 1.5MB.
didn't get that error earlyer tho the file was 6.5MB, but phpnuke didn't save the backup correct.
before it got 2 the 1MB mark a error was found.
sadly i can't change it as it's a hosted website, and i hope they don't crash again.
took me a couple hours 2 stuff the backup back into the sql server. snif snif.

plop

Title:
Post by: [NL]Pur on 14 March, 2004, 23:45:16

np

nice too hear your mysql got back again after a few hours ;)

Title:
Post by: plop on 15 March, 2004, 00:29:52

QuoteOriginally posted by [NL]Pur
np

nice too hear your mysql got back again after a few hours ;)

yep seems he was on a lunch break. lol

for every1 using phpBB or phpnuke, there is a bug in a couple phpMyAdmin versions which causes the backup 2 be saved incorrect.
mostly this are missing end's on the inserts, you can fix this by placing '); on the end of those broken entry's.
beside this there can be even full insert commands missing, just copy the above insert and fix the entryname and the number.
next step 2 do is remove all table constructors, as the unused contructors are missing.
when you do this you can run the original sql script 2 build all the tables.
it's a terrible job 2 do but @ least you can place the backup back in the database.
and offcourse cut the backup file into pieces of less then 1 MB.

plop

Title:
Post by: BlazeXxX on 15 March, 2004, 04:22:46

Apparently, if you have Zend Optimizer installed on your server / pc with phpnuke or postnuke.. it causes mysql server to crash. Update Zend Optimizer to latest one, that was out two days ago to get over this.

All of our servers went bezerk yday. This also affects phpBB forums as well.

PtokaX forum

Stuff => Offtopic => Topic started by: plop on 14 March, 2004, 02:11:39