From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Fri Jul 01 2005 - 10:34:38 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello.

Follow recomendations from:
  http://dev.mysql.com/doc/mysql/en/repair.html

After repairing with -r -q command line options, try just with -r.

TheRefUmpnetscape.net wrote:
> Hi,
> I will give the output below. I just ran an insert of a small amount of data into Windoz/MySQL 5.0.6. Then, I ran a "myisampack" agains it. Finally, I ran a myisamchk against it and keep coming up against this error:
> Found wrong record at 687081
>
> Now, I'm the only one who has access to this database. What's is going on? Can anyone help me?
> Enclosed is the output of each step below.
>
> Regards,
> George
>
> E:\MySQLData\5.0.6\sdidw>myisampack -v --tmpdir=e:\workdir table.MYI
> Compressing table.MYD: (100349 records)
> - Calculating statistics
>
> normal: 9 empty-space: 0 empty-zero: 1 empty-fill: 9
> pre-space: 0 end-space: 0 intervall-fields: 4 zero: 14
> Original trees: 55 After join: 32
> - Compressing file
> Min record length: 39 Max length: 58 Mean total length: 46
> 77.63%
> Remember to run myisamchk -rq on compressed tables
>
> E:\MySQLData\5.0.6\sdidw>myisamchk --tmpdir=e:\workdir -rqp --sort-index --analyze mytable.MYI
> - check record delete-chain
> - parallel recovering (with sort) MyISAM-table 'mytable.MYI'
> Data records: 100349
> - Fixing index 1
> - Fixing index 2
> - Fixing index 3
> - Fixing index 4
> - Fixing index 5
> - Fixing index 6
> - Fixing index 7
> - Fixing index 8
> - Fixing index 9
> - Fixing index 10
> - Fixing index 11
> Found wrong record at 687081
>
> E:\MySQLData\5.0.6\sdidw>
>
> __________________________________________________________________
> Switch to Netscape Internet Service.
> As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
>
> Netscape. Just the Net You Need.
>
> New! Netscape Toolbar for Internet Explorer
> Search from anywhere on the Web and block those annoying pop-ups.
> Download now at http://channels.netscape.com/ns/search/install.jsp
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]