Re: Diff on a database structure

2007-05-07 Thread Nigel Peck
David Van Ginneken wrote: This may work for you: http://www.adamspiers.org/computing/mysqldiff/ http://search.cpan.org/~aspiers/MySQL-Diff-0.33/ I tried it comparing 2 test databases here and it appears to work. Looks like exactly what I'm

Re: Diff on a database structure

2007-05-07 Thread David Van Ginneken
This may work for you: http://www.adamspiers.org/computing/mysqldiff/ http://search.cpan.org/~aspiers/MySQL-Diff-0.33/ I tried it comparing 2 test databases here and it appears to work. On 5/7/07, Nigel Peck <[EMAIL PROTECTED]> wrote: Hi, When I'm developing web applications I have a dev ve

Re: Diff on a database structure

2007-05-07 Thread Rene Schickbauer
Hi! > 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? Here's more or less what some commercial tools do: **pseudocode start** get all lines, split them into a datastructure like t

Re: Diff on a database structure

2007-05-07 Thread Nigel Peck
Hi Jen, Thanks for your suggestion, I don't have a master build script, I do it be hand through phpMyAdmin and then use the backup feature of that if I want to move it. I'm really looking for something that I can say to: "compare this database with this one and tell me what the differences

Re: Diff on a database structure

2007-05-07 Thread leslie . polzer
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 i

Diff on a database structure

2007-05-07 Thread Nigel Peck
Hi, When I'm developing web applications I have a dev version of the scripts, modules and database and a live version. Nothing new there. I'm trying to automate the process of moving the dev site to the live site (the dev sites are on a Fedora server on my desk and the live sites on a Redha