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.
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).
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.
On 8/22/07, sander-martijn sander@sander-martijn.com wrote:
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.
Normally nothing except the settings in settings.php needs changing. Oh, and possibly any modifications to the .htaccess file or its suitability for the new server.
Also the names of the directories under 'sites' except 'default', and the location of the 'files' directory.
If there are any references to the old domain name by some modules or in the content, I don't think it is possible to list them, but a text search in the database dump should do the job.
What else... database adjustment if it going to be moved between MySQL 4.0 or older and 4.1 or newer.
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).
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. -- [ Drupal support list | http://lists.drupal.org/ ]
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/
Check out AutoPilot. Why not use a Drupal instance to deploy another?
http://drupal.org/project/autopilot
Disclaimer: I have not dug into this software yet, or even downloaded it for that matter.
Read more here: http://www.workhabit.org/change-management-and-drupal- autopilot-news and here: http://www.workhabit.org/autopilot-alpha-released
-Mike
__________________ Michael Prasuhn mike@mikeyp.net http://mikeyp.net 949.200.7595 714.356.0168 cell 949.200.7670 fax
-
Cog Rusty -
Earnie Boyd -
Michael Prasuhn -
sander-martijn