<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
In fact, MySQL 5.0 will not work for some of the tables since they are using partition table format which is supported from MySQL 5.1.<br><br>Regards,<br><br>Zhibin Lu<br>Bioinformatics Support<br><br>Ontario Institute for Cancer Research           <br>MaRS Centre, South Tower<br>101 College Street, Suite 800<br>Toronto, Ontario, Canada M5G 0A3<br><br><div><hr id="stopSpelling">From: shola.richards@novartis.com<br>To: zhbluweb@hotmail.com; dev@ensembl.org<br>Subject: RE: [ensembl-dev] MySQL 5.5<br>Date: Mon, 18 Jul 2011 15:06:09 +0000<br><br>

<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">


<style>
.ExternalClass .ecxshape
{;}
</style><style>
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass p.ecxecxmsonormal, .ExternalClass li.ecxecxmsonormal, .ExternalClass div.ecxecxmsonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.ecxecxmsohyperlink
{;}
.ExternalClass span.ecxecxmsohyperlinkfollowed
{;}
.ExternalClass span.ecxecxemailstyle17
{;}
.ExternalClass p.ecxecxmsonormal1, .ExternalClass li.ecxecxmsonormal1, .ExternalClass div.ecxecxmsonormal1
{margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
.ExternalClass span.ecxecxmsohyperlink1
{color:blue;text-decoration:underline;}
.ExternalClass span.ecxecxmsohyperlinkfollowed1
{color:purple;text-decoration:underline;}
.ExternalClass span.ecxecxemailstyle171
{font-family:'Arial','sans-serif';color:windowtext;font-weight:normal;font-style:normal;}
.ExternalClass span.ecxEmailStyle26
{font-family:'Arial','sans-serif';color:#1F497D;font-weight:normal;font-style:normal;}
.ExternalClass .ecxMsoChpDefault
{font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;}
.ExternalClass div.ecxWordSection1
{page:WordSection1;}

</style>


<div class="ecxWordSection1">
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D">Hi Zhibin,</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D">Thanks for your reply.  Unfortunately, the documentation still says MySQL 5.0, therefore we weren’t sure.
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D">Anyway, that’s good news, so... Thank you!</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D">Kind regards,</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D">Shola</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:'Arial','sans-serif';color:#1F497D"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">From:</span></b><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'"> Zhibin Lu [mailto:zhbluweb@hotmail.com]
<br>
<b>Sent:</b> 18 July 2011 16:56<br>
<b>To:</b> Richards, Shola (Ext); dev@ensembl.org<br>
<b>Subject:</b> RE: [ensembl-dev] MySQL 5.5</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<div>
<p class="ecxMsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">I have been using MySQL 5.5 for a couple of Ensembl releases. I did not see any problem so far.<br>
<br>
Cheers,<br>
<br>
Zhibin Lu</span></p>
<div>
<div class="ecxMsoNormal" style="text-align:center" align="center"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">
<hr id="ecxstopSpelling" align="center" size="2" width="100%">
</span></div>
<p class="ecxMsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">From: shola.richards@novartis.com<br>
To: dev@ensembl.org<br>
Date: Mon, 18 Jul 2011 14:40:43 +0000<br>
Subject: [ensembl-dev] MySQL 5.5</span></p>
<div>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Arial','sans-serif'" lang="EN-GB">Hi,</span><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'"></span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Arial','sans-serif'" lang="EN-GB"> </span><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'"></span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Arial','sans-serif'" lang="EN-GB">Does anyone happen to know if the
</span><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">current release of Ensembl works with MySQL 5.5?</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">Many thanks,</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'">Shola</span></p>
</div>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:'Tahoma','sans-serif'"><br>
_______________________________________________ Dev mailing list Dev@ensembl.org List admin (including subscribe/unsubscribe): http://lists.ensembl.org/mailman/listinfo/dev Ensembl Blog: http://www.ensembl.info/</span></p>
</div>
</div>
</div></div>                                          </div></body>
</html>