What to do with WP exported db?

  • 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)?

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

  • https://www.tamba2.org.uk/wordpress/
    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.

    Thread Starter tinuviel

    (@tinuviel)

    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?

    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 ??

    Thread Starter tinuviel

    (@tinuviel)

    Just a blog on machine to read old posts.

    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.

    Thread Starter tinuviel

    (@tinuviel)

    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 ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘What to do with WP exported db?’ is closed to new replies.

Tags