Here are some things to keep in mind when using this script: To do so, navigate to the directory containing the Semantic Network files using the Windows explorer and double-click on the "populate_net_mysql_db.bat" file you just finished editing. Set MYSQL_HOME="C:\Program Files\MySQL\MySQL Server 5.5" After configuring these four parameters, this section of your script may look something like the following: Remember to enclose the value in quotes if the directory name contains spaces. This is likely to be something like "C:\Program Files\MySQL\MySQL Server 5.5". MYSQL_HOME should be set to the installation directory of your local MySQL server. The directory will also contain an SQL script for creating the tables.Įdit the script and configure the four parameters at the top of the script. If you are running MetamorphoSys in a Windows environment, in your output directory (after running MetamorphoSys with the "Semantic Network" box checked and the MySQL database selected) you should see a batch file script called "populate_net_mysql_db.bat" This script can be used to load the Semantic Network into a MySQL database. For example:ĬREATE DATABASE IF NOT EXISTS umls CHARACTER SET utf8 COLLATE utf8_unicode_ci Configuring and Running the Load Script Windows We recommend using UTF8 and the utf8_unicode_ci collation setting. Two important considerations when creating a MySQL database are the default character set and collation settings. In order to load the Semantic Network into a MySQL database, you will have to either use an existing database or create a new one. Recommended Software Version: MySQL Server 5.5 Creating a Database Also, select the "MySQL" option from the "Choose Database Load Scripts" pick-list on the "Install UMLS" screen. To generate the necessary files and scripts, select the "Semantic Network" checkbox on the "Install UMLS" screen. This document is a guide to loading the UMLS Semantic Network into a MySQL database by using the scripts and files created by MetamorphoSys.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |