Run away MySQL

**Edwin** · August 6th, 2008, 5:16 PM

Can someone please tie mysql down and put it back in its cage.

Quote:

Fatal error: SQL ERROR [ mysql ]

MySQL server has gone away

**Dan** · August 7th, 2008, 12:25 AM

What script displays that error? lol

**Edwin** · August 7th, 2008, 12:59 PM

It's an update script for phpdvdprofiler, a way of putting my collection of DVD's online. Got some new DVD's and wanted to update the files. Maybe it's time to get another way of doing so.

**Dan** · August 7th, 2008, 1:17 PM

Is it a lot of files that are being updated at one time? Maybe it's timing out while updating?

**Edwin** · August 7th, 2008, 1:25 PM

It's possible. I'm not sure how many there are.

Number of Profiles changed: 119

I guess I need to look further, as this not the place, I guess.

**Neil** · August 7th, 2008, 1:40 PM

Assuming you are under V5 - one obvious help point is
MySQL :: MySQL 5.0 Reference Manual :: B.1.2.9 MySQL server has gone away

There are reports of this problem under linux variants pointing toward an Apache link as re-starting MySql does not provide a cure but re-start Apache does (till it occurs again.)

Also of course the packet/query could be too large / MySql needs a MySql Ping to hold a longer connection.

**cass_is_awesome** · August 8th, 2008, 12:13 PM

That has catchphrase written all over it.

"Leash the Dolphin!"

August 7th, 2008, 12:25 AM	#2 (permalink)
Dan Staff of Surpass Super #1 Joined in Apr 2007 2,742 posts Gave thanks: 151 Thanked 184 times	What script displays that error? lol __________________ D4nz Net - Surpass Help Desk - NES Forever Use the thanks button. It works! AIM: dansorl

August 7th, 2008, 12:59 PM	#3 (permalink)
Edwin Surpassing Dutch Super #1 Joined in Sep 2004 Hosted on SH98 2,533 posts Gave thanks: 187 Thanked 45 times	It's an update script for phpdvdprofiler, a way of putting my collection of DVD's online. Got some new DVD's and wanted to update the files. Maybe it's time to get another way of doing so. __________________ sh98

August 7th, 2008, 1:17 PM	#4 (permalink)
Dan Staff of Surpass Super #1 Joined in Apr 2007 2,742 posts Gave thanks: 151 Thanked 184 times	Is it a lot of files that are being updated at one time? Maybe it's timing out while updating? __________________ D4nz Net - Surpass Help Desk - NES Forever Use the thanks button. It works! AIM: dansorl

August 7th, 2008, 1:25 PM	#5 (permalink)
Edwin Surpassing Dutch Super #1 Joined in Sep 2004 Hosted on SH98 2,533 posts Gave thanks: 187 Thanked 45 times	It's possible. I'm not sure how many there are. Number of Profiles changed: 119 I guess I need to look further, as this not the place, I guess. __________________ sh98

August 7th, 2008, 1:40 PM	#6 (permalink)
Neil Surpass Fan On a golden path... Joined in Oct 2004 Lives in UK 359 posts Gave thanks: 6 Thanked 13 times	Assuming you are under V5 - one obvious help point is MySQL :: MySQL 5.0 Reference Manual :: B.1.2.9 MySQL server has gone away There are reports of this problem under linux variants pointing toward an Apache link as re-starting MySql does not provide a cure but re-start Apache does (till it occurs again.) Also of course the packet/query could be too large / MySql needs a MySql Ping to hold a longer connection. __________________ D17/D21/P59/P62/VPSX - "Faith can move mountains" (Faiths a big girl....) - I'm not paranoid, I know they are out to get me!

August 8th, 2008, 12:13 PM	#7 (permalink)
cass_is_awesome I killed the bus driver. On a golden path... Joined in Mar 2008 Lives in Michigan Hosted on SH138 437 posts Gave thanks: 6 Thanked 8 times	That has catchphrase written all over it. "Leash the Dolphin!" __________________

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread: