Search Mailing List Archives
[go-friends] GO database table to ER
Chris Mungall
cjmungall at lbl.gov
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:
http://geneontology.svn.sourceforge.net/viewvc/geneontology/go-dev/trunk/sql/
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!
>
> Zhiliang
>
> _______________________________________________
> go-friends mailing list
> go-friends at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/go-friends
More information about the go-friends
mailing list