<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br></div><div>Heya Ensembl !</div><div><br></div><div>I'm using the ensembl-variation database schema on mysql 5.5 - it works well, but the SQL to create the meta_coord table is incompatible with mysql 5.5 : </div><div><br></div><div><font class="Apple-style-span" face="Monaco">File: ensembl_66/ensembl-variation/sql/table.sql</font></div><div>L<span class="Apple-style-span" style="font-family: Courier; ">ine 1134 ff: </span></div><div><br></div><div><div><font class="Apple-style-span" face="Courier">CREATE TABLE meta_coord (</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier"> table_name VARCHAR(40) NOT NULL,</font></div><div><font class="Apple-style-span" face="Courier"> coord_system_id INT(10) UNSIGNED NOT NULL,</font></div><div><font class="Apple-style-span" face="Courier"> max_length INT,</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier"> UNIQUE(table_name, coord_system_id)</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">) TYPE=MyISAM;</font></div><div><br></div></div><div><br></div><div><br></div><div><br></div><div>"TYPE=MyISAM' is not supported in mysql 5.5 anymore see : </div><div><br></div><div><font class="Apple-style-span" face="Courier"><a href="http://dev.mysql.com/doc/refman/5.5/en/create-table.html">http://dev.mysql.com/doc/refman/5.5/en/create-table.html</a></font></div><div><font class="Apple-style-span" face="Courier">….</font></div><div><p><font class="Apple-style-span" face="Courier"><a href="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html" title="5.1.6. Server SQL Modes">Section 5.1.6, “Server SQL Modes”</a>.
</font></p>
<div xmlns="http://www.w3.org/1999/xhtml" class="note" style="margin-left: 0.5in; margin-right: 0.5in;"><div class="admon-title"><font class="Apple-style-span" face="Courier">Note</font></div><p xmlns=""><font class="Apple-style-span" face="Courier">
The older <code class="literal">TYPE</code> option was synonymous with
<code class="literal">ENGINE</code>. <code class="literal">TYPE</code> was
deprecated in MySQL 4.0 and removed in MySQL 5.5. <span class="emphasis"><em>When
upgrading to MySQL 5.5 or later, you must convert existing
applications that rely on <code class="literal">TYPE</code> to use
<code class="literal">ENGINE</code> instead</em></span>.</font></p><p xmlns=""><br></p><p xmlns="">Please find the patch file attached - and keep the good work up ! :-) ! </p><div><br></div><p xmlns="">Cheers, </p><p xmlns=""> Jan Vogel</p><p xmlns=""><br></p><p xmlns=""></p></div></div></body></html>