MySQL drop table named `data`
<p>So I have a MySQL database which contains a table named "data" which throws errors when attempting to import it into another MySQL database on a different server.</p>

<p>The data table is not important and I'd preferably like to delete it, but when using</p>

<pre><code>DROP TABLE `data`;
</code></pre>

<p>in the database, it says "Unknown table 'dbname.data'"</p>

<p>The table exists, when using SHOW TABLES, I get</p>

<pre><code>+------------------+
| Tables_in_dbname |
+------------------+
| data             |
| ...              |
+------------------+
</code></pre>

<p>(where ... represents the other table names)</p>

<p>Is there anyway to export all tables besides the data table, or is there anyway to drop the data table?</p>

<p>Thank you</p>