can't connect to local mysql

[wreck]

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/rapdome/public_html/frontlinez/forum/admin/db_mysql.php on line 40

thats the error im getting when im tryna log onto my forum. Earlier i had a different error message but our host said there was a problem and they have fixed it and everything worked, but ive just come back on and i get that, and when i go onto the cpanel and click mySQL..... I can't see any databases at all :-s so im totally baffled

[wreck]

heres an image of the mysql on my cpanel so you see what i see

[Colin F]

well your mysql database plainly isn't around, so of course nothing can connect to it

Talk with your host, he probably changed something, or should at least have a backup.

[wreck]

yeah i sent an email before posting this, im just waiting on a reply.

But, for some weird reason it has worked for me just now, and loaded the main forum page. But the instant i went to read my PM's, it does the same thing again :-\

in your includes/config.php file, see for this:

$usepconnect = 0;

if it's set to 0, try with 1 ... if it's 1, set it to 0 .... this may be the cause... some mysql installations are alergic to pconnect...

[wreck]

well its working now, except when trying to post i get this error message which i emailed my host about


Database error in vBulletin 2.2.6:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1476,27755,0),(220,27755,0),(677,27755,0),(39970, 27755,0),(248,27755,0)
mysql error: Can't open file: 'searchindex.MYI'. (errno: 145)

mysql error number: 1016

Date: Thursday 16th of September 2004 08:56:16 AM
Script: http://www.rapdome.com/front-linez/forum/newreply.php
Referer: http://www.front-linez.com/forum/sho...&threadid=2486

hum... your database is corrupted... your MYI (one of the database file related to your structure) is missing, so there system can't archive the db... ask your host to reinstall the last backup ... or you will have to reinstall your site over...

[wreck]

now i dont get that message :-s when i hit submit reply it just freezes and doesnt load anything

so i dont know if they are fixing it or what, i dont know.

[wreck]

Ok this just takes the total utter pi$$ im now back to square one with the very very first error i got before all this started

http://www.front-linez.com/forum/index.php?s=