What to do with WP exported db? (7 posts)

  1. tinuviel
    Posted 10 years ago #

    I exported my WP journal into .gz and .csv formats a while ago, and have had the files sitting on my hard drive ever since.

    Where should I import them into? I just want to have them separated out into date, title and content again. I have a MySQL db I can set up to take the fields in, but I'm not sure what I'd have to do in order to do that.

    Should I just install WP 2, re-import the old data, then copy and paste the entries into my text file (which is where I want them)?

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    On the right there are 3 things you can do.

    On the left is a guide to Restoring the database.

    But do not install 2.0 then try to import data that was not exported from 2.0 - It will break things.

  3. tinuviel
    Posted 10 years ago #

    Great, thanks so much! That's a big help. Just one question... as I only have the db backup, and not the blog backup, for the old version of WP (and I even forget which version it was), do I still need to import the blog into Xampp? Or can I just place the db backup into the recommended folder and leave it like that?

  4. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Are you actually after a live blog, or just a blog in your machine to read the old posts ?
    I'm not entirely clear on your end goal so I don't want to mislead :)

  5. tinuviel
    Posted 10 years ago #

    Just a blog on machine to read old posts.

  6. Mark (podz)
    Support Maven
    Posted 10 years ago #

    In that case, I would install Xampp.
    Make a new database
    Import the sql file with the old posts
    Put wordpress into it's own folder
    Do NOT install WP !
    Edit wp-config.php have these details:

    define('DB_NAME', 'wordpress');
    define('DB_USER', 'root');
    define('DB_PASSWORD', '');
    define('DB_HOST', 'localhost');

    I'm assuming there that you make the db name 'wordpress'
    and you should be good to go.

  7. tinuviel
    Posted 10 years ago #

    Great, that's it - I got it! Thanks so much! I can't believe my good karma. I'll do my best to pass it on :)

Topic Closed

This topic has been closed to new replies.

About this Topic