Can't connect to MySQL server on 'localhost'

[XStealth6]

:confused:I keep getting the following:


mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on 'localhost' (10048)
E:\inetpub\vhosts\d3gaming.com\httpdocs\includes\c lass_core.php on line 311
On my website D3gaming.com

happens atleast once a month.
my host isn't telling me much, but it's irratating because they're telling me all they do is recycle the mysql service and it's working.

So i'm thinking it's an issue with the host and not my site.
They also claim it may be an issue with my database, So here i am just looking for some insight. I need to get this corrected, even if i have to pay someone.

Any Ideas?

[Dismounted]

The error is caused by the MySQL server being down. This is in-line with your host saying they are restarting the service. Most likely - someone happens to view your forum while the service is restarting.

[XStealth6]

The error is caused by the MySQL server being down. This is in-line with your host saying they are restarting the service. Most likely - someone happens to view your forum while the service is restarting.



Hey Dismounted,

Thank you for responding. I am begining to be a bit concerned with the frequency of this problem. Currently i am using a shared hosting because my website is not that big. I am concerned that if i continue with their service/server That this may be a constant thing.

Is this normal for something like this to happen monthly? Obviously there has to be something causing it. I am just trying to cover my base and make sure it's not my site.

PS. I just wanted to add, Currently the problem is intermitent. I can load the page, then randomly get a database error, the site automatically emails me the error and it's the same error every single time.

[Dismounted]

It depends on your host - it's usually routine to restart services such as MySQL though, to clear up some memory.

[Marco van Herwaarden]

The MySQL errorlog might reveal the reason.

[XStealth6]

This is what i got.





E:\Program Files\SWsoft\Plesk\Databases\MySQL\Data\d3gaming_v b>myisamchk -c *.MY

I

Checking MyISAM file: adv_modules.MYI

Data records: 6 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check record links



---------



Checking MyISAM file: adv_pages.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check record links



---------



Checking MyISAM file: adv_setting.MYI

Data records: 122 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'adv_setting.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: adv_settinggroup.MYI

Data records: 3 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'adv_settinggroup.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: itrader.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check data record references index: 3

- check data record references index: 4

- check record links



---------



Checking MyISAM file: itrader_comments.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check data record references index: 3

- check record links



---------



Checking MyISAM file: language.MYI

Data records: 1 Deleted blocks: 1

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'language.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



myisamchk: error: 'post.MYI' doesn't have a correct index definition. You need t

o recreate it before you can do a repair



---------



Checking MyISAM file: postedithistory.MYI

Data records: 78 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'postedithistory.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: ppgal_categories.MYI

Data records: 1 Deleted blocks: 2

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check record links

myisamchk: error: Found wrong record at 68

MyISAM-table 'ppgal_categories.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: ppgal_customfields.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: ppgal_customfields_entries.MYI

Data records: 40 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1



---------



Checking MyISAM file: ppgal_ecards.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: ppgal_exif.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: ppgal_favorites.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference



---------



Checking MyISAM file: ppgal_filetypes.MYI

Data records: 0 Deleted blocks: 0

myisamchk: warning: Table is marked as crashed and last repair failed

- check file-size

myisamchk: warning: Size of indexfile is: 3072 Should be: 1024

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'ppgal_filetypes.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



myisamchk: error: 'ppgal_images.MYI' doesn't have a correct index definition. Yo

u need to recreate it before you can do a repair



---------



Checking MyISAM file: ppgal_moderator.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check record links



---------



Checking MyISAM file: ppgal_permissions.MYI

Data records: 2 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1



---------



Checking MyISAM file: ppgal_posts.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check data record references index: 3

- check data record references index: 4

- check record links



---------



Checking MyISAM file: ppgal_rate.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: ppgal_search.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: ppgal_setting.MYI

Data records: 122 Deleted blocks: 1

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'ppgal_setting.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: ppgal_settinggroup.MYI

Data records: 14 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'ppgal_settinggroup.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: ppgal_stats.MYI

Data records: 60 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1



---------



Checking MyISAM file: ppgal_subscribecat.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference



---------



Checking MyISAM file: ppgal_subscribeimage.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference



---------



myisamchk: error: 'socialgroup.MYI' doesn't have a correct index definition. You

need to recreate it before you can do a repair



---------



Checking MyISAM file: thread.MYI

Data records: 207 Deleted blocks: 2

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check data record references index: 3

- check data record references index: 4

- check data record references index: 5

- check data record references index: 6

- check data record references index: 7

- check data record references index: 8

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'thread.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: tmnt_comments.MYI

Data records: 5 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'tmnt_comments.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: tmnt_members.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: tmnt_players.MYI

Data records: 2 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'tmnt_players.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: tmnt_teams.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: tmnt_tmnts.MYI

Data records: 1 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 0

MyISAM-table 'tmnt_tmnts.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: userfield.MYI

Data records: 121 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



---------



Checking MyISAM file: zoints_tag.MYI

Data records: 244 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links

myisamchk: error: Found wrong record at 2120

MyISAM-table 'zoints_tag.MYI' is corrupted

Fix it using switch "-r" or "-o"



---------



Checking MyISAM file: zoints_tag_update.MYI

Data records: 84 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1



---------



Checking MyISAM file: zointstags_search.MYI

Data records: 0 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check record links



Now , the problem is finding out which of these tables correlate to what?

I see that zoints tags is corrupted from what they're telling me but would that be enough to bring down an entire board?