GoMiner Local Database and Gene Enhancement Installation

Local Database Installation

Note: These instructions use the convention terms that UPPER CASE AND UNDERLINED should be replaced with
the specifics for your local installation.

There are two ways to install a local MySQL database.

For users running under a Unix-based operation system, there is an automated script. Download and uncompress the script. The instructions for running and configuring the script are in the enclosed README file.
The rest of this page documents the manual procedure for installing a local database. Thanks to Dr. Wilhelm Schneiderhan, Mary Ann Wilson, Kevin Kransler and Edward Lobenhofer for providing these installation instructions.

Install GO Database Locally :

When you download GoMiner™, it is configured to query a database hosted on the GoMiner site. You may wish to run a copy of the database for performance or for data customization.

Install a copy of the MySQL database server if it is not already installed. We have tested GoMiner against MySQL version 5.0. Earlier versions of GoMiner were tested with MySQL versions 3.23 and 4.0, and should still work. An example of these installation can be found here. Make a note of the root pasword that you assign. During the mysql installation process, you must assign a USERNAME and a PASSWORD if one is not already assigned. These are used in the steps below

Log on to the MySQL command line client with root user and password as defined during installation.
mysql -uroot -pPASSWORD

Replace PASSWORD as defined during mysql installation.

In Mysql prompt run the following to create database
mysql> create database IF NOT EXISTS DATABASE;

Replace DATABASE with the name you would like this new database instance to have.

To create user and provide all access to the user, type the following at the MySql prompt
mysql> grant ALL on *.* to 'USERNAME'@'SERVERNAME' identified by 'PASSWORD';

Assign USERNAME with new username which will be used to access database. If you are going to run and access mysql on the same machine, you can use localhost as the SERVERNAME. If you are going to use MySQL from another machine, you can either specify the machine name or '%' (single quotes included). The MySQL documention has more documentation about managing privileges. When you first install MySql, the root user is not assigned a password. It is also a good idea to give your root user a password as described in the MySql installation guide.

Exit mysql at this point by typing the following at mysql prompt
mysql> exit

The current version of GoMiner has been tested with the Sept 2009 build of the database. You can also find other builds of the database, or you can try the latest version. Download the version of the file with the name in the format go_YYYYMM-assocdb-tables.tar.gz.
Download compressed file using one of the link provided above. Extracting the compressed file should create a directory (We refer this directory as GO_DATA_DIR) containing GO data files with *.txt and .sql extension. It is a large file, so be patient. This file is updated monthly, the instructions in this section are appropriate to use if you want to download the latest GO annotations at a later date and update your database with the new file.

From the command-line, run the following script to load the database (USERNAME and PASSWORD must be the same as the ones assigned during MySQL installation; DATABASE should be the instance name established above with the create command. GO_DATA_DIR should be directory where GO data files where downloaded in previous step) Depending on the speed of your hardware, the mysqlimport step can take quite a while to run. Also note that you can also potentially encounter a mysql version problem. The syntax differs based on the OS:

On Unix (inc. Mac OS X):
  cd GO_DATA_DIR
  cat *.sql | mysql -uUSERNAME -pPASSWORD -DDATABASE
  mysqlimport -L -uUSERNAME -pPASSWORD DATABASE *.txt

On Windows:
Download loadDB.bat script (Credits: Dr. Wilhelm Schneiderhan and Mary Ann Wilson).
- Right click on 'loadDB.bat' link
- Select 'Save As' menu. Make sure to retain '.bat' extension
- Choose GO_DATA_DIR directory
Then, execute the script
cd GO_DATA_DIR
loadDB.bat . USERNAME PASSWORD DATABASE

Wait for all database files to load. There will be periods when it seems like everything has frozen, but the script is still working.
h. This will take an extended period of time. Instead of making yourself a cup of coffee, splurge a bit, go out and buy one. By the time you get back, it might be done. Everything will be complete when the command prompt returns. Once this is done, close the command prompt.
When it is done, if you are proceeding with Step 3, leave the DOS window open.

Run Gominer:

When you run GoMiner, change the JDBC URL in the Load Go Terms dialog box to reference your machine and database instance name.
(i.e. jdbc:mysql://YOURDATABASEMACHINEDOMAINNAME/DATABASE or jdbc:mysql://YOURDATABASEMACHINEIPNUMBER/DATABASE)
Change Username and Password in the Load Go Terms dialog box to your USERNAME and PASSWORD
GoMiner "remembers" the most recently-used JDBC URL, USERNAME,and PASSWORD, so you will only need to type these in if you wish to access a different database than you used the last time you ran GoMiner

GoMiner™ is a development of the Genomics and Pharmacology Facility, Developmental Therapeutics Branch (DTB), Center for Cancer Research (CCR), National Cancer Institute (NCI).

Please email us with any problems, questions or feedback on the tool.

Notice and Disclaimer