Export import from old to new site

  • Hello,

    We are upgrading a website to a newer look. I have duplicated the existing site to a subdomain and when we go live, I don’t want to loose new submitted reviews.

    I tried to export specific lines from the mysql database. The import says that the lines were imported, but when I go and check the back end of the new site, the reviews do not appear.

    In addition, when I search the DB for text from one of the new reviews it does not get found.

    Is there another easier way to export form a website and import to a new site?

    Robert

    https://www.ads-software.com/plugins/wp-customer-reviews/

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

    (@cathryn999)

    Second this. I am looking for a simple way of exporting my 500+ reviews to a spreadsheet for upload to a new-look website. Any ideas/suggestions welcome!

    I am to trying this.

    I exported the wp_wpcreviews table and imported it, but still doesn’t show?

    It shows there are “XX” approved, but when I click on it, they don’t show up ?

    What am I missing here ?

    Ok, got this working for anyone who needs to “export” and “import” do the following:

    Oldsite:

    go to your database and export just the wp_wpcreviews table

    Newsite:

    import or run the SQL on that database ( basically just importing the wp_wpcreviews table and data into the new db )

    ** Important step: on your new site, do a “test review” and then publish that review. Go back into your database and look under the wp_wpcreviews table and see what the page_id is for the new review.

    Next, update the other reviews so they have that same page_id

    Hope that helps!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export import from old to new site’ is closed to new replies.