<HTML>
<HEAD>
<TITLE>Re: [Phpwm] mysql deployment</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>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. <BR>
<BR>
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.<BR>
<BR>
<BR>
On 25/8/09 10:58, "Jujhar Singh" <jujhar@medilinkwm.co.uk> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>Morning All,<BR>
<BR>
I was wondering what best practice was for deployment of mysql databases?<BR>
<BR>
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.<BR>
<BR>
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.<BR>
<BR>
Your help and insight is always appreciated.<BR>
<BR>
Many thanks<BR>
<BR>
Jujhar Singh<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:10.0px'>_______________________________________________<BR>
Phpwm mailing list<BR>
Phpwm@mailman.lug.org.uk<BR>
https://mailman.lug.org.uk/mailman/listinfo/phpwm<BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:10.0px'><BR>
</SPAN></FONT></FONT>
</BODY>
</HTML>