Why not write a command which does a mysqldump to create or overwrite an existing DATBASE.SQL file, then perform your version control on that file? At the remote end you svn up and then run mysql < DATABASE.SQL? The first hit will be a hard one, but subsequent changes will just be diffs.<br>
<br>Rgds,<br clear="all">-- <br>Jon "The Nice Guy" Spriggs LPIC-1 Certified<br>
<br><br><div class="gmail_quote">2009/8/25 Jujhar Singh <span dir="ltr"><<a href="mailto:jujhar@medilinkwm.co.uk">jujhar@medilinkwm.co.uk</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-GB">
<div>
<p>Morning All,</p>
<p> </p>
<p>I was wondering what best practice was for deployment of
mysql databases?</p>
<p> </p>
<p>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 (<a href="http://mediatemple.com" target="_blank">mediatemple.com</a>)
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.</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>Your help and insight is always appreciated.</p>
<p> </p>
<p>Many thanks</p>
<p> </p><font color="#888888">
<p>Jujhar Singh</p>
</font></div>
</div>
<br>_______________________________________________<br>
Phpwm mailing list<br>
<a href="mailto:Phpwm@mailman.lug.org.uk">Phpwm@mailman.lug.org.uk</a><br>
<a href="https://mailman.lug.org.uk/mailman/listinfo/phpwm" target="_blank">https://mailman.lug.org.uk/mailman/listinfo/phpwm</a><br>
<br></blockquote></div><br>