| View previous topic :: View next topic |
| Author |
Message |
Mikor
-
Joined: 21 Aug 2006
Posts: 144
Location: Hull, England
|
 Posted: Thu Sep 14, 2006 5:18 pm Post subject: Problem connecting to MySQL |
 |
|
First of all:
1) All the database details are correct.
2) this has worked perfectly up until today.
Every time I run a php script that uses mysql, the mysqld application terminates and I get a php error message
eg: | Code: | select * from v2_posts where forum = 1 and reply = 0 order by last_reply desc
Lost connection to MySQL server during query |
I can access mysql though the command prompt, but not php
_________________
Yarrt.com - Free Arcade
RypNet.co.uk - Online Game
MSN: michael_walker_2004 <at> hotmail <dot> com |
|
| Back to top |
    |
 |
AbyssUnderground
-
Joined: 31 Dec 2004
Posts: 3855
|
| Posted: Thu Sep 14, 2006 5:42 pm Post subject: |
|
|
Have you tried restarting the pc and/or reinstalling mysql/php?
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
| Back to top |
 |
|
Mikor
-
Joined: 21 Aug 2006
Posts: 144
Location: Hull, England
|
| Posted: Thu Sep 14, 2006 6:47 pm Post subject: |
|
|
| AbyssUnderground wrote: | | Have you tried restarting the pc and/or reinstalling mysql/php? |
Yep
_________________
Yarrt.com - Free Arcade
RypNet.co.uk - Online Game
MSN: michael_walker_2004 <at> hotmail <dot> com |
|
| Back to top |
|
|
loloyd
-
Joined: 03 Mar 2006
Posts: 435
Location: Philippines
|
| Posted: Fri Sep 15, 2006 6:11 am Post subject: |
|
|
try repairing and optimizing those tables including v2_posts in mysql administrator
_________________
 http://home.loloyd.com/ is online if the logo graphic at left is showing. |
|
| Back to top |
|
|
Mikor
-
Joined: 21 Aug 2006
Posts: 144
Location: Hull, England
|
| Posted: Fri Sep 15, 2006 4:20 pm Post subject: |
|
|
I can optimize all the tables EXCEPT v2_posts, it just loses the conenction
_________________
Yarrt.com - Free Arcade
RypNet.co.uk - Online Game
MSN: michael_walker_2004 <at> hotmail <dot> com |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Sat Sep 16, 2006 12:46 pm Post subject: |
|
|
| Mikor wrote: | | I can optimize all the tables EXCEPT v2_posts, it just loses the conenction |
Try using MySQLAdmin to perform these tasks.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
Mikor
-
Joined: 21 Aug 2006
Posts: 144
Location: Hull, England
|
| Posted: Sat Sep 16, 2006 3:58 pm Post subject: |
|
|
| aprelium wrote: | | Mikor wrote: | | I can optimize all the tables EXCEPT v2_posts, it just loses the conenction |
Try using MySQLAdmin to perform these tasks. |
Nope, still loses the connection
_________________
Yarrt.com - Free Arcade
RypNet.co.uk - Online Game
MSN: michael_walker_2004 <at> hotmail <dot> com |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Sun Sep 17, 2006 3:08 pm Post subject: |
|
|
Mikor,
We recommend that you post the question in that case on a specialized forum (MySQL.com). MySQL gurus will certainly help you with that odd problem.
Please keep us updated about it.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
Mikor
-
Joined: 21 Aug 2006
Posts: 144
Location: Hull, England
|
| Posted: Sun Sep 17, 2006 5:30 pm Post subject: |
|
|
Right, i've asked here and included a link to this topic, hopefully this will be fixed soon.
_________________
Yarrt.com - Free Arcade
RypNet.co.uk - Online Game
MSN: michael_walker_2004 <at> hotmail <dot> com |
|
| Back to top |
|
|
loloyd
-
Joined: 03 Mar 2006
Posts: 435
Location: Philippines
|
| Posted: Mon Sep 18, 2006 4:12 am Post subject: |
|
|
In the meantime, try cloning the table v2_posts and renaming the old problematic one to something else. Then rename the clone to v2_posts. See if you can now repair and optimize the cloned one and check if your systems work properly now.
When doing your cloning and if the table v2_posts is not that big, try dumping its contents in an external SQL file. And then restore that SQL file to your new empty clone table. Hopefully, when you dump from the original table v2_posts, this wouldn't lose connection. If it does lose connection, see if you can manually mine data from v2_posts. If you are even unable to open v2_posts - even in MySQL Query Browser - then your table seems gravely corrupted. Don't worry though, as hope is not all lost. You can wait for more authoritative responses from the MySQL forum.
If you're too afraid to clone a table in the same database, then you could consider cloning the entire database and renaming the old database to something else, then renaming the cloned database to the working database name.
These steps make it easy for you to revert to your old but problematic table/database, then trying later on a new solution.
_________________
http://home.loloyd.com/ is online if the logo graphic at left is showing. |
|
| Back to top |
|
|
Mikor
-
Joined: 21 Aug 2006
Posts: 144
Location: Hull, England
|
| Posted: Fri Sep 22, 2006 4:23 pm Post subject: |
|
|
Not even the MySQL guru's can fix my problem - my database appears to be lost forever :(
And I didnt make a backup, OR write down the database structure, damn, i'll have to re-code my forum system from scratch... again.
_________________
Yarrt.com - Free Arcade
RypNet.co.uk - Online Game
MSN: michael_walker_2004 <at> hotmail <dot> com |
|
| Back to top |
|
|
|
