Database migration help needed

Y

YeOldeOke

Senior Member
Joined
May 21, 2012
Messages
843
Reaction score
24
Location
Pretoria
I am in the process of upgrading our e-commerce (woo) WP website and it appears that I have wandered into a steamy, slippery marsh, and sinking fast.

I have experience in just about every facet of IT/computing since the early 80's, but one area I have not had any exposure to are databases.

The problem is this:

The staging site using Shoptimizer / Elementor was developed after cloning the live site (Divi / Divi builder). While developing the staging site, of course e-commerce continued on the live site, which was adding new users/orders/reviews/wallet data etc. on a daily basis.

Now I have to update those transactions to the staging site before pushing it live, and I am having a helluva time getting a plugin that does the job without either hanging the server, corrupting /duplicating the data in some way or another. (After updating wallet one user ended up with R2m in his wallet o_O )

It seems that I may have to update the database tables manually(?) but I have no idea where to find the applicable tables and how to add to them. The Great Omnipresent G is not leading me to much clarity either, and it is becoming a major time issue.

Please help the blind man :crying: , either free coz you're a helluva nice guy, for cash or for barter (I have a number of exciting ex-wives and the odd daughter or two that I can spare)
 
Last edited:
There are several tools available at database level, like replication, log shipping, triggers, etc. There are also application level synchronization tools available. Depending on your technologies, any combination of the above could assist with your issue.
 
Have a look at this video. It is not quite what you are doing at the moment by the sound of it but he touches on moving the database in one go. I've used his method and a customised plugin that's mentioned in the video with great success. It might lead you down the correct rabbit hole at the very least.
 
Sync by itself will not work, will it? The primary database contains pages built with Divi builder, the secondary database pages built with Elementor, and thos should nit be synced.
 
lowriderza said:
Have a look at this video. It is not quite what you are doing at the moment by the sound of it but he touches on moving the database in one go. I've used his method and a customised plugin that's mentioned in the video with great success. It might lead you down the correct rabbit hole at the very least.
Click to expand...
I can migrate the whole database no problem, the problem is adding recent activity to the database without also updating things like pages etc.

I tried All In One but it ends up hanging the server and timing out. Extending server timeout, mem allocated etc doesn't help, neither does the suggestions of support at the host.

I will watch that video though thanks.
 
YeOldeOke said:
I can migrate the whole database no problem, the problem is adding recent activity to the database without also updating things like pages etc.

I tried All In One but it ends up hanging the server and timing out. Extending server timeout, mem allocated etc doesn't help, neither does the suggestions of support at the host.

I will watch that video though thanks.
Click to expand...
I had a simmilar problem with using All in One I ended up using the customised version of All in One they mentioned in the video and it did work for me. But it does sound like you need to make granular changes to the database and that is completely out of my wheelhouse.
 
You need to mention what database system you're using. MS SQL Server, MySQL, Oracle, Progress etc.
This will determine what is best.
I only have good experience in MS SQL Server and there I will use log shipping. This will ship all the transactions from one database to another.
If you only need to ship a selected group of tables, then replication is the way to go.
 
Thanks to all that responded, i do appreciate it.

I have used a database plugin suite from Webtoffee that brings it in by order/user/review etc. Still got errors when trying to export/import the complete range of components, but it works well just to do the changed items.

:thumbsup:
 
glad you got somewhere, this is an annoying problem

in WP, basically everything is a post (but WooCommerce does have some specific tables), and it uses EAV

github.com

Database Description

A customizable, open-source ecommerce platform built on WordPress. Build any commerce solution you can imagine. - woocommerce/woocommerce
github.com github.com

so it would be simple to migrate your orders, but customers/users will be a bit more tricky
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X