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

Chris Mungall cjmungall at
Thu Oct 20 09:43:22 PDT 2011

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