Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jun 2010
    Posts
    46
    Thanks
    10
    Thanked 0 Times in 0 Posts

    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.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,567
    Thanks
    78
    Thanked 4,384 Times in 4,349 Posts
    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
    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.

  • #3
    New to the CF scene
    Join Date
    May 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •