If you are using a large file like the MVP dictionary, you have to modify the mysql parameter file to change max_allowed_packet variable for larger files...
Andy -------------------- Andrew S. Kanter, MD MPH - Director of Health Information Systems/Medical Informatics Millennium Villages Project, Earth Institute, Columbia University - Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology Columbia University Email: [email protected] Mobile: +1 (646) 469-2421 Office: +1 (212) 305-4842 Skype: akanter-ippnw Yahoo: andy_kanter >________________________________ > From: James Arbaugh <[email protected]> >To: [email protected] >Sent: Tuesday, January 17, 2012 7:57 AM >Subject: Re: [OPENMRS-IMPLEMENTERS] conceptid dictionnary > > >Hi Duali, > >With Linux from the terminal window, you should be able to run a command like >this to import the SQL file… > >mysql --user=YOURUSERNAME -p -h localhost openmrs < demo-19.0.sql > >Note, you need to replace YOURUSERNAME with a valid username. You will need >to make sure your database is called openmrs (if not, change the command to >what your database is called). You should run the command from the same >directory where your demo-19.0.sql file is at, or specify the path before the >demo-19.0.sql. When you run the command it will prompt you for the password. > >Thanks, >James > >From:[email protected] [mailto:[email protected]] On Behalf Of >mohamed Duali >Sent: Tuesday, January 17, 2012 5:10 AM >To: [email protected] >Subject: Re: [OPENMRS-IMPLEMENTERS] conceptid dictionnary > >Hi Andrew,Glen, Ben: >I am using Linux Ubuntu.when I saw my database openmrs the table concepte name >is missing the dictionary . I am trying to import demo-19.0.sql but I have in >phpmyadmin this error. >(You probably tried to download a too voluminous file. Please refer to the >documentation for manners to by-pass this limit.). >Thanks for quick replay your Email >Duali > >Le 17 janvier 2012 08:12, Ben Wolfe <[email protected]> a écrit : >There is also this wiki page: https://wiki.openmrs.org/display/RES/Demo+Data > >Ben > >On Mon, Jan 16, 2012 at 9:54 PM, Andrew Kanter <[email protected]> wrote: >Duali, > >Are you interested in maintaining your own data dictionary, or using one of >the standard ones? There are many ways to approach this problem. You can >download the sample dictionary. You can download the MVP/CIEL dictionary which >is quite extensive (and can be viewed online at maternalconceptlab.com). Or >you can use MetadataSharing Module to move only the forms and concepts you >need from one system to another. Depending on what you want to do, this >listserve can provide you more information... > >Andy > >-------------------- >Andrew S. Kanter, MD MPH >- Director of Health Information Systems/Medical Informatics >Millennium Villages Project, Earth Institute, Columbia University >- Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology >Columbia University > >Email: [email protected] >Mobile: +1 (646) 469-2421 >Office: +1 (212) 305-4842 >Skype: akanter-ippnw >Yahoo: andy_kanter > >________________________________ > >From:mohamed Duali <[email protected]> >To: [email protected] >Sent: Monday, January 16, 2012 11:44 AM >Subject: [OPENMRS-IMPLEMENTERS] conceptid dictionnary > >Dear all: > >I no have concept ID dictionary in openMrs. How I can update the >dictionary concept in my database? > >Thanks > >duali > >_________________________________________ > >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] > > > >________________________________ > >Click here to unsubscribe from OpenMRS Implementers' mailing list > > >________________________________ > >Click here to unsubscribe from OpenMRS Implementers' mailing list > > >________________________________ > >Click here to unsubscribe from OpenMRS Implementers' mailing list >________________________________ > Click here to unsubscribe 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]
