KNOWLEDGE BASE

Error "Lost connection to MySQL Server During Query" Creating an Extract


Published: 05 Mar 2014
Last Modified Date: 26 Apr 2016

Issue

When creating an extract of a MySQL data source, the following error might occur:

Lost connection to MySQL Server During Query.

Environment

  • Tableau Desktop
  • MySQL

Resolution

Work with your database and network administrators to ensure that the network and database settings allow for the extract to complete.

Cause

Possible reasons for receiving this error, as noted in the MySQL documentation:
  • A network issue.
  • The query has insufficient time to complete.
  • The query result exceeds the maximum packet setting.
Did this article resolve the issue?