You could also use the sql definition text files from hgdownload. http://hgdownload.cse.ucsc.edu/goldenPath/hg19/database/*.sql
also available via FTP and rsync. You could rsync all of these .sql files to a local directory and allow everyone to use local files. If you want to run MySQL exercises, you should use small samples from small tables. Running exercises over an entire database is an immense amount of work. There are several hundred Gb of data in hg19. --Hiram ----- Original Message ----- From: "robert kuhn" <[email protected]> To: "Martin Tompa" <[email protected]> Cc: "[email protected]" <[email protected]> Sent: Tuesday, April 5, 2011 1:43:02 PM Subject: Re: [Genome] possibly excessive MySQL queries Hi, Martin, thanks for asking. That might add up to an awful lot of queries if you are using a human assembly. there are 1000s of tables in there. You might consider parsing the trackDb table first, because the entries _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
