Changing domain in 2.0.2

[myles]

The following worked for me - but please note that the last steps are particular to my installation - they are tables that are created for custom data on contact records.

-- Updates the domain_id of a CiviCRM installation.

-- Set these values as necessary for your needs.
  SELECT @old_domain_id := 2;
  SELECT @new_domain_id := 1;

-- Disable foreign key checks while we change the domain_id
SET FOREIGN_KEY_CHECKS = 0;


--UPDATE civicrm_accept_credit_card SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_acl_group SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_activity_type SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_contact SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_contribution SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_contribution_page SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_contribution_type SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_custom_group SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_dedupe_rule_group SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_domain SET id = @new_domain_id WHERE id = @old_domain_id;
UPDATE civicrm_dupe_match SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_event SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_financial_trxn SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_gender SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_group SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_im_provider SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_individual_prefix SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_individual_suffix SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_location SET entity_id = @new_domain_id WHERE entity_table = 'civicrm_domain';
UPDATE civicrm_location_type SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_mailing SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_mailing_component SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_mapping SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_membership_status SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_membership_type SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_msg_template SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_mobile_provider SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_option_group SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_payment_instrument SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_payment_processor_type SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_preferences SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_preferences_date SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_product SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_project SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_relationship_type SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_tag SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_task SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_uf_group SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_uf_match SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
-- THE FOLLOWING are specific to our installation - have a look at what yours may have!
UPDATE civicrm_value_2_ablaze_fields_1 SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_value_2_number_partner_relationships_6 SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_value_2_organisation_details_2 SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
UPDATE civicrm_value_2_schools_3 SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;
--UPDATE civicrm_validation SET domain_id = @new_domain_id WHERE domain_id = @old_domain_id;

-- Re-enable foreign key checks
SET FOREIGN_KEY_CHECKS = 1;