Import from WP to s9y - how to get rid of the revisions
Posted: Wed Oct 01, 2008 5:49 pm
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 rid of the unnecessary copies would be to delete them from the database before starting the import (they can be recognized from post_type revision). Is there any other or better way to obtain a clean import?
Another problem are Umlaute. The wordpess installation uses UTF-8 but some plugins created their db-tables with ISO-8859-1 (that's one of the reasons I why want to switch from WP to s9y). Whatever I chose for import, the umlaute are a mess afterwords. How should I approach this problem best? (I am a beginner with mysql.)
And yet another import-related question: since which version does serendipity need php5 for an rss-import? It worked perfectly with the fairly old version of the debian etch packet, but the most resent version keeps telling me, that I need php5 (which I can't install easyly because dpkg will then uninstall phpmyadmin and gallery2). So I think of first installing some older version of s9y, import the data und then upgrade step by step to more recent versions.
//ps: Thank you for the great manual! It is the main reason for me to no consider using s9y although it had looked far more complicated than WP when I first tried both scripts.
One way to get rid of the unnecessary copies would be to delete them from the database before starting the import (they can be recognized from post_type revision). Is there any other or better way to obtain a clean import?
Another problem are Umlaute. The wordpess installation uses UTF-8 but some plugins created their db-tables with ISO-8859-1 (that's one of the reasons I why want to switch from WP to s9y). Whatever I chose for import, the umlaute are a mess afterwords. How should I approach this problem best? (I am a beginner with mysql.)
And yet another import-related question: since which version does serendipity need php5 for an rss-import? It worked perfectly with the fairly old version of the debian etch packet, but the most resent version keeps telling me, that I need php5 (which I can't install easyly because dpkg will then uninstall phpmyadmin and gallery2). So I think of first installing some older version of s9y, import the data und then upgrade step by step to more recent versions.
//ps: Thank you for the great manual! It is the main reason for me to no consider using s9y although it had looked far more complicated than WP when I first tried both scripts.