this is an age-old drupal question, and there are many different solutions. The main problem is that site configuration is stored in the db alongside site content. <div><br></div><div>Option A:</div><div>Use modules like <a href="http://drupal.org/project/features">Features</a> and <a href="http://drupal.org/project/strongarm">Strongarm</a> to get as much of your configuration into code as possible. This can then be versioned and pushed to new servers without touching the db.</div>
<div><br></div><div>Option B:</div><div>Use something like <a href="http://drupal.org/project/backup_migrate">Backup and Migrate</a> to only overwrite certain tables.</div><div><br></div><div>Option C:</div><div>Use Pantheon hosting and their slick UI tools. ;)</div>
<div><br></div><div>There are probably other options I haven't thought of. Option A is my personal preference. I only pull the db backwards from live -> dev. Code obviously goes the other direction. A custom module with <a href="http://api.drupal.org/api/drupal/developer--hooks--install.php/function/hook_update_N/6">hook_update_N</a>() functions can help a lot.</div>
<div><br></div><div>-Benj (benjf)</div><div><br><br><div class="gmail_quote">On Wed, Jan 25, 2012 at 2:12 PM, prothero <span dir="ltr"><<a href="mailto:prothero@geol.ucsb.edu">prothero@geol.ucsb.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Folks:<br>Hi. I am pondering the best way to modify and test my site without corrupting my live site. Currently, I ftp all of the files and db tables to my local computer and use MAMP to run my development site. But, since my live site is changing every day from users creating accounts, etc, how should I set this up so that when I upload my development site to the live one, it stays current?<br>
<br>I'm sure this problem has been solved, but ....<br>Regards,<br>Bill<br><div>
<span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><div style="word-wrap:break-word">
<span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<font face="Helvetica" size="3" style="font:normal normal normal 12px/normal Helvetica;font-size:12px"><span style="font-size:12px"><span style="font-size:12px"><span style="font-size:12px">William A. Prothero</span></span></span></font></p>
<p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><span style="font-size:12px"><a href="http://earthednet.org/" target="_blank">http://earthednet.org/</a></span></p><br></span></span></span></span><br>
</div></span></span>
</div>
<br></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div>