WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_str8_posts LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (5436) GROUP BY ID

STR8BLOGGIN » Blog Archive » Problems with MySQL data-dir on Ubuntu 10.04?

Problems with MySQL data-dir on Ubuntu 10.04?

If you are having trouble modifying your MySQL configuration under Ubuntu (primarily, MySQL hangs/doesn’t start), the problem is apparmor. Do “service apparmor stop” and then “chmod -x /etc/init.d/apparmor”; restart MySQL and it should work.

The problem is that AppArmor tries to limit the folders that MySQL can access, and therefore when you change the data-dir in mysql.conf, mysqld_safe cannot properly start.

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

Leave a Reply