Creating Posts from non-blog SQL

  • kelvster

    (@kelvster)


    15 years, 6 months ago

    I am looking to create around 1000 posts from our existing mysql database, but it’s not wordpress and it’s not a blog. The plan is to pull entries from different tables/fields using SQL queries, which are to become the posts in the new wordpress installation.

    There doesnt seem to be any plugins for this.

    What’s the best way to create the posts, is it creating an XML doc with the SQL, which would then be imported as RSS? If so, what fields are required.

Viewing 3 replies - 1 through 3 (of 3 total)
  • MichaelH

    (@michaelh)

    15 years, 6 months ago

    Saw this recommended a while back:

    1.Install a WordPress blog.
    2.Export the blog (Manage->Export)
    3.Analyse the resulting XML (WXR) file and use that to create your own XML file with your ‘posts’
    4. Use Manage->Import->WordPress to import those posts from your manufactured XML file.

    Thread Starter kelvster

    (@kelvster)

    15 years, 6 months ago

    Thanks for your reply Michael.

    It seems that you can just create a simple rss doc, with only <item> <title> <description> for each entry. Useful only if you don’t have existing tags, comments of course, but wordpress can still import it.

    eric_donovan

    (@eric_donovan)

    15 years, 6 months ago

    You could use SQL to copy the data from your old database tables direct to your new WordPress database assuming they’re on the same system.

    As long as you put the data in the correct fields in the tables it should work (Note – I don’t know too much about WordPress but I’m assuming it just builds the pages based on what it finds in the db)

    Once you install WordPress try to add a few posts just using SQL direct to the DB and see what happens maybe.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Creating Posts from non-blog SQL’ is closed to new replies.