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
PASSWORD as defined during mysql installation.
- In Mysql prompt run the following to create database
mysql> create database IF NOT EXISTS DATABASE;
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';
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
- 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):
cat *.sql | mysql -uUSERNAME -pPASSWORD -DDATABASE
mysqlimport -L -uUSERNAME -pPASSWORD DATABASE *.txt
Download loadDB.bat script (Credits: Dr. Wilhelm Schneiderhan and Mary Ann Wilson).
Then, execute the script
- Right click on 'loadDB.bat' link
- Select 'Save As' menu. Make sure to retain '.bat' extension
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.
- When you run GoMiner, change the JDBC URL in the Load Go Terms dialog box to reference your machine and 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