Re: [PLUG] Mysql versioning

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.

S/

On Mon, Sep 1, 2008 at 7:06 PM, Brian Stempin <brian.stempin@gmail.com> wrote:

+1 To Eric's solution...it's much more elegant than an entire database dump.

___________________________________________________________________________
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

--
Shameel Arafin

___________________________________________________________________________ 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