• Resolved recursive

    (@recursive)


    Supposed I’m running the latest WC version. Then I replace the database with a copy from running an older version of WC. Will WC recognize that the database is older and perform the required database updates, if any?

    The bigger context is that I’m planning to clone my live site, perform all plugin updates and test. Then restore the database from the live version once again after the testing is complete. In particular I don’t want to lose any WC orders that may have been placed in the interim. Maybe there is better way to do this?

    Thanks!

    • This topic was modified 5 years, 10 months ago by recursive. Reason: Added contextual reason
Viewing 4 replies - 1 through 4 (of 4 total)
  • Phil

    (@fullysupportedphil)

    Automattic Happiness Engineer

    Most of the information that WooCommerce uses is in the database. This includes the version tracking of your WordPress and WooCommerce installations.

    Restoring a site from an out of data database backup isn’t something that we would recommend. While it may work, you have a high potential for causing issues.

    Additionally, since many plugins store their settings in the database – restoring an old database will essentially un-do any changes you’ve made.

    Instead what I would recommend is to make your staging site. Once you have the staging site, perform your plugin updates to check for any conflict or issues. Once you’ve done that, you can then safely perform the same updates on your live site. At that point you’ll have an updated live site, with the same plugin versions that you can copy over to your staging environment, as needed.

    Thread Starter recursive

    (@recursive)

    Thanks Phil for the helpful reply. Those are important points I didn’t realize.

    If I create a fresh server & WordPress installation, and then use the admin Tools > Import feature to import my old WordPress data, will that correctly import my WooCommerce data too? Will orders and products import? Also, will order numbers change?

    Our current live server is running an older version of Ubuntu, PHP etc. Upgrading it in place has proven to be a real time consuming chore, with lots of dependencies to chase down. I am wondering if it would be easier to start with a fresh install. Retaining the WC data is critical though.

    Phil

    (@fullysupportedphil)

    Automattic Happiness Engineer

    While WooCommerce does make use of the WordPress database structure and existing tables, doing a WordPress Export/Import will not bring over all of your WooCommerce information.

    If you wanted to transfer of all of your orders and matching customers, you’d want to look at a plugin like this one:
    https://woocommerce.com/products/ordercustomer-csv-export/

    Given that you’ll need to transfer all the information over though, a migration plugin would likely be an easier option. That way you can grab everything at once instead of doing WordPress information and WooCommerce information separately.

    We don’t offer one of these plugins, but there are many third-party options. You can find several here on WordPress.org:

    https://en-ca.wordpress.org/plugins/search/migration/

    That way you can migrate everything to the new site and then perform any updates you need there.

    Plugin Support Thu P. a11n

    (@thup90)

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

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

The topic ‘Updating a restored old database’ is closed to new replies.