CiviCRM Community Forums (archive)

I have been trying to upgrade to a newer release of civi and running into several problems.

After an unsuccessful attempt to run the update script that resulted in foreign constraint violations, I discovered the posts about the civicrm_db_integrity tools.  Running the db integrity check resulted in over 4000 warnings - after running the repair tool and manually cleaning up the database,  more checks, I am down to 13 messages about tables not in the 2.2 schema.  (several of these are from civicrm_import_job or are custom tables I am guessing)

I have tried to rebuild the schema using the (restored) 2.2.9 database as in the steps in
wiki.civicrm.org/confluence/display/CRMDOC40/Ensuring+Schema+Integrity+on+Upgrades

% mysqldump -u root -p -c -e -n -t civicrm > civi2.9-backup-schema.sql
% mysqldump -d -u root -p civicrm civicrm_report_instance civicrm_member_roles_rules civicrm_group_roles_rules   civicrm_value_academic_address_5 civicrm_value_affiliation_3 civicrm_value_constituent_information_1 civicrm_value_hotel_6 civicrm_value_hotel_accomodations_7 civicrm_value_join_date_4 civicrm_value_ob_section_join_date_8  civicrm_import_job_126d68ff56e7840c8b3acaa09e14faa1  civicrm_import_job_1421a7b8055265226f4b86270047f319  civicrm_import_job_3d8ccdc59ca120b6a521abcc3b394f20 civicrm_import_job_5fcb633f4b06f39423d9f9a93e25979e  civicrm_import_job_6992a9c6fe42841b620368c67dcd50a0  civicrm_import_job_6b4971ae77869e69deaf65e6d506f70f  civicrm_import_job_7cc870e742080d1e258f5b1b0c80f30c  civicrm_import_job_93da8e2353d5a104357214e65e7e8367  civicrm_import_job_b25be09e58058985e947dbcbb3e93127 civicrm_import_job_c2edefb66eeb46887d318e5ed0ed891e > customfields.sql
# Step 3

%mysql -u root -p mysql
mysql> drop database civicrm; create database civicrm;


# Step 4 
% cd  /var/www/html/sites/all/modules/
% mysql -u root -p civicrm < civicrm/sql/civicrm.mysql
% mysql -u root -p civicrm < /tmp/customfields.sql
% mysql -u root -p civicrm < /tmp/civi2.9-backup-schema.sql

but at the last step after importing the database I get an error:

ERROR 1146 (42S02) at line 22: Table 'civicrm.access' doesn't exist

Any suggestions on what I did wrong? or what I should do next? (I am a mysql novice here)

Running the civicrm upgrade script on the "repaired"database still fails with a foreign constraint violation
- I can post that message if it helps after restoring the backup yet another time :-)

m