Typepad to WordPress Migration

This 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:


&lt;?
	$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());
	}
?&gt;

$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());

}