the table has call_log.MYI crash

[tmkconcept]

hello
after an audit of the command

myisamchk *. MYI

Checking MyISAM file: call_log.MYI
Data records: 4105349 Deleted blocks: 0
myisamchk: warning: table is marked-as crashed and last repair failed
- Check file-size
myisamchk: warning: Size of indexfile is: 380452864 Should be: 95755264
- Check record delete-chain
- Check key delete-chain
- Check index reference
- Check data record references index: 1
- Check data record references index: 2
- Check data record references index: 3
- Check data record references index: 4
myisamchk: Unknown error 126
myisamchk: error: Can not read from indexpage FilePos: -1

how can I do to solve this

Version: ASTERISK 1.4.26.2
version vicidial: 2.4-250 Buil:1000420-1010
Softphone:eyabeam codec utiliser G729
Ordinateur:
AMD phenom x49500
Quald-core processor
640 gb HDD
512 Mb mémoire

[williamconley]

Always post your installation method!

You should add some memory.

is your HDD full?

Code: Select all

mysqlcheck --auto-repair --all-databases -p

the -p is only necessary if you have a password on your root user