WordPress WooCommerce Staging Site Database Sync
I manage a WordPress WooCommerce site which has a couple mishaps in the recent past. There is no staging environment setup which would have prevented the mishaps and is not trying to set one up.
I have researched many WordPress DB Sync plugins, however, not many states they work well with WooCommerce. The issue is on my side, the product team can update add/remove products, categories, blog posts, etc. at any given time, they have no set time-frame window which updates the site.
I need a way that I can sync menu structures, products, and all, blog posts, etc. with the production environment. I need to sync, because while the product team is working new orders come in and comments are posted, etc.
Is there any easy way to set up a staging site that will accomplish this?
Daily, I work with MSSQL and write a lot of SQL, so I thought I could write a sync script for moving/syncing data to production, however, the command I needed "MERGE" is not available in MySQL. Or, is there a way WordPress can run on MSSQL?
Any ideas?
mysql
sql-server wordpress woocommerce edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
add a comment |
I manage a WordPress WooCommerce site which has a couple mishaps in the recent past. There is no staging environment setup which would have prevented the mishaps and is not trying to set one up.
I have researched many WordPress DB Sync plugins, however, not many states they work well with WooCommerce. The issue is on my side, the product team can update add/remove products, categories, blog posts, etc. at any given time, they have no set time-frame window which updates the site.
I need a way that I can sync menu structures, products, and all, blog posts, etc. with the production environment. I need to sync, because while the product team is working new orders come in and comments are posted, etc.
Is there any easy way to set up a staging site that will accomplish this?
Daily, I work with MSSQL and write a lot of SQL, so I thought I could write a sync script for moving/syncing data to production, however, the command I needed "MERGE" is not available in MySQL. Or, is there a way WordPress can run on MSSQL?
Any ideas?
mysql
sql-server wordpress woocommerce edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
do you really need the newest orders etc on your development enviroment? why not make your changes, and copy those changes to live, instead of pushing everything?
– Stender
Nov 15 '18 at 12:09
No I don’t, I just can’t do a mysqldump of staging and overwrite production.
– Joshua Wieczorek
Nov 15 '18 at 12:13
Main Problem is that some WooCommerce stuff is saved in wp_posts … so moving a dump is not a option.
– Johannes Grandy
Nov 15 '18 at 14:59
add a comment |
I manage a WordPress WooCommerce site which has a couple mishaps in the recent past. There is no staging environment setup which would have prevented the mishaps and is not trying to set one up.
I have researched many WordPress DB Sync plugins, however, not many states they work well with WooCommerce. The issue is on my side, the product team can update add/remove products, categories, blog posts, etc. at any given time, they have no set time-frame window which updates the site.
I need a way that I can sync menu structures, products, and all, blog posts, etc. with the production environment. I need to sync, because while the product team is working new orders come in and comments are posted, etc.
Is there any easy way to set up a staging site that will accomplish this?
Daily, I work with MSSQL and write a lot of SQL, so I thought I could write a sync script for moving/syncing data to production, however, the command I needed "MERGE" is not available in MySQL. Or, is there a way WordPress can run on MSSQL?
Any ideas?
mysql
sql-server wordpress woocommerce edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
I manage a WordPress WooCommerce site which has a couple mishaps in the recent past. There is no staging environment setup which would have prevented the mishaps and is not trying to set one up.
I have researched many WordPress DB Sync plugins, however, not many states they work well with WooCommerce. The issue is on my side, the product team can update add/remove products, categories, blog posts, etc. at any given time, they have no set time-frame window which updates the site.
I need a way that I can sync menu structures, products, and all, blog posts, etc. with the production environment. I need to sync, because while the product team is working new orders come in and comments are posted, etc.
Is there any easy way to set up a staging site that will accomplish this?
Daily, I work with MSSQL and write a lot of SQL, so I thought I could write a sync script for moving/syncing data to production, however, the command I needed "MERGE" is not available in MySQL. Or, is there a way WordPress can run on MSSQL?
Any ideas?
mysql
sql-server wordpress woocommerce mysql
sql-server wordpress woocommerce edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
edited Nov 15 '18 at 12:07
Gufran Hasan
3,63041628
3,63041628
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
asked Nov 15 '18 at 12:03
Joshua WieczorekJoshua Wieczorek
315213
315213
do you really need the newest orders etc on your development enviroment? why not make your changes, and copy those changes to live, instead of pushing everything?
– Stender
Nov 15 '18 at 12:09
No I don’t, I just can’t do a mysqldump of staging and overwrite production.
– Joshua Wieczorek
Nov 15 '18 at 12:13
Main Problem is that some WooCommerce stuff is saved in wp_posts … so moving a dump is not a option.
– Johannes Grandy
Nov 15 '18 at 14:59
add a comment |
do you really need the newest orders etc on your development enviroment? why not make your changes, and copy those changes to live, instead of pushing everything?
– Stender
Nov 15 '18 at 12:09
No I don’t, I just can’t do a mysqldump of staging and overwrite production.
– Joshua Wieczorek
Nov 15 '18 at 12:13
Main Problem is that some WooCommerce stuff is saved in wp_posts … so moving a dump is not a option.
– Johannes Grandy
Nov 15 '18 at 14:59
do you really need the newest orders etc on your development enviroment? why not make your changes, and copy those changes to live, instead of pushing everything?
– Stender
Nov 15 '18 at 12:09
do you really need the newest orders etc on your development enviroment? why not make your changes, and copy those changes to live, instead of pushing everything?
– Stender
Nov 15 '18 at 12:09
No I don’t, I just can’t do a mysqldump of staging and overwrite production.
– Joshua Wieczorek
Nov 15 '18 at 12:13
No I don’t, I just can’t do a mysqldump of staging and overwrite production.
– Joshua Wieczorek
Nov 15 '18 at 12:13
Main Problem is that some WooCommerce stuff is saved in wp_posts … so moving a dump is not a option.
– Johannes Grandy
Nov 15 '18 at 14:59
Main Problem is that some WooCommerce stuff is saved in wp_posts … so moving a dump is not a option.
– Johannes Grandy
Nov 15 '18 at 14:59
add a comment |
1 Answer
1
active
oldest
votes
My suggestion, you can use default WooCommerce Import and Export available on the Product page on the top side.
It is the best option to save all database in Raw format and easily restore as per your need.
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53319116%2fwordpress-woocommerce-staging-site-database-sync%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
My suggestion, you can use default WooCommerce Import and Export available on the Product page on the top side.
It is the best option to save all database in Raw format and easily restore as per your need.
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
add a comment |
My suggestion, you can use default WooCommerce Import and Export available on the Product page on the top side.
It is the best option to save all database in Raw format and easily restore as per your need.
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
add a comment |
My suggestion, you can use default WooCommerce Import and Export available on the Product page on the top side.
It is the best option to save all database in Raw format and easily restore as per your need.
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
My suggestion, you can use default WooCommerce Import and Export available on the Product page on the top side.
It is the best option to save all database in Raw format and easily restore as per your need.
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
answered Nov 15 '18 at 13:25
ZohaibZohaib
4710
4710
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53319116%2fwordpress-woocommerce-staging-site-database-sync%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
do you really need the newest orders etc on your development enviroment? why not make your changes, and copy those changes to live, instead of pushing everything?
– Stender
Nov 15 '18 at 12:09
No I don’t, I just can’t do a mysqldump of staging and overwrite production.
– Joshua Wieczorek
Nov 15 '18 at 12:13
Main Problem is that some WooCommerce stuff is saved in wp_posts … so moving a dump is not a option.
– Johannes Grandy
Nov 15 '18 at 14:59