"Luc Foisy" <[EMAIL PROTECTED]> wrote: > > Last week many of our server and client servers had a power problem. Not quite sure > how the servers were handled, wasn't on site, but I don't think some of these > servers got shut down gracefully. but anyways that shouldn't matter to my question > > I ran myisamchk on the data directories and I get a large report containing things > such as > > myisamchk: MyISAM file /usr/data/mysql/qbslive/MANIFESTSPOOL.MYI > myisamchk: warning: 1 clients is using or hasn't closed the table properly > MyISAM-table '/usr/data/mysql/qbslive/MANIFESTSPOOL.MYI' is usable but should be > fixed > myisamchk: MyISAM file /usr/data/mysql/qbslive/MARKETING.MYI > myisamchk: warning: 1 clients is using or hasn't closed the table properly > MyISAM-table '/usr/data/mysql/qbslive/MARKETING.MYI' is usable but should be fixed > myisamchk: MyISAM file /usr/data/mysql/qbslive/ORDERHEADER.MYI > myisamchk: warning: 1 clients is using or hasn't closed the table properly > MyISAM-table '/usr/data/mysql/qbslive/ORDERHEADER.MYI' is usable but should be fixed > > I am assuming I can just run myisamchk -r on these tables to fix them up on the > master server... but I have multiple replication servers of databases... > Can I repair these in the same way, or will the system fix it up or what? The slave > servers are definately not running at the moment, have show slave status on one rep > server of > | 1062 | error 'Duplicate entry '5486435' for key 1' on query 'INSERT INTO > DISPATCHLOG (CreateStamp) VALUES (NOW())' | > > Not quite sure what to do here, is my replicant toast? >
If you run myisamchk -r on the master, copy data from the master to the slave to make sure that master and slave have exactly the same data. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]