WordPress.org

Ready to get started?Download WordPress

Forums

Migrating my custom website to WP (9 posts)

  1. Mustafa
    Member
    Posted 1 year ago #

    Hi,
    I installed the latest version of WP and adjusted everything. Now I should migrate ~50k articles from my custom developed (PHP+MySQL) website to WP database. I am comfortable with SQL, but I'm not sure which fields I should fill.

    Is there a tool for that? Or should I make SQL queries completely alone? Any documentation?

    bye...

  2. Pioneer Valley Web Design
    Member
    Posted 1 year ago #

    I guess one would study the old MySQL tables and the new ones?

  3. Mustafa
    Member
    Posted 1 year ago #

    Not exactly.
    My old website is not WordPress. Now I will transfer the date in my custom-tailored database to the database of WordPress. Which tables should I fill? Which fields need to be filled?

  4. michael.mariart
    Member
    Posted 1 year ago #

    As Saecaost said... You will need to study the DB design that Wordpres suses to determine which tables and fields you will need to fill in. As we don't know your existing DB structure it's impossible for us to say what data from your old system should go where in the WP system.

    But, as a hint, wp_posts is the main content table. From there wp_postmeta holds extra information as well. Good luck.

  5. Mustafa
    Member
    Posted 1 year ago #

    is wp_postmeta mandatory?

  6. michael.mariart
    Member
    Posted 1 year ago #

    No. You don't have to put anything in there. It's there in case there's extra values that you need for the post. BUT, you will need to investigate yourself to see if there's anything in there that looks like it might be related becuase I'm sure that there's some things in there that are needed.

  7. edpittol
    Member
    Posted 1 year ago #

    You can pass the content for the WXR content and import using the wordpress importer.

  8. Mustafa
    Member
    Posted 1 year ago #

    WordPress Importer seems to be doing good job.

    Which tag should I put the category in the RSS file?

    There are many images in my old website. Is there a tool to import them too?

  9. edpittol
    Member
    Posted 1 year ago #

    I this page http://codex.wordpress.org/Theme_Unit_Test has a WXR file that you can use as example. It has categories and images too.

Topic Closed

This topic has been closed to new replies.

About this Topic