Hello Tiandao, The six required tables need to be added to your pol2 database.
http://genomewiki.cse.ucsc.edu/index.php/Minimal_Browser_Installation A minimal browser database [aka assembly] needs six tables: grp chromInfo trackDb hgFindSpec gold gap Try this and let us know if it does not solve the problem, Thanks jen --------------------------------- Jennifer Jackson UCSC Genome Informatics Group http://genome.ucsc.edu/ On 5/5/10 11:18 AM, Tiandao Li wrote: > Hi, > > We installed a minimal genome browser locally with hg18 only. We want to > load generated wig files (human hg18) so we can view them on local browser. > We used wigEncode to generate wig and wib files. > > peak$ wigEncode PolII_eland_sorted2.wig PolII.wig PolII.wib > Converted PolII_eland_sorted2.wig, upper limit 4385.00, lower limit 2.00 > > then > mysql> create database pol2; > > copy system-wide hg.conf to my folder as .hg.conf > > ~]$ /opt/kent/hgLoadWiggle pol2 xxx PolII.wig > > Can't start query: > select * from chromInfo > > mySQL error 1146: Table 'pol2.chromInfo' doesn't exist > > Please show me how to load wig files to local mysql database. > > Thanks!!! > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
