Backing up my posts & woocommerce products by exporting the data into CSV -Help!

  • I’m helping a friend change her WordPress theme on her shop. I’m running the new theme on a localhost test server, which overwrote her wp_posts section of her database.

    I want to copy the tables from the old database under wp_posts and replace import them into her new theme so that all her products and posts are back in her site. The thing is, I’ve never done this before.

    What should I know before trying this? It seems a little complex, I plan on doing some reading

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

  • The thing is, I’ve never done this before.

    And that’s a Good Thing(tm) as you cannot just drop a new table from one WordPress db into another. WordPress uses relational tables which means that all of the tables are inter-linked.
    Why not just download a fresh copy of the database from the live site?.

    Thread Starter connorv

    (@connorv)

    @esmi, will that work? I looked in the database on the new current (blank) theme and it has data in the tables that I assume were put there when I installed the new theme. If I replace the database with one that went to my prior theme, won’t the theme break?

    It should work if you follow the relevant steps in Moving_WordPress to ensure that all site urls are changes to reference the locally hosted site. Then all you will need to do is activate the new theme again.

    Thread Starter connorv

    (@connorv)

    I’ve tried what you’re saying a couple times now… What I did explicitly is drop all tables in my localhost db (just to start with a clean slate) and then reimported my backup table. This deactivates the theme, which as expected makes the WordPress look awful.

    SO I go to reactivate the theme, but it doesn’t look anything like how the theme should look until I activate the sample content. Here’s a lil screenshot of this page https://imgur.com/stNn5ud

    Activating the sample content overwrites all the data in wp_posts !

    Can I have my products AND the theme, or am I stuck having to manually re enter all products and posts?

    Thread Starter connorv

    (@connorv)

    I keep trying this with different settings etc and I’m assuming I’ll need to manually re enter all posts… I don’t see a way around it

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Backing up my posts & woocommerce products by exporting the data into CSV -Help!’ is closed to new replies.