[Phpwm] mysql deployment

[Mike Tipping]

Personally I always have a development database online accessible from all
my development locations and connect to that so I don¹t need to carry the
database around with me. It¹s a problem if I drop offline but that¹s only
been an issue once in the last 3 years.

I script any changes when I¹m happy with them so I can deploy them to the
live server when the code deploys to the server.


On 25/8/09 10:58, "Jujhar Singh" <jujhar at medilinkwm.co.uk> wrote:

> 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/d4083981/attachment.htm