John, I recommend that you first use mysqldump to dump the live database's schema to a file, and then use sqlt-diff between the two files.
Something like this: > mysqldump --skip-triggers --no-data --no-create-db --skip-opt > --skip-quote-names --user=$USER --password=$PASSWORD --host=$HOST $DATABASE > > LIVESCHEMA.SQL > sqlt-diff LIVESCHEMA.SQL=MySQL OTHERSCHEMA.sql=MySQL > > LIVE_v_OTHER_diff.txt Best, Malcolm Cook Bioinformatics Stowers Institute for Medical Research - Kansas City, Missouri > -----Original Message----- > From: John Goulah [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2008 5:23 PM > To: sqlfairy-developers@lists.sourceforge.net > Subject: [sqlfairy-developers] diff a file against a db > > So far I've been using sqlt-diff to diff two files: > file1.sql=MySQL file2.sql=MySQL > > > but what I really need is to be able to diff a file against > the actual database and produce a diff. > > > I see there is a parser called DBI-MySQL, but I'm not sure > how to invoke it. My thought would be to use a DSN string, > but then how would one supply a username/password? > > > If someone can clear this up I would be glad to patch the > help output to give some better examples on how this may work. > > > Thanks! > John > > -------------------------------------------------------------- > ----------- > This SF.Net email is sponsored by the Moblin Your Move > Developer's challenge Build the coolest Linux based > applications with Moblin SDK & win great prizes Grand prize > is a trip for two to an Open Source event anywhere in the > world http://moblin-contest.org/redirect.php?banner_id=100&url=/ > -- > sqlfairy-developers mailing list > sqlfairy-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
