On Sat, Apr 27, 2002 at 10:42:47AM +0200, Jens Vonderheide wrote: > Hi, > > is there any way to have MySQL automatically keep track of any changes > I do with ALTER TABLE and later spit out the changes again?
Not really, no. > I use one database (well, actually several, but that's not important > here) for development and one database for the production > system. Now, whenever I change the db structure, I have to jot it > down in a text file and later copy-paste it to the production db. Of > course, as anything that is done manually, this can (and already > has) lead to problems if the text file is not kept in sync with the > changes in the db. It's really not all that different that source code. For each application I build, I tend to put the source code in our CVS repository long with the $foo.sql file(s) to reconstruct the tables. Just as there's nothing preventing me from deploying a new release of an application before checking all my changes into CVS, the same is true of your database structures. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 79 days, processed 2,065,187,269 queries (302/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php