$> perror 145 Error code 145: Error 145 occurred. 145 = Table was marked as crashed and should be repaired
I think `myisamchk` needs to come into play here (both on slave and master at this point).
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html http://dev.mysql.com/doc/mysql/en/Repair.html
Cheers,
--V
Johan Jonkers wrote:
Hi,
I'm using mysql 4.0.12 and I got a database that holds the DMOZ data (master/slave config). Now this is a (to me anyways) pretty big database(4 million some links, with fulltext indexes). However I have a problem with it. For some reasons I can't get a grip on, the table crashes. (error 145).
Due to an error on the slave I wanted to resync the slave by copying the master database and all, and followed the instructions on http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html.
However, after bringing up the slave, I got a error 145 on the slave, and also on the master :-(
Can someone please tell me why this happened, how I can stop this from happening again as repairing the table takes a LONG time....
Any help would be really appreciated
Regards, Johan Jonkers
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]