Error "Incorrect key file for table..." Connecting to MySQL

Published: 23 Oct 2013
Last Modified Date: 23 Jan 2014


When you try to connect to MySQL, the following error might occur:
An error occurred while communicating with data source
[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.15-enterprise-commercial-advanced-log]Incorrect key file for table '<table>'; try to repair it
Unable to create extract


  • Tableau Desktop
  • MySQL


Work with your MySQL database administrator to address this issue.


This error is a MySQL pass-through error typically caused by an issue with the MySQL database. Examples of problems with the database that could generate this error include:
  1. The /tmp/ folder in the database is not large enough.
  2. The table needs to be repaired.
Did this article resolve the issue?