I am having crazy trouble moving my CiviCRM/Wordpress installation from one server to another.
I don't have many customizations, and we are a young organization, so I am OK with whatever solution gets my contacts and contributions to the new server, whether it's a complete copy or a fresh install and some sort of import. I think I would even be fine migrating to Drupal if it makes things easier (I have experience with Drupal sites as well), since that seems to be the most popular setup.
I have followed the instructions on the wiki, and read a few dozen other articles and threads, but everything I find relates to Drupal and the steps don't seem to line up to Wordpress...something always goes wrong.
I am able to get a new working copy of CiviCRM going but when I import my DB it breaks, and I get errors like this:
Sorry but we are not able to provide this at the moment. DB Constraint Violation - dashboard_id should possibly be marked as mandatory for DashboardContact,get API. If so, please raise a bug report.
I tried exporting using phpMyAdmin, including "disable foreign key constraint checks" and "Add drop table" and other combinations of options...nothing seems to work.
I'm not sure what I'm doing wrong, and would appreciate a little hand.
Some details: - My current install is at 4.7.7 - CiviCRM shares a database with Wordpress