Search Mailing List Archives
[go-friends] GO database table to ER
cjmungall at lbl.gov
Thu Oct 20 09:43:22 PDT 2011
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?
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