13 votes

How should I copy a site from production to staging?

Many of the steps documented on the "Migrating a site" wiki page are handled automatically now. Here's my recipe, which is far from perfect, but is much closer. Copy the entire filesystem to the ...
user avatar
8 votes
Accepted

Change domain name (wordpress)

Below are the simplified instructions taken from Moving an Existing Installation to a New Server or Location, but specific to answer your question. Open the file wp-content/plugins/civicrm/civicrm....
user avatar
  • 614
6 votes

Changing hosts for CiviCRM -without current host cooperation

How can we extract the data of our CiviCRM install without support from the hosting provider? MySQL via network / phpMyAdmin / DB backups If your hosting company provides CPanel, remote MySQL, or a ...
user avatar
6 votes

Implementations Basics (Costs, Timescales, etc)

Honestly without a significant amount of detail regarding your current database, how you're going to use CiviCRM, what kind of site it is being connected to, etc, no one can give you anything but a ...
user avatar
6 votes
Accepted

Where is the link between a CiviCRM contact and Wordpress user stored in the database?

Great question! The matching between the CMS user and the CiviCRM contacts relies, like most "relationships" between entities in CiviCRM, on an additional table that maps the IDs between the ...
user avatar
  • 1,048
5 votes

Migration error: “The user specified as a definer does not exist”

Maybe you do not have ssh access and MySQL access. But this can also done from the user interface. To rebuild the triggers use the url: http://<<servername>/civicrm/menu/rebuild?reset=1&...
user avatar
4 votes
Accepted

How to correct domain in URLs after a change?

I would double check the civicrm.settings.php file to make sure the paths and URL are updated in there. For example: define( 'CIVICRM_UF_BASEURL' , 'http://foo.example.com/' ); While you are in ...
user avatar
4 votes

I need to migrate data from one CiviCRM on Drupal instance to a clean one. HELP?

Before pronouncing the old database deceased, I would make sure the structure is correct and if not what is broken. You can try this: https://github.com/progressivetech/civi-schema-harmonizer or http:...
user avatar
4 votes

Migration to new server - "The requested page "/" could not be found."

Make sure you have migrated Drupal correctly and all of the non-CiviCRM portions of the site function correctly. Sometimes the .htaccess file doesn't get transferred with FTP and it is an important ...
user avatar
4 votes
Accepted

Copy a Sites Customizations (Custom Fields, report instances, etc)

The API approach you're using is the "best" approach - but agreed it can be slow. There are alternative approaches though: Delete all the records in civicrm_contact with a direct SQL call - except ...
user avatar
4 votes
Accepted

Migrate from Drupal to WordPress - 'DB Error: no such table'

This is down to the fact that you probably have logging turned on in your Drupal environment. So the easiest thing to do would be to turn it off before you migrate and turn it back on in Wordpress (...
user avatar
  • 2,396
4 votes

Where is the link between a CiviCRM contact and Wordpress user stored in the database?

In the civicrm_uf_match mysql table
user avatar
  • 1,920
3 votes

Moved Wordpress and CivCRM to new server recently

Looks like you've a couple of hangovers! These are usually in the CiviCRM Administer > System Settings > Resource URLs, and Administer > System Settings > Directories pages. Update those, clear cache, ...
user avatar
  • 2,343
3 votes

Migration to new server - "The requested page "/" could not be found."

If your site has been migrated to a different version of the Drupal codebase, then make sure you've run the database updates (drush updb or visit update.php) This will update your Drupal DB to match ...
user avatar
3 votes

Reconnecting CiviCRM DB in Wordpress

Try these, in this order: Check that the CIVICRM_UF value in civicrm.settings.php has been updated to reflect the changed host CMS Try visiting /wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/...
user avatar
3 votes
Accepted

Migration error: “The user specified as a definer does not exist”

Xavier, your answer would have worked if I had had the luxury of re-importing. It turns out that there is a single function in the CiviCRM DB that for some reason uses a hard-coded username and ...
user avatar
  • 355
3 votes

I need to migrate data from one CiviCRM on Drupal instance to a clean one. HELP?

If you wish to transfer the content of the database a) export the existing data. You can do this as an action from the search/find screens. Export contacts, activities, memberships, contributions as ...
user avatar
3 votes
Accepted

How to migrate database without logs

This can be done on the commandline. You can pass a list of tables to mysqldump and omit the tables starting with log_. (Below, testdb is the name of the DB we're using. You may want to add other ...
user avatar
3 votes
Accepted

CiviCRM Wordpress Migration: Stumped by the Database

There is some documentation here that should help: https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/ Are you copying the Wordpress database as well? You are trying to switch servers ...
user avatar
  • 11k
3 votes

Http 500 Page not Found error when plugin clicked on backend - Wp-engine

You should double check your civicrm_settings.php file. Particularly the section on File System Paths. Make sure the setting $civicrm_root is the correct path to civicrm for the new server. Hope this ...
user avatar
  • 2,289
3 votes
Accepted

Issues with Migration - Cannot add foreign key constraint

It looks like your error message is truncated, which makes this a little hard to troubleshoot, so if you can find a way to generate a non-truncated version of this message, I think the solution should ...
user avatar
3 votes

"Could not find a valid session key." when making a contribution

Many of these "lost session" issues (which stem mainly from redirect_canonical correcting CiviCRM's malformed URLs) are solved in more recent versions of CiviCRM. All I can really do is suggest you ...
user avatar
3 votes

Trying to migrate data from Drupal 7 to new install on Drupal 9

This sounds a bit dicey, but fortunately I think there's a simpler solution. My answer on migrating CiviCRM to WordPress is generic for moving CiviCRM to ANY new CMS - even the same CMS on a different ...
user avatar
3 votes

Migration from CiviCRM (Drupal 7) to Salesforce

I would take a different approach to what your trying to do. If you want to extract data from CiviCRM you probably want to use something like the Data Processor extension and CSV out everything you ...
user avatar
  • 2,396
2 votes

How to migrate database without logs

You may want to move log tables from main database to specially created database via settings in civicrm.settings.php. Of course, new empty database has to be created first. After that please find ...
user avatar
  • 1,350
2 votes

Migration error: “The user specified as a definer does not exist”

Similar to the accepted answer, in my case there were two case views which contained the incorrect definer information. Performed the alter query on the view and it was fixed. Those view names were - ...
user avatar
2 votes

Migration error: “The user specified as a definer does not exist”

did you dump the old site and restored it on the new server? check that mysql dump file, it should contain the olduser string, replace it in that file with the new one before doing the restore and it ...
user avatar
  • 10.1k
2 votes

Copy a Sites Customizations (Custom Fields, report instances, etc)

If the reason you want to delete the data is because of privacy issues, you could just scramble it. There are a few ways to do that, e.g. this extension: https://github.com/adixon/ca.civicrm.testsite
user avatar
  • 5,994
2 votes

All Contribution pages result in "Your browser session has expired" "Could not find a valid session key"

Are you by any chance using a caching plugin or extension? We had this error on event registrations and had to exclude the event pages from being cached. That resolved the issue.
user avatar
2 votes

Site transfer from Joomla

You mean with your own CMS? you will mostly have to deal with the authentication and permission system. look at what is done in civi for WP, J+, Drupal to give you a sense of the scope. I personally ...
user avatar
  • 10.1k

Only top scored, non community-wiki answers of a minimum length are eligible