[Phpwm] mysql deployment

[Alex Mace]

Hi Jujhar,

I haven't tried it myself, but there is a write up on doing this with  
Phing and DBDeploy available here:

http://www.davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy/

I think that should allow you to manage your database changes  
effectively...

Alex

On 25 Aug 2009, at 10:58, Jujhar Singh 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/fb168baa/attachment.htm