What's the best way to migrate CiviCRM to a new a server? I haven't been able to get it to work. I've been following this guide. Here are the steps I've been taking to for the migration.
1.) SQLDump and exclude the flowing tables in old database.
db_name.civicrm_domain
db_name.civicrm_acl_cache
db_name.civicrm_acl_contact_cache
db_name.civicrm_cache db_name.civicrm_group_contact_cache
2.) Setup new CMS (WordPress, Joomla or Drupal) I have tried all three platforms
3.) SQLDump old database into new
2.) Clear cache and rebuild menus
I know that I must be missing steps. Here are some of the problems I'm running into:
1.) There is a problem when trying to run custom reports that repopulate after rebuilding the menu. The message I get is (error: You have tried to access a report that does not exist.) Where do you find custom reports made on the old system? Whats the best way to transfer them, copy paste?
2.) When clicking a a link on the menu or running search I get this (error: DB:no such field).
I'm guessing that when I transfer the custom templates/reports (not sure the proper nomenclature) the database error will resolve itself?
Here is the database error from the CiviCRM error log:
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT civicrm_uf_group.id, civicrm_uf_group.title, civicrm_uf_group.created_id, civicrm_uf_group.is_active, civicrm_uf_group.is_reserved, civicrm_uf_group.group_type, civicrm_uf_group.description
FROM civicrm_uf_group
LEFT JOIN civicrm_uf_join ON (civicrm_uf_group.id = uf_group_id) AND civicrm_uf_group.is_active = 1
WHERE civicrm_uf_join.module = 'Search Profile' ORDER BY civicrm_uf_join.weight, civicrm_uf_group.title [nativecode=1054 ** Unknown column 'civicrm_uf_group.description' in 'field list']
SELECT version FROM civicrm_domain