GenAP This is a UCSC Genome Browser Mirror hosted by the Genetics and Genomics Analysis Platform
     About GenAP  -   GenAP Pipelines  -   GenAP public Galaxy  -   Epigenomes IHEC Data Portal
GenAP

Downloading Data using MySQL

We have two MySQL databases for public access:

These servers allow MySQL access to the same set of data currently available on our public Genome Browser site. The data are synchronized weekly with the main databases on our public site. During synchronization, the MySQL server can be intermittently out of sync with the main website for a short period of time. The weekly synchronization takes place on Monday mornings from 4:00 am to 9:00 am Pacific Time (GMT -7:00).

Connecting

You must have MySQL client libraries installed on your computer. We recommend using the most current version of the v5.0 MySQL clients.

You can connect to the US MySQL server using the command:

mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A

Or the European MySQl server with this command:

mysql --user=genome --host=genome-euro-mysql.soe.ucsc.edu -A

The -A flag is optional but is recommended for speed.

Once connected to the database, you may use a wide range of MySQL commands to query the database.

Conditions of use

Using the MySQL server with our utilities

The MySQL database can also be used by the numerous utilities in the Genome Browser source tree. Some of these utilities require a password, so you will need to add the following specifications to your $HOME/.hg.conf file (remember to chmod your .hg.conf file to 600 permissions) if you would like to access the US public MySQL server:

#US MySQL server
db.host=genome-mysql.soe.ucsc.edu
db.user=genomep
db.password=password
central.db=hgcentral
central.host=genome-mysql.soe.ucsc.edu
central.user=genomep
central.password=password

Or these lines if you'd like to access the European MySQL server:

#European MySQL server
db.host=genome-euro-mysql.soe.ucsc.edu
db.user=genomep
db.password=password
central.db=hgcentral
central.host=genome-euro-mysql.soe.ucsc.edu
central.user=genomep
central.password=password

Note: You can only have one of these stanzas in your .hg.conf file at one time; including both may cause you to connect to the wrong server.

If you have set up your .hg.conf file as above, you can use the hgsql utility, available from our downloads server in the Utilities section, to access the public MySQL server. The benefit of using the hgsql command is that you don't have to include the username or password as part of your command. You only need to specify the host:

hgsql -h genome-mysql.soe.ucsc.edu

If you prefer a graphical user interface (GUI) to the UCSC database tables, use the Table Browser.

System problems should be reported to genome-www@soe.ucsc.edu. Send questions regarding the database contents or queries to genome@soe.ucsc.edu. Messages sent to this address will be posted to the moderated genome mailing list, which is archived on a SEARCHABLE, PUBLIC Google Groups forum.