Thanks, Roger. I took a look at the dump file and indeed that line was
commented out. I will give that a try just as soon as I can get the
Linux OpenMRS installed. I cannot get pass the bug that prevents the
install from completion.
Regards,
Charles Chou
On 2/22/2012 8:34 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) wrote:
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
------------------------------------------------------------------------
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]
