KNOWLEDGE BASE

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


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

Issue

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

Environment

  • Tableau Desktop
  • MySQL

Resolution

Work with your MySQL database administrator to address this issue.

Cause

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?