Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 05-30-2012, 12:25 AM   PM User | #1
kimmi_baby
New Coder

 
Join Date: Jun 2010
Posts: 46
Thanks: 10
Thanked 0 Times in 0 Posts
kimmi_baby is an unknown quantity at this point
How to import Drupal Blog Posts into a Wordpress website

I'm trying to work out how to import drupal blog posts into a wordpress website. I found a website that has a script but I'm not sure how to execute it and what I need to do. This is the website I found with the script here.

If someone could please help me I would so appreciate it! I'm not even sure where to start. I have already backed up my wordpress site and wordpress database in case anything goes wrong. I'm just not sure how to run the script and if I'm supposed to be able to take something from the drupal database.

If anyone knows of a better way to import the blog posts, I would so appreciate it. Its really doing my head in.
kimmi_baby is offline   Reply With Quote
Old 05-30-2012, 01:51 AM   PM User | #2
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,247
Thanks: 59
Thanked 3,998 Times in 3,967 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
Well, to use that code, first you would have to have both your WP and Drupal databases on the same MySQL server.

Now, that's not hard to do if they aren't already. You can just dump your Drupal database to a text file, copy the text file to the machine with the WP database, and then import all that data into the same MySQL server. So long as your database NAMES are not the same, there won't be a conflict.

How you do the dump and import depends on what kind of access you have to your MySQL databases. I would much prefer to do this via a MySQL command line interface. But if you are on a shared server, that may not be an option for you. So try to find out what tools are available on your server (hopefully, at a minimum, phpmyqladmin?) and find out how to do those steps using your tools.

Once you have done that, you just run that query he shows you.

His documentation is slightly wrong. He says
Quote:
Here’s the script. “wp” is the name of the wordpress database and “drupal” is the name of the drupal database.
In actuality, in that script the name of his wordpress database is wp23 as you can see from reading it.

CAUTION: That code is OLD! See the date on it? April of 2008. It is QUITE POSSIBLE that both Drupal and WordPress have changed their DB schemas by now. So before you run it, check both databases and make sure that all the field names he uses there exist in the tables he shows there.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote
Old 05-30-2012, 09:34 AM   PM User | #3
migratetowp
New to the CF scene

 
Join Date: May 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
migratetowp is an unknown quantity at this point
Other alternatives available in the wordpress site

The importing content section in the wordpress site http://codex.wordpress.org/Importing_Content#Drupal

lists some other alternatives to import the content from Drupal, including a Java program (instead of a database script) if you feel more comfortable executing that.
migratetowp is offline   Reply With Quote
Reply

Bookmarks

Tags
blog posts, drupal, mysql, wordpress

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 05:29 AM.


Advertisement
Log in to turn off these ads.