[ensembl-dev] DB Schemas

[Andy Yates]

Hi there,

It shouldn't be. We check this version out, develop and check back in each release. A lot of Ensembl developers use Macs so maybe there is an issue there. Otherwise we've not seen any issues in corruption

Regards,

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 10 May 2013, at 14:57, Stuart Meacham <sm766 at cam.ac.uk> wrote:

> 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/
> 
> 
> _______________________________________________
> 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/