[Phpwm] mysql deployment
mike at etuna.co.uk
Tue Aug 25 10:56:37 UTC 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Phpwm