WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE ID IN (161) GROUP BY ID

Curioso! » 2009 » December

Archive for December, 2009

Snapshots using rsync on Mac

Sunday, December 27th, 2009

I got fed up with Time Machine not backing up my iPhoto library. If I keep iPhoto running, it does not back up at all; if I quit iPhoto, it still will not make a full backup because I have a screen saver running with the Last Month smart folder, and this apparently locks out the last month of photos from being backed up. Also Time Machine will not back up from remote file systems.

So I looked around for a backup solution based on rsync. These solutions are around:

I mixed these together in my own script that can be called daily from crontab. It cycles through 7 daily backups and 8 weekly backups. Here is the script.

Posted in Mac |

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 161 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '161' AND comment_approved = '1'

No Comments »