Search Mailing List Archives

Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[go-friends] GO database table to ER

Zhiliang hu at
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>
> To: Zhiliang <hu at>
> Cc: gofriends at
> 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
> project?
> ./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
>> but I wish to have one
> in the MySQL Workbench for details.
>> Any help will be appreciated.  Thanks in advance!
>> Zhiliang
>> _______________________________________________
>> go-friends mailing list
>> go-friends at

More information about the go-friends mailing list