Difference between MySQL databases
- camperjohn
- Guru
- Joined: Nov 28, 2004
- Posts: 1127
- Loc: San Diego
- Status: Offline
May 13th, 2010, 11:37 am
Upload video and picture galleries at http://www.bodydot.com?post+upload+video+picture+gallery
- Anonymous
- Bot
- Joined: 25 Feb 2008
- Posts: ?
- Loc: Ozzuland
- Status: Online
May 13th, 2010, 11:37 am
- joebert
- Sledgehammer
- Joined: Feb 10, 2004
- Posts: 13455
- Loc: Florida
- Status: Offline
May 13th, 2010, 3:43 pm
It seems like all of the pieces of software out there which do this either want you to jump through a bunch of registration hoops, or download a whole suite of tools and spend awhile figuring out which one you actually need. 
--
My first thought is to use mysqldump to export the database snapshots, and then use "diff -minimal a.sql b.sql" to find the differences.
That diff will give you output like this though, which I'm guessing isn't going to be the easiest thing to decipher with a real data set. I suppose it's possible though.
Which if you just want to know which tables changed, those hex offsets could be traced back to the CREATE TABLE statements in b.sql to find out which table changed.
--
My first thought is to use mysqldump to export the database snapshots, and then use "diff -minimal a.sql b.sql" to find the differences.
Code: [ Select ]
mysqldump -uuser -ppassword test > a.sql
# do some stuff
mysqldump -uuser -ppassword test > b.sql
# do some stuff
mysqldump -uuser -ppassword test > b.sql
- mysqldump -uuser -ppassword test > a.sql
- # do some stuff
- mysqldump -uuser -ppassword test > b.sql
That diff will give you output like this though, which I'm guessing isn't going to be the easiest thing to decipher with a real data set. I suppose it's possible though.
Code: [ Select ]
joebert@sr1123wm:/tmp$ diff -d a b
37c37
< INSERT INTO `one` VALUES (123,122),(1,4);
---
> INSERT INTO `one` VALUES (123,122),(1,4),(123,122);
77c77
< -- Dump completed on 2010-05-13 22:28:48
---
> -- Dump completed on 2010-05-13 22:28:59
37c37
< INSERT INTO `one` VALUES (123,122),(1,4);
---
> INSERT INTO `one` VALUES (123,122),(1,4),(123,122);
77c77
< -- Dump completed on 2010-05-13 22:28:48
---
> -- Dump completed on 2010-05-13 22:28:59
- joebert@sr1123wm:/tmp$ diff -d a b
- 37c37
- < INSERT INTO `one` VALUES (123,122),(1,4);
- ---
- > INSERT INTO `one` VALUES (123,122),(1,4),(123,122);
- 77c77
- < -- Dump completed on 2010-05-13 22:28:48
- ---
- > -- Dump completed on 2010-05-13 22:28:59
Which if you just want to know which tables changed, those hex offsets could be traced back to the CREATE TABLE statements in b.sql to find out which table changed.
Strong with this one, the sudo is.
Page 1 of 1
To Reply to this topic you need to LOGIN or REGISTER. It is free.
Post Information
- Total Posts in this topic: 2 posts
- Users browsing this forum: No registered users and 203 guests
- You cannot post new topics in this forum
- You cannot reply to topics in this forum
- You cannot edit your posts in this forum
- You cannot delete your posts in this forum
- You cannot post attachments in this forum
