All geek questions in one place

Comparing data from mysql backups

I have several backups of my database, and I'm trying to figure out if there is a way to compare the data in the backups to see how the data changes over time. I do not have a timestamp for the fields I want to compare, but I have a unique identifier in the row. Backups are .sql files created using mysqldump.

Is there any way to do this?

+3
source share
5 answers

There are many comparison tools in MySQL, including the MySQLDiff tool ( http://www.mysqldiff.org/ ). There is also a command line interface that can be found here:

http://devzone.intellitree.com/projects/intellitree-cli-extension-to-mysqldiff/

See the previous StackOverFlow entry for a visual comparison tool similar to this (plus some other solutions):

https://stackoverflow.com/questions/218499/mysql-diff-tool

+4
source

Theoretically, you can import your backups as a second database, and then write a PHP script that connects to your SQL server and iterates through the elements using a unique identifier, comparing it with that.

diff , .

+2

, WinMerge , . . .

+2

mysqldump, . (.. Diff unix), .

- , .

, - MySQL.

, , .

,

-R

+1

pydumpy https://code.google.com/p/pydumpy/ (mirror: https://github.com/miebach/pydumpy)

, diff

, mysql .

0

Source: https://habr.com/ru/post/1708701/

More articles:


All Articles