Typo to WordPress migration

Posted by max on June 25, 2007

The Stuart Johnston posting Automatic migration from typo to WordPress got us part of the way from Typo to WordPress, but a number of things have changed in Typo since those scripts were written, so it took some jiggering to get working. We were at Typo 4.1, and the database schema was somewhat different.

This is what I did to export the data from Typo:

bash$ mysqldump -u username -p name_of_typo_db articles_tags tags categorizations categories contents feedback > dumpster.sql

Then I imported that data into the WordPress database (just did “source dumpster.sql” within mysql), then sourced typo41_migrate.sql, which is modified from Johnston’s typo_to_wordpress_with_utw.sql script.

Comments welcome on the utility of my process.

Popularity: 10% [?]

Theoretically Related Posts
  • Moved to WordPress
  • Our First Blog Post
  • Database Constraints, Stereotypes, Rails, Culture, Talmud, Gender, MINASWAN, Religion. But ABSOLUTELY NO BONDAGE PLAY
  • Testing in Rails: Way More Trouble Than Flossing
  • Trackbacks

    Use this link to trackback from your own site.


    Leave a response

    1. Kramer auto Pingback[...] very much — this was quite useful. I have posted a modified version of the script at http://www.thirdbit.net/articles/2007/06/25/typo-to-wordpress-migration/ — the Typo schema is different from what is addressed in your script. Max Newell said on 26 [...]

    2. [...] install to install WordPress onto a development sub-domain. Then I used Max Newell’s typo4.1 migration guide to import my articles and comments. Categories didn’t seem to carry over, but since I have [...]

    3. Chris Patti Thu, 06 Dec 2007 17:23:45 UTC

      Seems like the WP schema has moved on since you revised that script.

      Now, when I run it, I get:

      ERROR 1146 (42S02) at line 4: Table ‘wordpress.wp_categories’ doesn’t exist

      Which, according to: http://wordpress.org/support/topic/135540 is understandable since they dropped those tables in the current version.

      If I have some time, I’ll try to figure out how the new schema mapping works and update your script. I’m sick to death of typo flakiness and am looking forward to WordPress’s smoother ride :)


    4. Kramer auto Pingback[...] ran into your blogging adventures through this site: http://www.thirdbit.net/articles/2007/06/25/typo-to-wordpress-migration/ Well, I am also considering a migration from typo to wordpress. So I was wondering which version of [...]

    5. Moving from Typo to Wordpress @ Raymond Law Sat, 10 Oct 2009 09:57:34 UTC

      Kramer auto Pingback[...] I recently moved my blog from Typo to WordPress. Typo served well and it was written in Rails. However, it was more difficult to upgrade and I just don’t have enough time to maintain it and keep it up to date. So it has been running at version 4.1.1 which requires Rails 1.2.6. So a change is imminent and I found a couple resources by Stuart Johnston and Max Newell. [...]

    6. WP Sauce - the instant WordPress resauce Wed, 18 Nov 2009 17:17:42 UTC