This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How Do I Do A Local Build Of Ensembl'S Mysql Database?

Is this the best how to guide on doing a full local mirror of the Ensembl's MySQL database?


Very possible that I'm wrong, but based on a quick review there appears to be typos in the how to, for example:

create database homo_sapiens_core_61_37f

Should be:

create database homo_sapiens_core_61_37f;

note that the ";" or semi-colon is missing at the end.

While is is not a major issue, just making sure I'm looking at the best and most up to data guide to doing this.


Questions, feedback, requests -- just comment, thanks!!

ensembl mysql

3 answers

This is the guide i used. I'm not sure it can be any more up-to-date though - there are only 3 sql statements you need to import the database (though you can do it differently if you want to speed things up)

While ENSEMBL guide is way more recent there are more comprehensive (but by no means complete or finished) descriptions how to get the local installation up and running:

http://openwetware.org/wiki/Wikiomics:Ensembl_local_install

and

http://openwetware.org/wiki/Wikiomics:Ensembl_local_install_draft

In a some free moment I hope to update it to the current versions of ENSEMBL, Perl etc. but do not count on this happening in the next few weeks.

@darked89: Super, thanks for sharing -- all and all, I just looking for semi-recent guides to rolling out ENSEMBL, so your answer so far is the best. Selecting you as the answer for now. Again, thank you!!

This is an up-to-date guide, however, we should do a careful reread for typos. Thank you for pointing this out to us.

@Giulietta - Ensembl Helpdesk: Appears that's not a typo in the SQL, I'd double check with someone that "really" knows SQL. Cheers!

Our webteam agrees about the semicolon- it has been added in, so you'll see it on the next release. They are MySQL masters, don't worry. =) The rest of the doc looks fine to them.

Log in to answer this question.