Charles --
I have come across this problem before. mysqldump doesn't necessarily (in
fact necessarily doesn't) create tables in the order in which they are
constrained. Make sure the line at the beginning of the dump that includes
FOREIGN_KEY_CHECKS=0 is not commented out.
Saludos, Roger
From: [email protected] [mailto:[email protected]] On Behalf Of
Charles C. Chou
Sent: Thursday, February 16, 2012 12:00 AM
To: [email protected]
Subject: Re: [OPENMRS-IMPLEMENTERS] Loading database
I will just re-install the system with the sample data. This is not a live
system, just one I am doing my learning on.
Thanks for your help nonetheless.
On 2/15/2012 6:20 PM, Ben Wolfe wrote:
Does the person that gave you the data have the exact same openmrs version that
you have? If not, then you will have multiple problems such as these.
No, you shouldn't just remove the constraints. :-)
Better to reinstall with demo data. Or install to a different db and export+
import to the one you're using now.
Fyi: your current db now has an issue of missing that table and any other table
before it might be for the wrong openmrs version. :-( Do you have a backup?
Ben
On Feb 15, 2012 11:15 PM, "Charles C. Chou"
<[email protected]<mailto:[email protected]>> wrote:
Hi,
I got this dump file indirectly through one of the openmrs contributors in
an attempt to set up a sample database as I did not check the load sample data
checkbox when I installed. Here is the table create statement that caused the
error:
DROP TABLE IF EXISTS `concept_reference_map`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `concept_reference_map` (
`concept_map_id` int(11) NOT NULL AUTO_INCREMENT,
`concept_reference_term_id` int(11) NOT NULL,
`concept_map_type_id` int(11) NOT NULL DEFAULT '1',
`creator` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL DEFAULT '0002-11-30 00:00:00',
`concept_id` int(11) NOT NULL DEFAULT '0',
`changed_by` int(11) DEFAULT NULL,
`date_changed` datetime DEFAULT NULL,
`uuid` char(38) DEFAULT NULL,
PRIMARY KEY (`concept_map_id`),
KEY `map_for_concept` (`concept_id`),
KEY `map_creator` (`creator`),
KEY `mapped_concept_map_type` (`concept_map_type_id`),
KEY `mapped_user_changed_ref_term` (`changed_by`),
KEY `mapped_concept_reference_term` (`concept_reference_term_id`),
CONSTRAINT `mapped_concept_reference_term` FOREIGN KEY
(`concept_reference_term_id`) REFERENCES `concept_reference_term`
(`concept_reference_term_id`),
CONSTRAINT `mapped_concept_map_type` FOREIGN KEY (`concept_map_type_id`)
REFERENCES `concept_map_type` (`concept_map_type_id`),
CONSTRAINT `mapped_user_changed_ref_term` FOREIGN KEY (`changed_by`)
REFERENCES `users` (`user_id`),
CONSTRAINT `map_creator` FOREIGN KEY (`creator`) REFERENCES `users`
(`user_id`),
CONSTRAINT `map_for_concept` FOREIGN KEY (`concept_id`) REFERENCES `concept`
(`concept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
After doing some searches I think the contraints may be the culprit. Can I just
remove the contraints?
Regards,
Charles Chou
On 2/15/2012 11:45 AM, Wyclif Luyima wrote:
Hi Charles,
Where did you get the file you are loading? Was it from our downloads page?
Wyclif
On Wed, Feb 15, 2012 at 1:54 PM, Charles C. Chou
<[email protected]<mailto:[email protected]>> wrote:
Hi,
I tried to load the openmrs database with an existing database dump but got
the following error:
ERROR 1005 (HY000) at line 737: Can't create table
'openmrs.concept_reference_map' (errno: 121)
Can someone tell me what causes this? Thanks!
Regards,
Charles Chou
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected]<mailto:[email protected]> with "SIGNOFF
openmrs-implement-l" in the body (not the subject) of your e-mail.
[mailto:[email protected]<mailto:[email protected]>?body=SIGNOFF%20openmrs-implement-l]
________________________________
Click here to
unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l>
from OpenMRS Implementers' mailing list
________________________________
Click here to
unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l>
from OpenMRS Implementers' mailing list
________________________________
Click here to
unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l>
from OpenMRS Implementers' mailing list
________________________________
Click here to
unsubscribe<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l>
from OpenMRS Implementers' mailing list
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-implement-l" in the body
(not the subject) of your e-mail.
[mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
