vicidial.org

Posted: **Sun May 22, 2011 10:47 pm**

How to Repair call_log.MYI ???

I tried myisamchk -r ./call_log.MYI after stopping the mysql but Didnt work.

Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
- recovering (with sort) MyISAM-table './call_log.MYI'
Data records: 1083074
- Fixing index 1
Found block that points outside data file at 175138316
- Fixing index 2
- Fixing index 3
- Fixing index 4
myisamchk: Error writing file '/var/lib/mysql/asterisk/call_log.MYI' (Errcode: 5)
myisamchk: error: 5 when fixing table
MyISAM-table './call_log.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

Posted: **Mon May 23, 2011 10:07 am**

first you stop mysql service, its too dumb if your running myisamchk if your not stopping the mysql server.

second you do this:

myisamchk -f -r /var/lib/mysql/yourdb/call_log.MYI