Mysql error
Hi, I am getting an interesting MySQL error that I have never incountered before and need some help. Can someone please let me know what is going on here?
Warning: Lost connection to MySQL server during query in D:/xxx/xxx.php on line 3
Warning: MySQL Connection Failed: Lost connection to MySQL server during query in D:/xxx/xxx.php on line 3
From what I have read so far on this error, it means that something is corrupted and not allowing mysql to fully process.
Do I need to re-install MySQL?
Thanks,
Zimbabwe
Peter J. Boettcher posted this at 00:52 — 30th October 2002.
They have: 812 posts
Joined: Feb 2000
Could be a lot of different things, check out the following link: http://www.mysql.com/doc/en/Gone_away.html
Hopefully that will help out.
Mark Hensler posted this at 07:26 — 30th October 2002.
He has: 4,048 posts
Joined: Aug 2000
Timeout was the first thing that came to mind (as mentioned in the link Peter posted).
What are your current specs? (OS & version, mysql version, php version, etc.)
What is the query your executing when this happens?
Is your PHP script connecting to a local mysql DB, or remote?
Mark Hensler
If there is no answer on Google, then there is no question.
zimbabwe2002 posted this at 15:10 — 30th October 2002.
They have: 8 posts
Joined: May 2002
From reading the link that was sent by peter, and from checking my mysql version, i found that I did have some corrupt tables and that my version was not the latest. I backed up and upgraded to the latest version of mysql and that fixed the problem. I was connecting remotely using the latest version of php on a windows 2000 platform. It brought up the error no matter what query i did, whether it be selecting, inserting, updating, etc.
But anyways, thanks for you help
caale posted this at 01:20 — 24th December 2002.
They have: 15 posts
Joined: Dec 2002
Well I have come across that in my own machine,god knows I get all the errors..(HAHA)I got that error before and what I had was corrupt table so what I did to fix was...I deleted the whole database(say I was running a database called nuke)I deleted that whole database and recreated the new database called "nuke" with the user and password and then went to SLQ tab and browsed for the "nuke.sql" file and then pressed GO and it was working again..hope this helps
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.