Database Backup > Database Import?

tgifol

At one point in the last 3 years I wound up relocating half way across the country. Putting my original ITFLOW install on hold. Once Moved back from that trip, I didnt have the space to setup servers and continue production.

Due to this, I decided to spin up some azure instances for my tools as my servers were too bulky for my location at the time.

As of now, Weve been able to recover the virtual images from Azure and load them into our Hyper-V environment.

My question/issue is, How do I merge 2 seperate databases into one. Both databases have different data. . Clients, tickets, invoices. I want to merge it all back into one instance. How can I achieve this efficiently with minimal head bashing?

Any advice is welcome. I was thinking maybe installing PHPmyAdmin and doing an import that way. But…. Id rather pick some brains here before I go crazy and potentially destroy my databases.

Thanks in advance.

wrongecho

Hey!

There have been very significant database changes between now and three years ago. This is not really a straightforward backup/import and is probably going to be quite tricky.

Even if lots of the database schema hadn't changed (it has!), you can't just "merge" both databases and expect things to work. For instance, both instances will have a client with the ID of 1 - this would need to be adjusted on one of the databases - globally across all tables - so it doesn't overlap with the other database. Otherwise, you'd have tickets / contacts linked with the wrong client.

Personally, I don't really know what to suggest other than doing per client csv exports / imports for each module, but even then you'll be having to fix up the csv exports to allow for fields that have since changed. Unfortunately, we wouldn't cover this under sponsor support as an instance more than 6 months out of date.

Hopefully someone else will have other ideas! I wonder if AI can save you.

JosephWithCOR

Having combined multiple clients into a single client, an import doesn't import a full export file. Just a limited column stripped down version.

My two cents.

tgifol

What if i told you I had access to both locally in a hyper v vm. seperate. Also up to date?

magixnetworks

tgifol You would still have 2 databases with conflicting ID fields. If you exported then changed all the ID fields to continue from the end of destination database then matched them up in the any table that references them then potentially you could do it… It'd be a long task though depending how many customers you have on the old one

uluvdj

I was able to restore my entire itflow setup to a new server without having to go through setup again. The install is under HestiaCP which backs up an entire snapshot nightly of all the sites under a user, including the database, web files and certificates in under 2 mins. The backup file gets updated nightly.