Combine WordPress DB with DB from another CMS

  • I have a 200mb SQL dump from a custom-made CMS that I need to import into my 1 week old wordpress installation.

    So after spending a couple of hours just importing this huge file into MySQL..i now realize that I don’t exactly know what to do so that the old articles show up in wordpress.

    What I’ve done so far is upload the dump via ftp and I used this tool called bigdump.php to import it into MySQL. When I open phpMyadmin, i see the dump in the wordpress db listed as “export” on the left colomn.

    So i suppose this a MySQL question, how do i move the articles into wordpress or am i going about this the wrong way ?

Viewing 6 replies - 1 through 6 (of 6 total)

  • Well you are not excatly in the wrong way but you have a long way in front of you. Each CMS has its own structure of data, layout of the database. What you need to find out is, if your old data provides enough data sothat it can be converted into the wordpress layout. So you need to analyse wordpress default database structure and you need to analyse the one you have in your existing data.

    This is not a thing for a beginner. But maybe you can take another way. Take a look in your other CMS if it can export to one of the formats that wordpress can import, because there are a few. You find those in the admin under Manage -> Import (wordpress 2.5+).

    Thread Starter Klark

    (@d_kc)

    No..this was a custom system. I have no access to it right now.
    All i have is the sql dump and a xml output.

    Thread Starter Klark

    (@d_kc)

    If i copy the tables from export.sql to the wordpress db/wp.post, will they will show up on wordpress in the front-end automatically ?

    I doubt that this would work. You can try it but this is a like playing lotto.

    Thread Starter Klark

    (@d_kc)

    So what would work in my situation ?

    Try to find a junior database admin or a junior php/mysql developer who is willing to convert the data. Or do the work on your own.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Combine WordPress DB with DB from another CMS’ is closed to new replies.