Hi Anton, The MySQL files are available at: hgdownload.cse.ucsc.edu/mysql.
For example, to get the 3 MySQL files for the hg18 knownGene table, you can do the following: rsync -avP --delete --max-delete=20 \ rsync://hgdownload.cse.ucsc.edu/mysql/hg18/knownGene.* . Fan. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Anton Kratz Sent: Saturday, February 21, 2009 11:18 PM To: UCSC Genome Browser Help Desk Subject: [Genome] how to get all the UCSC tables in mysql format & installin local mysql server? Dear UCSC team, I often download the tab-separated tables from the table browser, and then I build a local mysql table reflecting this table (by creating a table with columns named and typed after the description of the "describe table schema"-button), and then I speed this table up by adding index keys. This approach was okay as long as I worked only with a few tables but now I need to work and rapidly access entries in many tables. Is there a way of somehow directly downloading the tables in "mysql-format", if something like this exists (I do not have much experience with mysql), and then load the tables directly? What I want are just all the UCSC tables in my local mysql installation, for direct & fast access. But re-building all the tables manually and then loading the files into the tables, is not feasible. Thanks, Anton _______________________________________________ Genome maillist - [email protected] http://www.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] http://www.soe.ucsc.edu/mailman/listinfo/genome
