Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

is it possible to find out the difference between two mysql dump files?

I need know all the changes that happen in the mysql database during a process. All changes are insert only. For that i dumped the database before and after using following command

> mysqldump -u root -p sgdatabase_310ec9ef0bcea1f9c677369ea973ab75 > AfteOpDb.sql

Is there a way to see all the insert happens in the database on table by table bases?

And i don't mean text compare tool, Something specific to db that shows the difference graphically would be very nice.

OS : Windows

like image 435
Mayank Patel Avatar asked Sep 27 '22 06:09

Mayank Patel


1 Answers

As stated by OMG Ponies in this answer, you can use a DIFF tool. A couple that can be used and are free (again, suggested in the original post) are:

  • KDIFF
  • winmerge
like image 58
Acharya Anurag Avatar answered Oct 12 '22 21:10

Acharya Anurag