Through my searching, I have found many tutorials and HOWTos for installing Drupal. I haven't seen anything that addresses the traditional method for web development which maintains separate systems for development and production. I'm hoping that with your help, we can document a way to easily move Drupal sites (all files and database data) between systems to facilitate a better work-flow between a development environment and a production environment.
I am not comfortable performing updates on my production system, while it is off-line, only to test it when it is brought back on line. I'm assuming this is what some of you are doing. I'm also assuming that there are those among us who have a process (perhaps some bash scripts) to ease the migration from a dev environment onto the production system(s). Is anyone still developing on systems separate from their prod environments?
I am relatively new to Drupal, though I'm as old as the Internet (our completed plans came together in a final format around the same time, but my gestation period was shorter) and no stranger to bits and bytes. I have no doubt that I can engineer a solution - but I'm thinking someone already has, and I just haven't seen it. My other thought is that folks might think the dev/prod paradigm is out-dated or doesn't/shouldn't apply to Drupal. I hope the later is not the case.
All ideas are welcome here.
Please let me know how you are tackling this, and I'll do my best to pull all the ideas into a HOWTO.