CiviCRM Community Forums (archive)

For anyone who might be having the same problem, I think I found the solution.  I found the following:

http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

and modified the suggestions there.

Since I'm installing on CiviCRM 2.0.x, on the production server I ran civicrm.mysql rather than civicrm_41.mysql. I then dumped my data out of the local database with the flags noted, and read that back in to the production database. The first attempt failed, as it tried to load data into custom data tables not created by the generic civicrm.mysql script. Those tables are named civicrm_value_xxx.  I created a create-table script for those tables and reran everything.

So, it was basically this:
- on production server, run civicrm.mysql
- on production server, run script to create custom data tables
- on production server, run dumpFile.sql to load in local data

When I fired up CiviCRM, I received the following message:

"Error: Could not create directory: /Users.

If you have moved your database from a development install to a production install and the direcotory paths are different, please set the column config_backend in the civicrm_domain table to NULL. You will need to reinitialize your settings in the production install."

So, I set the column value to NULL, and things seem to be working. Hope this helps someone.