Re: [PLUG] Mysql versioning

["Christopher M. Jones" <cjones@partialflow.com>]

Shameel Arafin wrote:
> We use 'migration scripts' at work, to track database schema changes. So,
> let's say I add a table to the db. That table was created with some sort of
> "CREATE..." statement. That statement goes into a file, and that file is
> tracked in SVN. Then, when a push is made to the production server/database,
> the migration script gets run on the production db.
> 
> We also periodically do a dump of the entire db, but most changes are
> tracked on an incremental, migration-basis.
> 
My problem is that versioning the schema isn't enough, since what the 
database holds is some important configuration data that directly 
relates to how the application function, and not just what it displays. 
What I want to sandbox are those configuration changes. So I want to 
version some of the data, as well as the schema.

I was looking at various ways of doing incremental dumps into an svn 
repo. I was also looking at ways of recording queries, as you describe, 
to run on the production db.

All great suggestions. I think I'm just going to have to do some 
experimentaton to find what works best for our deployment.
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug