A couple of nights ago, I started having problems modifying any previously saved blog entries. The
Serendipity software would error out with the following error message:
/ Incorrect key file for table 'serendipity_entries'; try to repair it
After repeatedly repairing the
serendipity_entries table (
"repair table serendipity_entries;" ) only to have the table get corrupted again as soon as I edited anything.
I ended up having to dump out the table contents and recreate it (using the following
MySQL commands):
[unix]$ mysqldump -u username --password=passwd --add-drop-table db_name serendipity_entries \
> /var/tmp/serendipity_entries_table
mysql> source /var/tmp/serendipity_entries_table
Then all was good - I could update my blog freely again.
Whew!
Yet another tip for those
Serendipity bloggers who get spammed mercilessly. You can truncate the
serendipity_spamblocklog table to save room in your MySQL database via the command:
mysql> truncate serendipity_spamblocklog ;
For more info, check out this
Serendipity Forums thread.