[ensembl-dev] Database names? show databases;

[Andy Yates]

Hi Maury,

Sure thing a quick show databases for release 67 show databases like:

homo_sapiens_cdna_67_37
homo_sapiens_core_67_37
homo_sapiens_coreexpressionatlas_67_37
homo_sapiens_coreexpressionest_67_37
homo_sapiens_funcgen_67_37
homo_sapiens_otherfeatures_67_37
homo_sapiens_rnaseq_67_37
homo_sapiens_variation_67_37
homo_sapiens_vega_67_37

Should you want to view these yourself I would recommend firing up the mysql command line binary & executing a show databases on the server. The command is

mysql --host=ensembldb.ensembl.org --port=5306 --user=anonymous

Andy

Andrew Yates                   Ensembl Core Software Project Leader
EMBL-EBI                       Tel: +44-(0)1223-492538
Wellcome Trust Genome Campus   Fax: +44-(0)1223-494468
Cambridge CB10 1SD, UK         http://www.ensembl.org/

On 19 Jun 2012, at 16:27, Maury Markowitz wrote:

> On 2012-06-19, at 8:59 AM, Andy Yates wrote:
>> It seems that this is a known "issue" with the MySQL/ODBC connector:
>> 
>> http://forums.mysql.com/read.php?37,206198,206198#msg-206198
>> http://bugs.mysql.com/bug.php?id=39965
> 
> Ahh, ok, thanks Andy. I'll definitely report this.
> 
>> A number of users there suggest some answers but it seems from the last post on the bug report that DATABASE is a required parameter in a connection String; something other connectors such as DBD::mysql & JDBC/ConnectorJ do not enforce. Unfortunately we don't support connections made via ODBC but it sounds like both Matthew & Beth have given some good suggestions to help you out. 
> 
> For argument's sake, can you give me the name of any one of these DBs? I don't have anything else to use to find them out.
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> List admin (including subscribe/unsubscribe): http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/