Good Morning Kishore: Please note the instructions for building a genome browser in the source tree directory: src/product/README.*
Yes, create the ce6 database before trying to work with it: $ hgsql -e "create database ce6;" mysql To find the source tree: http://genome.ucsc.edu/admin/mirror.html#step6 --Hiram Kishore Kamati wrote: > Good Morning, > > I downloaded the ce6 database from > http://hgdownload.cse.ucsc.edu/goldenPath/ce6/database/ > > and I see that there are many .sql and .gz files and would like to populate > my local database with these file's information > > And the instruction in that link says... > > To load one of the tables directly into your local mirror database, > > for example the table chromInfo: > ## create table from the sql definition > $ hgsql ce6 < chromInfo.sql > ## load data from the txt.gz file > $ zcat chromInfo.txt.gz | hgsql ce6 --local-infile=1 > -e 'LOAD DATA LOCAL INFILE "/dev/stdin" INTO TABLE chromInfo;' > > > And my question is... > > 1. where can I download hgsql executable? > 2. Instead of giving the command hgsql... and zcat for each and > everyfile one by one, is it possible to populate all files in one go? > 3. And do I need to create the "ce6" database locally before I go > ahead with above instructions( hgsql ce6... and zcat chromInfo...) > > > Thank you, > Kishore _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
