On Mon, May 07, 2007 at 05:13:12PM +0100, Nigel Peck wrote: > I'd like to find a way of comparing the two MySQL database > strcutures and getting a list of the differences, anyone know of any > modules/methods for doing this?
I don't know about something Perl-specific, but I guess what you want is something like this: mysqldump serverdb > server.sql mysqldump clientdb > client.sql diff -Napu clientdb serverdb > changes.diff Requires some postprocessing, of course, but chances are it'll work fine. Leslie -- Personal homepage: https://viridian.dnsalias.net/~sky/homepage/ gpg --keyserver pgp.mit.edu --recv-keys DD4EBF83
pgpjtH5ORlz4a.pgp
Description: PGP signature