Searched around a bit on Repairing mySQL. Ref: https://dev.mysql.com/doc/refman/5.0/en ... check.html
First step was to check table that was giving me errors:
Code: Select all
gstreet@gstreet-MicroServer:/$ sudo myisamchk var/lib/mysql/greyhole/settings
Checking MyISAM file: var/lib/mysql/greyhole/settings
Data records: 9 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
MyISAM-table 'var/lib/mysql/greyhole/settings' is usable but should be fixed
Code: Select all
gstreet@gstreet-MicroServer:/$ sudo myisamchk --safe-recover var/lib/mysql/greyhole/settings
- recovering (with keycache) MyISAM-table 'var/lib/mysql/greyhole/settings'
Data records: 9
myisamchk: error: Can't create new tempfile: 'var/lib/mysql/greyhole/settings.TMD'
MyISAM-table 'var/lib/mysql/greyhole/settings' 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
Code: Select all
gstreet@gstreet-MicroServer:/$ sudo myisamchk --safe-recover -f var/lib/mysql/greyhole/settings
- recovering (with keycache) MyISAM-table 'var/lib/mysql/greyhole/settings'
Data records: 9
Code: Select all
gstreet@gstreet-MicroServer:/$ greyhole --stats
Greyhole Statistics
===================
Storage Pool
Total - Used = Free + Trash = Possible
/var/hda/files/drives/drive1/gh: 1834G - 853G = 888G + 0G = 888G
/var/hda/files/drives/drive2/gh: 1834G - 858G = 883G + 0G = 883G
/var/hda/files/drives/drive3/gh: 1834G - 917G = 824G + 0G = 824G
/var/hda/files/drives/drive4/gh: 1834G - 861G = 880G + 0G = 880G
==========================================
Total: 7335G - 3489G = 3474G + 1G = 3475G
Thanks for taking the time to try to help me, Bigfoot.