You might be able to do a few "select * from mubo_boekhoud_boekhoud where
...." queries to be able to dump out most of the data in the table. Then you
can drop and recreate the table and import the data.
It's worth a try anyway.
Terje K
> -----Opprinnelig melding-----
> Fra: David Bouw [mailto:[EMAIL PROTECTED]]
> Sendt: 18. september 2001 01:53
> Til: [EMAIL PROTECTED]
> Kopi: [EMAIL PROTECTED]
> Emne: Fw: Hoping for Crash recovery Miracle
>
>
> Hi there,
>
> I would really appreciate any help someone can give on the
> following awful problem..
>
> I have been working all day on filling a table with data. (Small
> records..)
> Because I have a table which I filled with some binary data
> someone asked me how big this will get..
> I looked at the directory and did a 'tar cfvz' command to (pack
> the data to a file) an look how big the file would get..
>
> I am not sure what I did wrong, but I got an error which I
> didn't look at very carefully
>
> After this it looked as if I damaged the table I worked on all day....
>
> The table consists of: 4440 records.. On this moment I can see
> this number listed when I do a:
> select count(*) from tablename... (So far so good)
>
> When I do a select * from ... this table I get the following error:
> Warning: MySQL: Unable to save result set in
> /www/websites/mubo/login/phpmyadmin/sql.php3 on line 65
> (This ss a error from the PHP script doing the query, but the
> error: 'MySQL: Unable to save result set' probably is from mysql..)
>
> The three table files look as follow:
> 2.8M -rw-r----- 1 root root 2.7M Sep 18 00:37
> mubo_boekhoud_boekhoud.ISD
> 140k -rw-r----- 1 root root 135k Sep 18 00:37
> mubo_boekhoud_boekhoud.ISM
> 12k -rw-r----- 1 root root 8.6k Sep 18 00:37
> mubo_boekhoud_boekhoud.frm
>
> When I do a isamchk mubo_boekhoud_boekhoud I get the following:
>
> [root@jaguar test]# isamchk mubo_boekhoud_boekhoud
> Checking ISAM file: mubo_boekhoud_boekhoud
> Data records: 4440 Deleted blocks: 0
> - check file-size
> isamchk: warning: Size of datafile is: 2878557 Should be: 403794
> - check 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
> isamchk: error: Wrong bytesec: 31-139-8 at linkstart: 0
> ISAM-table 'mubo_boekhoud_boekhoud' is corrupted
> Fix it using switch "-r" or "-o"
>
> What are my options...??? If I could only get the data in a
> readable form, I could at least get back some data..
> The .ISD file should be O.K, is it possible to regenerate the
> .ISM files.. ??
>
> What can I try.. If anyone think I still have some options I will
> very much appreciate to hear this..
>
> I did try a isamchk -o command, this was the result:
>
> [root@jaguar test]# isamchk -o mubo_boekhoud_boekhoud
> - recovering ISAM-table 'mubo_boekhoud_boekhoud.ISM'
> Data records: 4440
> Wrong bytesec: 31-139- 8 at 0; Skipped
> Data records: 0
> [root@jaguar test]#
>
> The .ISD file is truncated to 0 bytes and I then have a table
> with 0 records...
>
> Thankyou very much for any help..
>
> With kind regards
> David ..
>
>
>
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
