Quoting sander-martijn sander@sander-martijn.com:
Anyone know of a place that lists out which files and database tables need to be changed when migrating drupal from one server to another? If not could someone take the time to list them out for me? It would save a lot of headaches.
Install http://drupal.org/project/dba it will provide you with methods to backup via cron and to export/import data. It's listed under "Development" in the modules admin page.
We're setting up our test server now and when it's ready I will copy the database and drupal files to the new server so that content editors can begin entering the content without the risk of my code taking them down. I have enough of the site already configured that I would rather not set it up from scratch but obviously there will be things that need to change (hostname, possibly paths, db connect info etc).
You don't want to transfer any of the cache tables, the sessions table, users tables, and ... Does anyone have other table suggestions not to transfer from testing?
Once it's set up I'll move forward with the traditional develop, test, deploy approach so I don't need a complex setup to synchronize the db or anything, and I don't need directions on how to set up a database or apache or anything - a one time copy/configure these files, change those database entries should be sufficient.
Fingers and toes crossed for good luck. ;)
Earnie -- http://for-my-kids.com/