Hello.
On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote:
> Hello:
>
> I was trying isamchk on my tables. Found one table with deleted blocks.
You know, there would be no reason to repair, except to reclaim the
disk space of the deleted rows?
> Used this option to check:
> ./isamchk -e ~/usr/local/var/events/events.ISM
> ###output###
> Data records: 435 Deleted blocks: 375
> - check file-size
> - check delete-chain
> - check index reference
> - check data record references index: 1
> - check data record references index: 2
> - check records and index references
> ###
>
> And to recover
> ./isamchk -r ~/usr/local/var/events/events.ISM
> ###output msg###
> - recovering ISAM-table '/usr/local/var/events/events.ISM'
> Data records: 435
> - Fixing index 1
> - Fixing index 2
> ###
>
> After fixing the table, the table is showing empty.
Strange. As there are reported 433 records to exist. Did you shutdown
the server while you used isamchk as I recommended in my last mail?
If not, take a backup from the table and start from scratch.
> The .ISD file has got data in that. How can I recover the contents
> in that table or should I use any other command to fix the tables.
No. What you have done should have worked.
Regards,
Benjamin.
[...]
> At 06:47 PM 5/16/02 +0200, you wrote:
[...]
> >Shut down the mysql daemon, run "isamchk" on all tables to find out
> >which are corrupted and run "isamchk -r" on those. Then restart
> >mysqld. Do not forget to make backup copies of the tables in question
> >beforehand, in case anything unexpected happens.
> >
> >You can get more information about your version of isamchk with
> >"isamchk --help".
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
