RE: lost data

[J S]

Just reposting in case anyone missed it! Or have I asked a dumb question?!

Hi,

I've run a safe recover on a table after I had to recreate the index file:

# myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage
- recovering (with keycache) MyISAM-table 'internet_usage'
Data records: 290804216
Data records: 519541696
#

After that I ran a query on the table, but the data seems to be corrupted. I tried flushing the tables but still got bad data despite the checks below which show everything looks fine:

mysql> check table internet_usage;
+---------------------------+-------+----------+----------+
| Table                     | Op    | Msg_type | Msg_text |
+---------------------------+-------+----------+----------+
| proxy_logs.internet_usage | check | status   | OK       |
+---------------------------+-------+----------+----------+
1 row in set (35 min 34.97 sec)

# myisamchk internet_usage
Checking MyISAM file: internet_usage
Data records: 519541696   Deleted blocks:       0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1

# myisamchk -dvv internet_usage

MyISAM file:         internet_usage
Record format:       Fixed length
Character set:       latin1 (8)
File-version:        1
Creation time:       2004-10-27 16:49:48
Recover time:        2005-01-16  7:14:48
Status:              checked
Data records:            519541696  Deleted blocks:                 0
Datafile parts:          519541696  Deleted data:                   0
Datafile pointer (bytes):        4  Keyfile pointer (bytes):        4
Datafile length:       16625334272  Keyfile length:        5006235648
Max datafile length:  137438953470  Max keyfile length: 4398046510079
Recordlength:                   32

table description:
Key Start Len Index   Type                     Rec/key         Root  Bloc
1   2     4   multip. unsigned long                  0    445844480

Field Start Length Nullpos Nullbit Type
1     1     1
2     2     4
3     6     4
4     10    4
5     14    4
6     18    2      1       2
7     20    4      1       4
8     24    4      1       8
9     28    1
10    29    1
11    30    1
12    31    2

# ls -l internet*
-rw-rw---- 1 mysql mysql 16625334272 Jan 16 07:14 internet_usage.MYD
-rw-rw---- 1 mysql mysql 5006235648 Jan 17 09:05 internet_usage.MYI
-rw-rw---- 1 mysql mysql 8856 Jul 09 2004 internet_usage.frm

mysql> show create table internet_usage \g

| internet_usage | CREATE TABLE `internet_usage` (
 `uid` int(10) unsigned NOT NULL default '0',
 `time` timestamp(14) NOT NULL,
 `ip` int(10) unsigned NOT NULL default '0',
 `urlid` int(10) unsigned NOT NULL default '0',
 `timetaken` smallint(5) unsigned default '0',
 `cs_size` int(10) unsigned default '0',
 `sc_size` int(10) unsigned default '0',
 `method_ID` tinyint(3) unsigned NOT NULL default '0',
 `action_ID` tinyint(3) unsigned NOT NULL default '0',
 `virus_ID` tinyint(3) unsigned NOT NULL default '0',
 `useragent_ID` smallint(5) unsigned NOT NULL default '0',
 KEY `uid` (`uid`)
) TYPE=MyISAM MAX_ROWS=4294967295 |

1 row in set (0.00 sec)

mysql>

Could anyone give me some advice on what else I can try to recover the data please?

Thanks,

JS.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]