StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You answered your own question:</p> <blockquote> <p>The problem was: TYPE=InnoDB . As I understand it should be ENGINE=InnoDB . Sequel Pro on Mac (1.0.2) produces an sql dump with "TYPE" by default.</p> </blockquote> <p>Yes, this is deprecated syntax.</p> <p><a href="http://dev.mysql.com/doc/refman/5.1/en/create-table.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/create-table.html</a> says:</p> <blockquote> <p><strong>Note</strong><br> The older <code>TYPE</code> option was synonymous with <code>ENGINE</code>. <code>TYPE</code> has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed in MySQL 5.5. <em>You should not use <code>TYPE</code> in any new applications, and you should immediately begin conversion of existing applications to use <code>ENGINE</code> instead.</em> (See the Release Notes for MySQL 5.1.8.)</p> </blockquote> <p>So the keyword has been deprecated since 2006, and removed from the product since 2010!</p> <p>I found this bug already reported here: <a href="https://code.google.com/p/sequel-pro/issues/detail?id=1668" rel="nofollow">https://code.google.com/p/sequel-pro/issues/detail?id=1668</a></p> <p>The dev's reply is that Sequel Pro uses SHOW CREATE TABLE to export table definitions. If your SQL_MODE = "MYSQL323" or "MYSQL40", then SHOW CREATE TABLE will use the outdated TYPE option instead of the proper ENGINE option. So you can work around the issue by making sure your SQL_MODE is not configured for compatibility with an old version of MySQL.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload