There are two scripts that are used to create the database's schema and populate it with data.

First, run the sql script.

On the command line type:

mysql -h host -u username -p password database < tables_for_entrezgene.sql

replacing host, username, password, and database with real values.


Second, run the perl script.

There are some changes you will need to make to the file before running the perl scirpt.

Using a text editor (emacs, nedit, vi) the following variables at the top of the script will need to be changed:
For connecting to MySQL database:
$host - host machine name
$db - database name
$user - MySQL username
$pw - MySQL password

For downloading and general processing:
$location_of_script - location of parse_entrezgene.pl
$basic_dir - location where files will be downloaded
$SQL - location of parsed datafiles


To run the perl script, on the command line type:

perl parse_entrezgene.pl