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.
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:10If 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:10dbForge try
navasiolau2021-10-05 23:00:10- I want to solve it because I get an error even if I use mysql -u root with mysql
- Can't start mysql server
- PhpMyAdmin error: Access denied for user
- It is impossible to connect to MySQL through node.js, but through Shell everything is fine
- php : After transferring the site from the server to the server on Drupal, it does not connect to MySQL
- php : Ubuntu 20.04 LTS, MySQL CPU Load 100%
- mysql : Write error messages when restoring the database in the log file
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