Troubleshooting

------_=_NextPart_001_01C6D73D.60E80754
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

I have installed MYSQL recently on Windows 2000.=20
I was developing an web application used MYSQL as back-end.
But frequently getting the error :MySQL server has gone away

I searched in net and found that MYSQL will go down after 8 hours, if
nobody uses the server.
How to make server runs always?

Best Regards,
ganapathi



------_=_NextPart_001_01C6D73D.60E80754--

Re: Troubleshooting

On 9/13/06, Ganapathi Hegde (RBIN/ECM4) wrote:
> Hello,
>
> I have installed MYSQL recently on Windows 2000.
> I was developing an web application used MYSQL as back-end.
> But frequently getting the error :MySQL server has gone away
>
> I searched in net and found that MYSQL will go down after 8 hours, if
> nobody uses the server.
> How to make server runs always?
>

I NEVER heard of this time limit, we have a server running 24/7 that
has no access at all in weekends and it does not go down after 48
hours of no use. Whoever said/wrote this, it is so WRONG!

We need more info to help you, like MySQL version, and the query that
generates the error, are you using PHP and storing persistent
connections?

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Troubleshooting

--------------enigB5871FE0EB1336AF8C48881D
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

> Subject: Troubleshooting
> From: "Ganapathi Hegde (RBIN/ECM4)"=20
> Date: Wed, 13 Sep 2006 19:33:24 +0530
>=20
> Hello,
>=20
> I have installed MYSQL recently on Windows 2000.=20
> I was developing an web application used MYSQL as back-end.
> But frequently getting the error :MySQL server has gone away
>=20
> I searched in net and found that MYSQL will go down after 8 hours, if
> nobody uses the server.
> How to make server runs always?
>=20
> Best Regards,
> ganapathi

Install mysql as a windows service. If you are using the automatic
install, select the option which says Install as a Service. If manual
install, use

$mysqld-nt --install mysql5 --defaults-file=3DC:\MySQL\my.ini =09
--local-service


--------------enigB5871FE0EB1336AF8C48881D
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBRQoEAbXBHi2y3jwfAQqDtgf+I0cbCiwMkg/6Dc9Sr+NbqZxgt5Qa q0/K
S6lmp46q+4myAH8c/LIJI0vZnkUpUNYix1JsPDXZaniDNc4LWOmX6WoIiUjy qN0i
6X/rnkrCcbJSWNjI+Tq9Ex3nCRaT/mK7yF2sTRRDr8Xwr+adaPYG+nylHKi9 83ro
vKg0rhZgXJvRcTLP939qBQxSKExuRtlxVd3qcEblL6Y95DzJUODcqPyae5pn E9X8
gYzO2t7Jhoc0eWt86plBNfsPU9gGign9TCc28269V67GtQXITf+BJGaBoIBY LoFw
0+tW/Jr9dsY2X8EA4gq4NSndopvD66rVyXYwgQuIJCdCRRAc189TCQ==
=EIH2
-----END PGP SIGNATURE-----

--------------enigB5871FE0EB1336AF8C48881D--