On Thu, Jul 06, 2006 at 05:01:10PM +0200, Marc Dirix wrote: > As I use postgresql, that won't work. > > Although the general idea does.
For PostgreSQL, s/mysqldump/pg_dump -s/ and s/mysql/psql/. And use createdb instead of mysqladmin create. > Thanks for the tip! > > > > Op 6-jul-2006, om 16:28 heeft Paul J Stevens het volgende geschreven: > > >There's no native capability yet. > > > >I use: > > > >mysqladmin create dbmaila > >mysqladmin create dbmailb > >mysqldump -d dbmail|mysql dbmaila > >mysql dbmailb < sql/mysql/create_tables.mysql > >mysqldump -d dbmaila > dbmaila.sql > >mysqldump -d dbmailb > dbmailb.sql > >diff dbmaila.sql dbmailb.sql > > > >this should provide you with a pretty good idea of any changes. > > > > > >Marc Dirix wrote: > >>Hi, > >> > >>Since I run svn head most of the time, is there a way to keep > >>track of changes in the sql tables. > >>Recently I found my dbmail_replycache table lacking a column which > >>did go into the sql schema templates but not in my db, because it was > >>created before the change was made. > >> > >>If I know something has changed, I can create my own migrate scripts. > >> > >>Best regards, > >> > >>Marc > >>_______________________________________________ > >>Dbmail-dev mailing list > >>[email protected] > >>http://twister.fastxs.net/mailman/listinfo/dbmail-dev > >> > > > >-- > > ________________________________________________________________ > > Paul Stevens paul at nfg.nl > > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > > The Netherlands________________________________http://www.nfg.nl > > > > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
