Support

Akeeba Backup for WordPress

#31961 Staging a WooCommerce site for changing themes to a new theme

Posted in ‘Akeeba Backup for WordPress’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

WordPress version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Thursday, 05 December 2019 17:17 CST

myaviation
1. I using an old woocommece (yootheme) theme and need to updated it to a new theme (Porto)
2. I’m using woocommcer with Products that are synced from a Drop SHipping Website as the Product ID are very imporant.
And need to make sure I don't messup all of the Orders and other fun stuff that is in the DB
3. Can I use Akeeba Backup for WP do do this
4. If so how will this work with your program (I own a copy of it)

Thanks

Rick

tampe125
Akeeba Staff
Hello,

yes, that's exactly one of the main purposes of Akeeba Backup.
First of all take a backup of your website: Akeeba Backup will create one (or more than one, depending by the size) archives that will contain all your site files and data. On top of that, a script for site restoration will be included.
Now download the new archives and upload it to your new staging server. There you can extract your archive using the Kickstart script, then run the restoration wizard that will let you specify all new details (database access details, filesystem path and new domain name). The restoration script will take care of updating all your data inside the database.

At the end of it, you have a new verbatim copy of the live website, where you can do all the tests you want. Once you're happy with the result, you have two options:
- Take a backup of the staging website and upload it to live
- Take note of the steps and any issues you had on the staging website and replicate them on the live site.

I personally suggest you to go with the second approach, since most likely new data will be placed on the live site while you're testing the new template (for example: orders).

That was just an overview of the whole process, I'd suggest you to take a look at our video tutorials so you'll know what to expect: https://www.akeebabackup.com/videos/1215-akeeba-backup-wordpress.html

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

myaviation
Thanks - I do this all the time for all my development(this is why i love your program simple and worth every penny)
but the issues is this

Now i'm on my DEV (staging ) Site get up my new theme.. Now how do I push that to the LIVE site the stuff that I just changed?

IE - plugins, Theme, Blocks, pages.

But not touch WooCommerce on the live site.

This is what I"m after.. can this be done?

tampe125
Akeeba Staff
After speaking with Nicholas about this, I think you can do that.
As long as you keep the same table prefix, you can restore a partial backup which does not include WooCommerce tables. You'll have to exclude from the backup profile using the Database Tables Exclusions page.

DISCLAIMER First try the partial restoration on a local/dev copy of your live site. We have tested partial restoration with WooCommerce sample data only, not with full/live data.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

myaviation
So really - Its just playing around with what DB tables to update. As I not a Database person..
How do you do a partial push for the DB?

THanks for the info

Rick

dlb
Rick,

Davide is gone for today. The way the restore works is that when a table is present in the backup, that table is dropped, re-created and populated from the backup archive. If a table is not present in the backup, it is not touched by the restore.

The magic happens on the backup side, not the restore side. You want to exclude all of your WooCommerce tables from the backup. That way they are not present in the archive and the restore will leave the existing tables alone.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

myaviation
Where do you not select the tables?

As I just want the Theme to get pushed up thats it..

I can't think I'm the only person to have to go though this for a LIVE working website - that is not static :)

There has to be a way :)

Thanks again

Rick

dlb
Rick,

Towards the bottom of the Akeeba Backup screen there is a section "Include and Exclude Information". Within that you can find the "Database Tables Exclusion" option.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!