[ensembl-dev] DB Schemas

[Stuart Meacham]

Hi,

I have tried various methods to get hold of the variation schema MWB 
file but have trouble with all of them - MySQL Workbench fails to open 
the resultant file on several different platforms. I don't have problems 
with the other schema's suggested. Is the one in CVS corrupt somehow?

Cheers

Stuart

On 07/05/13 09:19, Laurent Gil wrote:
> Hi Stuart,
>
> The MySQL Workbench file of the Ensembl Variation schema 71 is 
> available on the CVS (database-schema.mwb):
> http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl-variation/schema/?root=ensembl&pathrev=branch-ensembl-71 
>
>
> Cheers,
>
> Laurent
>
> On 07/05/2013 09:13, Emily Pritchard wrote:
>> Sent directly to me rather than list:
>>
>> Hi Emily,
>>
>> Those PDF's on the website look like they were produced in MySQL 
>> Workbench - is there any chance of getting the workbench files 
>> themselves? Particularly the human Variation DB . . .
>>
>> Thanks
>>
>> Stuart
>>
>> On 03/05/2013 12:47, Stuart Meacham wrote:
>>> Hidden in plain view, eh?
>>>
>>> Thanks
>>>
>>> Stuart
>>>
>>> On 03/05/13 12:39, Emily Pritchard wrote:
>>>> Hi Stuart
>>>>
>>>> Links to the different database schema can be found here:
>>>> http://www.ensembl.org/info/docs/api/index.html
>>>>
>>>> All the best
>>>>
>>>> Emily
>>>>
>>>> On 03/05/2013 12:27, Stuart Meacham wrote:
>>>>> Hi,
>>>>>
>>>>> Is there a way of visualising the schema for a particular DB? I 
>>>>> dumped the latest Human Variation database (excluding data) and 
>>>>> imported into MySQL Workbench only to find that there are no 
>>>>> foreign keys so it's really quite difficult to understand the 
>>>>> links between the various tables. I appreciate there is a 
>>>>> performance overhead for foreign key constraints so I wasn't 
>>>>> overly surprised but would really appreciate some overview of the 
>>>>> DB structure.
>>>>>
>>>>> Any help greatly appreciated
>>>>>
>>>>> Thanks
>>>>>
>>>>> Stuart
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list    Dev at ensembl.org
>>>>> Posting guidelines and subscribe/unsubscribe info: 
>>>>> http://lists.ensembl.org/mailman/listinfo/dev
>>>>> Ensembl Blog: http://www.ensembl.info/
>>>>
>>>
>>>
>>> _______________________________________________
>>> Dev mailing list    Dev at ensembl.org
>>> Posting guidelines and subscribe/unsubscribe info: 
>>> http://lists.ensembl.org/mailman/listinfo/dev
>>> Ensembl Blog: http://www.ensembl.info/
>>
>
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: 
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/