Re: [PLUG] Mysql versioning

[Eric <eric@lucii.org>]

I think of "version" as referring to the schema of the database and 
"backup" as storing dumps of the data.

My preference is to have a table of application parameters that has the 
"version" of the current schema stored as a row.  If you're using a 
source control system then store the DDL file or files that create the 
database in it.  The DDL for the application parameters table would 
insert one row containing the version number.

HTH

Eric


Christopher M. Jones wrote:
> Brian Stempin wrote:
>    
>> I've never had to do this, but the first thing that came to my mind was
>> using SVN/CVS/whatever to check in a MySQL dump.
>>
>> Of course, this is only practical for fairly small data sets.
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ___________________________________________________________________________
>> 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
>>      
>
> Yea, I've been grepping google for a while today, and that's the
> solution everyone points to. I don't think I'm going to have a huge
> database, but the problem is that the site is highly dynamic. Users have
> access to the live site and are constantly adding / changing content.
> Meanwhile, I'm making template and configuration changes. And I'm only
> one of a couple of develpers on the site. I need a way to keep
> everything synced up, and I want something that works like svn. I think
> I'm not going to find it.
> ___________________________________________________________________________
> 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
>    

-- 
#  Eric Lucas
#
#                "Oh, I have slipped the surly bond of earth
#                 And danced the skies on laughter-silvered wings...
#                                        -- John Gillespie Magee Jr

___________________________________________________________________________
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