Setting up Wordpress blogs with .sql/mysql database

Discussion in 'WordPress' started by soccer-writer, Nov 17, 2009.

  1. #1
    Hello,

    It might be a newbie question. But could anyone give me a step-by-step description as to how to start a blog which extracts contents from .sql database and posts on the blog periodically. It would be equally good if you'd furnish an external link regarding the same.

    For eg - I have a couple of recipe, lyrics databases. I would like to post content on the Wordpress blog periodically.

    Is there any plugin which does it for you ? Can the content be imported periodically or is it to imported all at once, at the start of blog ?

    Any help would be appreciated.

    Thank you.
     
    soccer-writer, Nov 17, 2009 IP
  2. gacba

    gacba Peon

    Messages:
    75
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Your web host likely has 1-click installers (Fantasico Deluxe, for example). If not, I'd suggest Googling "How to install Wordpress manually" and I'd just bet you'd find all sorts of goodness. ;)
     
    gacba, Nov 20, 2009 IP
  3. aping

    aping Peon

    Messages:
    52
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Make sure that you have installed wordpress on your self web hosting. If your wordpress blog has been installed, make sure that you choose phphMyAdmin. Select your database by clicking on side panels. Click on "Import" tab menu than browse your *.sql file. Click on "Go" button to import your SQL file.
    If you have any exported files from WP (from Tools-Export on your WP) before, it can be easier to import your blog contents.
     
    aping, Nov 21, 2009 IP
  4. soccer-writer

    soccer-writer Peon

    Messages:
    429
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks for the help aping. I figures it our myself. The problem I is that, the .sql dumps I have on my PC are not Wordpress sql dumps, but simple databases.

    So, even though I'm able to import the dumps, I can't transfer all the contents of the dump into a Wordpress blog.

    Is there a way to build a website by extracting contents from those dumps? I think you'd need a script to do it. I'm not too sure.
     
    soccer-writer, Nov 21, 2009 IP