CiviCRM Community Forums (archive)

I am working on a Drupal 5.5/CiviCRM 1.9 site on my local machine, and I would like to move it to a web server.  Is there a prescribed method for doing this?

Moving the files and the database(s) should generally work, provided you update the config files accordingly.

I have Drupal installed and running, and I've installed CiviCRM from scratch with the idea of just replacing the database with a dump from my existing CivicRM database on my local machine.  I've done it before, but whenever I try to import the .sql file, I get SQL errors about violating foreign key constraints.  Does CiviCRM have a mechanism for doing this?

How do you do your database dump? mysqldump always works for me (i.e., creates a conflict-less SQL dumps).

Assuming Drupal is working correctly on your new host... the basic steps are:

* Install a copy of the 1.9 codebase on your new host
* Copy the CiviCRM settings file (<drupal_root>/sites/default/civicrm.settings.php) from your test server to your new host
* Edit the $civicrm_root variable as needed to reflect the directory structure on the new host. Also edit both Drupal and CiviCRM DSN values as needed.
* Create an empty DB for CiviCRM on the new host (with DB name and credentials as entered in the settings file)
* Use mysqldump to dump your 1.9 (test) DB to a file
* Upload and load the dump file to your empty DB on the new host
* Clear out the DB stored configuration info in the new DB (since it contains paths and URLs from your test server)
UPDATE civicrm_domain SET config_backend = NULL WHERE id = 1;
If you're logged in to Drupal, log out and then log back in. You should be set.

Please confirm how these steps worked for you... since we probably need a section in the doc for this procedure :-)