» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2006, 06:23 AM
Antoine Antoine is offline
Junior Member
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Antoine is on a distinguished road
Default myisamchk error

Hi all,
I have some trouble with some tables.
When we try to repair this problem we've got:

>myisamchk -e domaineinstances.MYI

Checking MyISAM file: domaineinstances.MYI
Data records: 365096 Deleted blocks: 0
- check file-size
myisamchk: error: Size of datafile is: 17524388 Should be: 17524580
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found key at page 17312768 that points to record outside datafile
- check records and index references
myisamchk: error: Record-count is not ok; is 365092 Should be: 365096
myisamchk: warning: Found 365092 parts Should be: 365096 parts
MyISAM-table 'domaineinstances.MYI' is corrupted
Fix it using switch "-r" or "-o"

When have this kind of problem, alternatively

-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Revenue Sharing Ads ( ?):
  #2  
Old 08-18-2006, 06:28 AM
Ivy Ivy is offline
OSP Addicts
 
Join Date: Jul 2006
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 18
Ivy is on a distinguished road
Default

You need to follow the advice >Fix it using switch "-r" or "-o"<
Without these switches no real repair is done. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 1064 (42000).... imaan MySQL Forums 1 12-19-2006 04:18 AM
Error in select statement speedy PHP Programming and Tips 1 08-19-2006 10:32 AM
mysql error: error 28.... Jaida MySQL Forums 1 08-16-2006 06:34 AM
Error 1335 frenzy MySQL Forums 0 12-09-2005 05:52 AM
ASP Error Codes - Description dam Introductions 1 12-07-2005 10:09 AM


All times are GMT. The time now is 11:33 AM.