<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Jujhar,<div><br></div><div>I haven't tried it myself, but there is a write up on doing this with Phing and DBDeploy available here:</div><div><br></div><div><a href="http://www.davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy/">http://www.davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy/</a></div><div><br></div><div>I think that should allow you to manage your database changes effectively...</div><div><br></div><div>Alex</div><div><br><div><div>On 25 Aug 2009, at 10:58, Jujhar Singh wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-GB" link="blue" vlink="purple"><div class="Section1"><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">Morning All,<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">I was wondering what best practice was for deployment of mysql databases?<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">I知 currently working on a Zend Framework based application for the Sikh community. I知 working off two development machines: my windows laptop at work and my windows laptop at home. I知 checking code in/out of my springloops (subversion) repository. From there I知 deploying via springloops FTP options to a staging linux account (mediatemple.com) and will eventually deploy to the live account (haven稚 decided where yet). It all works a treat and subversion keeps the code between the three machines in sync.<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">What I知 really struggling with is finding a way to deploy and sync the MySQL database between the machines/servers. The database is 60M+ and I知 struggling for ideas. At the stage of development we池e 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.<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">Your help and insight is always appreciated.<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">Many thanks<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">Jujhar Singh<o:p></o:p></div></div>_______________________________________________<br>Phpwm mailing list<br><a href="mailto:Phpwm@mailman.lug.org.uk" style="color: blue; text-decoration: underline; ">Phpwm@mailman.lug.org.uk</a><br><a href="https://mailman.lug.org.uk/mailman/listinfo/phpwm" style="color: blue; text-decoration: underline; ">https://mailman.lug.org.uk/mailman/listinfo/phpwm</a><br></div></blockquote></div><br></div></body></html>