Search Mailing List Archives
[go-friends] GO database table to ER
hu at animalgenome.org
Thu Oct 20 14:31:26 PDT 2011
Chris - How nice you have all sorts of these amazing tricks!
Thanks a bundle - you made my day :)
On Thu, 20 Oct 2011, Chris Mungall wrote:
> Date: Thu, 20 Oct 2011 09:43:22 -0700
> From: Chris Mungall <cjmungall at lbl.gov>
> To: Zhiliang <hu at animalgenome.org>
> Cc: gofriends at genome.stanford.edu
> Subject: Re: [go-friends] GO database table to ER
> Hi Zhiliang!
> For historic reasons, you have to run the source sql through the 'compiledb'
> script. Do you already have the sql/ directory checked out from the go-dev
> ./compiledb go-tables-FULL.sql
> You can browse the dir here:
> On Oct 17, 2011, at 8:02 PM, Zhiliang wrote:
>> I wish to have an ER digram for the GO database tables so that I can build
> customized queries more easily. However my attempts by connecting the MySQL
> Workbench to a local copy of a GO db, and by importing all SQL scripts ('cat'
> all into one) into MySQL Workbench, all failed. I am not sure but wonder is
> there a different copy of SQL scripts that can be used for this purpose? (e.g.
> I have successfully use Ensembl SQL scripts to port into MySQL Workbench for
> ER diagrams).
>> I know there is already an ER at the GO site
>> http://www.geneontology.org/GO.database.shtml#diagram but I wish to have one
> in the MySQL Workbench for details.
>> Any help will be appreciated. Thanks in advance!
>> go-friends mailing list
>> go-friends at lists.stanford.edu
More information about the go-friends