Amazing and thanks for that though I must admit I had trouble keeping at all the info being thrown on to the screen. <br>tony<br><br><div class="gmail_quote">On Thu, Jan 26, 2012 at 12:19 AM, Sohodojo Jim <span dir="ltr"><<a href="mailto:salmons@sohodojo.com">salmons@sohodojo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Benj,<br>
<br>
Assuming that you are keeping your codebases pretty current local and remote<br>
and it is mostly a database synching challenge, here is a screencast that<br>
shows a technique that I have used for years to work with local-sandbox and<br>
public-remote:<br>
<br>
<a href="http://www.sohodojo.biz/sqlyog" target="_blank">http://www.sohodojo.biz/sqlyog</a><br>
<br>
I use a slick app called SQLyog -- there is a free version and a paid<br>
version. I've had the paid version for years and can't live without it. I<br>
believe the free/community version can do the technique I show in the<br>
webcast but I am not totally sure as I don't use that version.<br>
<br>
I know lots of folks want a free tool and/or drush to do similar things. I<br>
just find that the multi-copy tactic I use as shown in the webcast has<br>
served me well, especially when you want to roll back and forth both within<br>
your local dev box and your public server.<br>
<br>
BTW, this webcast was done as an entry for a SQLyog customer testimonial<br>
contest. I didn't win the iPad 2 grand prize -- they tended toward more<br>
highly rating the testimonials from database admins -- but it was fun<br>
putting this presentation together.<br>
<br>
Hope it gives you some ideas about how to organize your daily routine.<br>
<br>
--Sohodojo Jim--<br>
<br>
From: <a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>] On<br>
Behalf Of Ms. Nancy Wichmann<br>
Sent: Wednesday, January 25, 2012 9:06 PM<br>
To: <a href="mailto:support@drupal.org">support@drupal.org</a><br>
Subject: Re: [support] Keeping dev and live site in sync<br>
<div class="im"><br>
I believe he's mostly concerned with new content and users getting pushed<br>
down to his dev instance.<br>
<br>
Option D: Use the Feeds module to pull down the new / modified stuff.<br>
<br>
I'm not sure how you get files that are not fielded.<br>
<br>
Nancy<br>
<br>
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,<br>
Jr.<br>
<br>
</div>________________________________________<br>
<div class="im HOEnZb">From: Benj Fredrick<br>
<br>
this is an age-old drupal question, and there are many different solutions.<br>
The main problem is that site configuration is stored in the db alongside<br>
site content. <br>
<br>
Option A:Use modules like Features and Strongarm<br>
Option B:Use something like Backup and Migrate to only overwrite certain<br>
tables.<br>
Option C:Use Pantheon hosting and their slick UI tools. ;)<br>
<br>
On Wed, Jan 25, 2012 at 2:12 PM, prothero wrote:<br>
Hi. I am pondering the best way to modify and test my site without<br>
corrupting my live site. Currently, I ftp all of the files and db tables to<br>
my local computer and use MAMP to run my development site. But, since my<br>
live site is changing every day from users creating accounts, etc, how<br>
should I set this up so that when I upload my development site to the live<br>
one, it stays current?<br>
<br>
</div><div class="HOEnZb"><div class="h5">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><p><b style="font-family:'Lucida Handwriting',cursive;font-size:13px;background-color:rgb(255,255,255)"><i>Anthony Stefan Maciejowski</i></b></p><p></p>
<p><b><font color="#333399" face="Arial"><span style="font-size:10pt">tony maciejowski</span></font></b><b><font face="Arial"><span style="font-size:10pt"> <font color="black">|</font> <font color="#d1a73d">analyst/programmer </font> <font color="black">|</font> <font color="#00cc00">websites</font> <font color="black">|</font><font color="#FF0000"> <a href="mailto:t_maciejowski@hotmail.com" target="_blank"><font style="background-color:rgb(255,255,0)" color="#FF0000">www.tony-mac.com</font></a></font></span></font></b></p>
<p><font color="black" face="Arial"><span style="font-size:10pt"><b>Twitter: anntosh</b> | <b>Cell: 323.899.6206</b> | <b>Linked-In:</b> <b>Anthony Maciejowski</b> </span></font></p><p><font color="black" face="Arial"><span style="font-size:10pt"> </span></font>“Hope is not the conviction that something will turn out well, but the
certainty that something makes sense, regardless of how it turns out.”</p><p>--- Vaclav Havel<br></p><p></p><br>