MySQL Checksum

This is another tool in the same toolkit as archiver. I just saw a great blog post on it at http://blog.arabx.com.au/?p=883. Documentation can be found at http://mysqltoolkit.sourceforge.net/doc/mysql-checksum-filter.html. This is an invaluable tool for ensuring your replicated tables are staying in sync, something that MySQL replication does not do. Tables will drift and if you are dealing with critical data for read support, reports or backups, this will prove invaluable.

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT * FROM wp_comments WHERE comment_post_ID = '12' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply