MySQL Forums
Forum List  »  Backup

Re: schema version control
Posted by: Rick James
Date: July 03, 2013 09:19PM

No TRIGGERs on ALTER TABLE statements.

mysqldump --no-data, plus svn, is probably the surest way to track changes. But it only checks as often as you run the script.

Next you will want ways to rollback changes? That gets really messy. (Think DROP COLUMN, then ADD it back -- complete with data.)

Perhaps you should start by limiting how many people have GRANT permission to make changes.

Options: ReplyQuote

Written By
July 02, 2013 04:02AM
Re: schema version control
July 03, 2013 09:19PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.