Here’s an invaluable one, for getting the diffs between two databases in MySQL. If you’ve ever wanted to know what was changed, here’s the tool for you. Installing it on Windows required a bit of poking around (I’m not a Perl regular) but is totally workable even for Java fools like me.
Here’s what you have to do:
- Install Perl from ActiveState
- Download MySQL-diff current version from CPAN
- Download Class::MakeMethods from CPAN
- Copy the .pm files for each module under c:\perl\lib or wherever you’ve installed it, understanding the containing folder name must match the module name.
- Rename the mysqldiff file to have .pl on the end
- Write a batch file to call it with whatever params you want
Related posts:
ActivePerl comes with a CPAN-imitation utility called PPM (Perl Package Manager). It connects to a Perl package database that is nowhere near as complete as CPAN’s, but is serviceable for quickly and easily installing many common Perl packages, including the Class:MakeMethods required for running MySQL-Diff under Windows.
It is vastly preferable to let PPM install your Perl packages than to do it yourself.