Home>

There are 2 databases of 150 GB in expanded form each, in essence it is one database, but dumps with a difference of several months. They are temporarily deployed on a virtual machine running Ubuntu. It is necessary to compare them by content and add records from the new one to the older database. I didn't find any good tools to do this, it's not realistic to do it with your hands. From what I have already tried -Novicat, but when trying to compare databases it hopelessly freezes and the process dies. For any help I will be extremely grateful, because I have not come across this one yet.

I tried dbForge tools a long time ago (albeit for Sql Server). For MySql, too. But I don't know how it is on large amounts of data.

Alexander Petrov2021-10-05 23:00:10

It is necessary to compare them by content and add records from the new one to the older database. What about records that are in the old but not in the new one? leave? What if they conflict with a new record at a non-key unique index? PS. If you need "and add" -then what for to compare? just INSERT IGNORE -it will compare itself in the process of adding ...

Akina2021-10-05 23:00:10

If there is in the new one, it must be added, if there is a conflict, the data from the new one replaces the old ones. How can INSERT IGNORE be applied to an entire database?

navasiolau2021-10-05 23:00:10

dbForge try

navasiolau2021-10-05 23:00:10