1 Reply Latest reply on Apr 12, 2018 10:50 PM by patrick.byrne.0

    Temp tables block database

    Guillermo  Morales

      I have 7 temp tables in my database:

       

      • #Tableau_0_sid_00001725_2_Connect              
      • #Tableau_0_sid_00001726_2_Connect            
      • #Tableau_0_sid_000FA701_1_Group               
      • #Tableau_0_sid_000FA702_1_Group               
      • #Tableau_0_sid_000FA704_1_Group               
      • #Tableau_0_sid_000FA705_1_Group               
      • #Tableau_0_sid_000FA707_1_Group

       

      When I try to mysqldump the database, shows this error:

       

      mysqldump -u root --opt --add-drop-table --routines --triggers --comments --complete-insert --create-options --databases databasename > databasename.sql;
      mysqldump: Got error: 1017: Can't find file: '#Tableau_0_sid_00001725_2_Connect' (errno: 2) when using LOCK TABLE
      

       

      If I try to drop those tables, shows an error too:

       

      mysql> DROP TABLE #Tableau_0_sid_00001725_2_Connect;
          -> ;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
      

       

      What could I do to fix this problem?

       

      Thanks.