update: a friend told me an easier possibility: It worked perfectly (updating the cached views will be necessary to view the changes soon)

> Then you can just reimport the new sql file to the database. Thank you. I also thought about this solution but am still unsure about some details: I wanted only to dump and reimport the one table concerned (serendipity_entries). I guess, that I will have to delete the original table before importi...

I have a related problem. I changed the domain of a blog, following these instructions http://s9y.org/198.html . The folder on the filesystem remained the same. Now I can reach the admin-interface, but when I return to my blog, I see the files and folders instead of the index-page. I guess this is m...

I deleted the unnecessary revisions with:

mysql> delete from wp_posts where post_type ='revision';
Query OK, 152 rows affected (0.01 sec)

and my wordpress-blog is still alive
unfortunately had no time to try another import into s9y yet. thank you to garvinhicking for all the hints!

When I tried to import my wordpress (v2.6.2) blog into serendipity (1.3.1) I found that I had not one but several versions of each post, some of which were complete, others not. This seem to be due to a fairly recent wordpress-feature: http://codex.wordpress.org/Revision_Management One way to get ri...