Hello,
I have a database with tables getting bigger and bigger (log tables).
Thus every month I make an archive and then compress it with myisampack.
I have a problem though. It seems that without a FLUSH TABLES, the
tables don't appear correctly as compressed and can't be read until
the end. I've made my code fine and added FLUSH TABLES, but however
before doing that I'd tried to REPAIR one of those compressed tables
(because I thought it was really corrupted) and now the table ends
up completely unreadable by MySQL. I am a bit stuck because it seems
I can't find any means of recovering the table after the REPAIR command
(however the REPAIR itself said it was successful ;-)).
mysql> show table status like "link_change_2001_10";
| link_change_2001_10 | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL | NULL
| NULL | NULL | NULL | NULL |
# myisamchk -efv /var/mysql/db/link_change_2001_10.MYI
myisamchk: error: 127 when opening MyISAM-table
'/var/mysql/db/link_change_2001_10.MYI'
myisamchk: error: 127 when opening MyISAM-table
'/var/mysql/db/link_change_2001_10.MYI'
A quick sum up of the chronological process as I don't
know if the above is quite clear :
- myisampack -s /var/mysql/db/link_change_2001_10
- myisamchk -srq /var/mysql/db/link_change_2001_10
- the table is shown as "fixed" in SHOW TABLE STATUS,
and can't be entirely read
- I tried REPAIR TABLE so as to fix what I thought was
a problem ; REPAIR returned ok
- the table cannot be accessed anymore (NULL values
in SHOW TABLE STATUS, myisamchk fails)
The MySQL version is 3.23.43 (source distribution), with Berkeley DB
and InnoDB enabled (however not used). It runs on a dual
P3 1GHz with 1GB RAM and a three-disk harware RAID5 SCSI disk array.
Thanks in advance for your help
Yours
Antoine.
---------------------------------------------------------------------
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
