Thursday, June 21. 2007
Mac OS X 10.4.10 Tiger Released
| Apple has released Mac OSX 10.4.10 which contains several performance improvements and bugfixes (here is the official Apple document). Update (6/21/07): Installed the update this evening -- will see how it performs.... |
Serendipity MySQL woes....
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.
/ 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.
« previous page
(Page 1 of 1, totaling 2 entries)
next page »


