I really need to fix my problem. I've been populating my database for a week and have no backup!

the partition that has the database directory is full and I get error on one of my table. I tried to create some space on that partion and then ran

myisamchk -o DocKeys.MYD -t /usr/tmp

I was asked to correct my indexex so I ran

myisamchk -o DocKeys.MYI -t /usr/tmp

then got the following messages:


- recovering (with keycache) MyISAM-table 'DocKeys.MYI'
Data records: 794497
myisamchk: Error writing file 'DocKeys.TMD' (Errcode: 28)
myisamchk: error: 28 when writing to datafile
MyISAM-table 'DocKeys.MYI' is not fixed because of errors



know I don't know what to do. Most of the partion is this very table DocKeys

so I cann't have more space on the partion. I was wondering if I could retrieve only

some part of my data . I mean " Data records: 794497".

Please just help me!

Try myisamchk -o -f
The -f option will force it to overwrite old temp files.

Bob
http://totallyfreeads.com.au