[Phpwm] mysql deployment

[Jon Spriggs]

Why not write a command which does a mysqldump to create or overwrite an
existing DATBASE.SQL file, then perform your version control on that file?
At the remote end you svn up and then run mysql < DATABASE.SQL? The first
hit will be a hard one, but subsequent changes will just be diffs.

Rgds,
-- 
Jon "The Nice Guy" Spriggs LPIC-1 Certified


2009/8/25 Jujhar Singh <jujhar at medilinkwm.co.uk>

>  Morning All,
>
>
>
> I was wondering what best practice was for deployment of mysql databases?
>
>
>
> I’m currently working on a Zend Framework based application for the Sikh
> community.  I’m working off two development machines: my windows laptop at
> work and my windows laptop at home.  I’m checking code in/out of my
> springloops (subversion) repository.  From there I’m deploying via
> springloops FTP options to a staging linux account (mediatemple.com) and
> will eventually deploy to the live account (haven’t decided where yet).  It
> all works a treat and subversion keeps the code between the three machines
> in sync.
>
>
>
> What I’m really struggling with is finding a way to deploy and sync the
> MySQL database between the machines/servers.  The database is 60M+ and I’m
> struggling for ideas.  At the stage of development we’re at there are quite
> a few changes happening to the schema and content of the database so I need
> to keep them synced until this stabalises.
>
>
>
> Your help and insight is always appreciated.
>
>
>
> Many thanks
>
>
>
> Jujhar Singh
>
> _______________________________________________
> Phpwm mailing list
> Phpwm at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.lug.org.uk/pipermail/phpwm/attachments/20090825/b9ff03be/attachment.htm