Back to Downloads

Loading the local database

To deploy POV against a local database instance, you must follow three
steps.
1. Install mysql
2. Set up the required MySql metagraph accounts and databases
3. Install the required data
4. Tell POV where to find your local instance.
1. Installing MySql:
We currently deploy POV against mysql 3.23.53 on a variety of platforms. We intend to move to version 4 shortly after it is declared a final release.
For most platforms, one can retrieve a binary installer from www.mysql.com. MacOS X requires a custom installer built by Marc Liyanage, available at here. One can also download a nifty startup item and installation instructions specific to the Mac from that location.
The MySql AB folks will be doing the builds for the 4.0 releases for MacOS X as well, and will have it at their main site.
Follow the instructions in their documentation for setup instructions for the database.
2. Setting up the Metagraph database and account.
Assuming your root password for mysql is admin, you can set up the metagraph database and user by executing the following:
mysql --user=root --password=admin mysql
CREATE DATABASE metagraph;
GRANT SELECT ON metagraph.* TO metagraph@localhost IDENTIFIED BY 'collaborator';
GRANT SELECT ON metagraph.* TO metagraph@"%" IDENTIFIED BY 'collaborator';
create database metaquery;
create table metaquery.JdbcInQuery (
queryID integer not null,
queryValue varchar(255) null,
queryValue4 integer null,
queryValue6 float null,
queryValue93 datetime null
);
create index JdbcInQueryID on metaquery.JdbcInQuery (queryID);
create table metaquery.JdbcInQuery_Seq (
nextval integer not null default 0
);
insert into metaquery.JdbcInQuery_Seq (nextval) values (0);
insert into db values
('%','metaquery','%','Y','Y','Y','Y','N','N','N','N','N','N');
update db set User=null where Db='metaquery';
exit;
3. Loading metagraph data:
Our full human, mouse, and rat dataset is stored in metagraph_humanmouseratgenes_go_links.sql.gz dataset; you can load it via:
gunzip -c metagraph_humanmouseratgenes_go_links.sql.gz | mysql --user=root --password=admin metagraph
This will take quite some time - on a TiBook 667 with a few other tasks running, it took roughly ten minutes.
4. Altering the database properties file.
In the pov_public directory, you will find a file named local.properties.
Rename this file to metagraph.properties.
If you followed the instructions above, you will be using the same read-only user and password that metagraph.org does. The host, however, will be your own local machine.

To repoint MeshView to your local database, just put the jar in the same folder as the metagraph.properties file you just renamed