Typepad to WordPress Migration
February 23rd, 2010This is a collection of instructions we have found on different websites and hopefully will make your migration a little easier than ours was.
- Easier migration is to MovableType
- Export TypePad content
Manage > Import/Export - Do regular expressions directly on TypePad export file or SQL file instead of after export to cut down on errors. Or, use the Search Regex Plugin for WordPress.
- Disable domain mapping in Typepad if the new site keeps the same URL
Control Panel > Site Access > Domain Mapping - Most Typepad images are stored by date: ‘http://www.DomainName.com/photos/[a-Z]+?/[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/’ > ‘/wp-content/uploads/imports/’
- Some images are stored like this: ‘http://www.DomainName.com/.a/’ > ‘/wp-content/uploads/imports/’
- Typepad links correctly to images without extensions; WordPress does not
’800wi’ > ’800wi.jpg’ or ’800wi.png’, need to check image manually
’500pi’ > ’500pi.jpg’
’320pi’ > ’320pi.jpg’ - Some images may need manual fixes because their linked name is not the same as their filename
‘sunny_image_2′ > 6a00…..jpg - For replacements where the pattern to match is just a string, use phpMyAdmin
“UPDATE table SET field = REPLACE(field, ‘pattern’, ‘replacement’)” - For replacements where the match is a regular expression or the replacement uses subpatterns, use a script:
<? $link = mysql_connect($address, $name, $pass) or die(mysql_error()); mysql_select_db($db, $link) or die(mysql_error()); $result = mysql_query("SELECT * FROM wp_posts WHERE post_content RLIKE '$search'") or die(mysql_error()); while($row = mysql_fetch_array($result)) { $raw = $row['post_content']; $id = $row['ID']; $matched = addslashes(ereg_replace($pattern, $replacement, $raw)); $query = "UPDATE wp_posts SET post_content = '$matched' WHERE ID = '$id'"; mysql_query($query) or die(mysql_error()); } ?>

7 Comments
Great checklist. This will cerrtainly help with our upcoming migration!
If you find something that’s not on the list please leave a comment, we will probably be doing this again one day and I remember it being a huge pain
nice checklist.
Great list for further detail pls visit
WORDPRESS MIGRATION
Thanks for some of these tips, I used them in my migration. I have details on my site.
no problem, love the way you titled your page
if you’ve been stuck on TypePad for this long and you are a legitimate blog you really do need to ESCAPE !
Great checklist. This can surely help our migration a lot more convenient and quite easy. I’m surfing the net about this method and then I got your site. I had a great time trying your suggestion. Smart post. Thanks for sharing some thoughts
One Trackback
[...] Typepad to WordPress Migration | mimoYmima — creative web design (tags: typepad wordpress migration) [...]