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
