I asked the lazyweb: What’s the preferred SQL diff tool? I’d like to take two SQL dumps and get back an SQL file of the difference.
Sheeri Cabral delivers the answer: if you do your DB dump with the –skip-extended-insert option, you can use regular old diff to get you most of the way there. That doesn’t give you an SQL file you can use directly, but it gets you enough of the way there that it’ll do.