469,609 Members | 1,666 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

bad data in mysql tables in replication server


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=20
| 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?

Luc Foisy=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1517

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.