dspam and mysql
December 22nd, 2005
No comments
how to fix mysql db files when I could not start mysql because of a crash. easiest way was to fix db tables using myisamchk command.
[16:03:17] root@chrysek: /usr/local/mysql/var/dspam >
/etc/init.d/mysql.server stop
No mysqld pid file found. Looked for /usr/local/mysql/var/chrysek.
pid.
[16:03:19] root@chrysek: /usr/local/mysql/var/dspam >
/etc/init.d/mysql.server start
[16:03:23] root@chrysek: /usr/local/mysql/var/dspam > myisamchk -r -q dspam_token_data.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table ‘dspam_token_data.MYI’
Data records: 6184409
- Fixing index 1
[16:06:17] root@chrysek: /usr/local/mysql/var/dspam >
[16:03:19] root@chrysek: /usr/local/mysql/var/dspam >
/etc/init.d/mysql.server start
[16:03:23] root@chrysek: /usr/local/mysql/var/dspam > myisamchk -r -q dspam_token_data.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table ‘dspam_token_data.MYI’
Data records: 6184409
- Fixing index 1
[16:06:17] root@chrysek: /usr/local/mysql/var/dspam >
