Back to top

Migrating simplePHPblog to WordPress

I just migrated my blog from simplePHPblog to Wordpress. There was no option for sphpb in the Wordpress import wizard, so I used RSS, not without a hickup or 2 though... First, I exported my blog to RSS by right clicking the 'get RSS2 feed' on my old blog. I saved the file blog.xml on my desktop. Then I used the Wordpress RSS importer and selected the file from my desktop and away it went. I got a message saying 70 odd post had been imported. But when I looked at the entries, they were all empty! The title and subject were there but the content itself was not there... bugger! A quick look in the MySQL database used by wordpress found the issue. In the table wp_posts, every imported entry had the tag <![CDATA[ in it, at the beginning, and then ]]> at the end. This definately had to go! This tag is used in XML files, to tell the parser to not look inside this section for any tags. But it breaks a web browser - it ignores everything in between! My first instinct was to google the problem, and I found some people were using a text editor to remove these tags from the XML file before importing. I was worried this would break my XML, and as it turned out, it did. The file would no longer parse properly, because there were html tags inside the areas which the CDATA tag was previously protecting. So the import would only work with the CDATA tags in place, I figured. So i decided the solution was to simply strip the tags out of the entries in the database directly. I ran the following 2 queries: update `wp_posts` set post_content = replace (post_content, "<![CDATA[", ""); and update `wp_posts` set post_content = replace (post_content, "]]>", ""); which effectively removed any occurrence of those two strings from the entries, and presto! I used the same method the redirect links in posts which pointed to my old gallery on mxm to my new gallery at gallery.itriver.com.au as well. Last issue was that the categories created were a little messy. Any items which used to belong in several categories (say Family, Photos, and music) created a new category, like "Family Photos Music". I just used wordpress to delete these categories. Otherwise, all seems pretty good.

Entries

Love that camry
Read this post
This post was a long time coming
Grafton Web Design
Youtube Bwahahah
New website
CeBit done and dusted!
Transferring files with FAST
Hmmmfff
Politics. Climate Change. Who can we trust?
Kids at Jaca
Jaca Float
Exciting times
The honeymoon is over!
Dual screen OK!
New reality show - action and tears aplenty!
Ubuntu 6.10 Compiz with cheap Nvidia card
Malware Burn removal
ITRiver has moved, and why we all speak Hsilgne (pronounced sil-gon-ee)
The Return of the Paparazzi
Finally footage of the mud volcano in Indonesia
Aren't we little rays of sunshine?
New ideas
The Ring
The Saga of the Ring...
The Ring
Great day at the beach, Manta Ray agrees.
Ahhh! No login screen!
Policies & Disclaimer
The world is amazing sometimes. Parents beware.
What's ITRiver?
Aching and lonely. I should write a country song...
Ecko's the Gecko's echo!
Migrating simplePHPblog to WordPress
About Me
About Me
Wedding plans starting to come together... still no ring though :(
Im getting married!
Im going on a time machine!
Big ideas
Back again!
Soccer Gallery
Happy Birthday to me!
Microsoft free zone!
Slack attack, Sorry!
Happy Birthday baby!
Gunners on fire with carnival clean sweep
Dylan's Soccer Draw
Can't talk now, seeing double!
Read slowly please
Nuts, anybody?
She's mine all mine!
Awww, they are SOOOO CUUUTE!
Off to Brissy
Photos
I've been on the wrong planet!
Baby - It's 3am I must be lonely
Quick call-in.
Distracted...
Long time no blog, again
I am SO slack
Sick, tired and internet crawling. Id rather be fishing.
Sooooozies new blog, with cuuute photos!
No more baby sisters! What a relief!
Pic of the day
Picture of the day
Mt Warning. - Take the name literally. I didn't...
Christmas lights cause traffic mayhem, homeowners honked at
Blog is back!
Indy!
Website wants to stay
Thirsty Merc rocked
Long weekend
Parents Poem
So um, can anyone see which way is east?
Happy Birthday, Chrystal!
Pic of the day
What a weekend
Home again
Sideways glances get you lost!
Thought for the day:
Lonely
Trip to Melbourne
He doesnt live near me, he lives in Melbourne
Business trip to Melbourne
Photo of the day
Photo of the day
Quarter Century
Photo of the day
Uncle Bill's Farm
Finally!
Lily Oh Lily Oh Lily!
Im an Auntie!
Bored.
Tis the colour of the sun, my son!
Fine print is fine, if it's there at all...
New car is en route
Ooooh one day when I'm spoiling myself
Another bloody Camry driver?
The question on everyone's lips - answered!
No beemer this time...
My first BMW, maybe
Nice one, QLDers!
Ah, humour comes in all types, bro. Word ta' ya' motha.
Off to Hard and Soft School...
Yes it's a strange idea...
Headed for the unthinkable - Divorce
Music for the emotions...
Dr_Snapid's Blog is on the wire.
ITRiver closed from 1st Sept to 9th Sept