2

When I'm trying to create a table I get this error:

Tablespace for table '`database`.`table`' exists. Please DISCARD the tablespace before IMPORT

I found many solutions to this but every single one requires SSH access to server or drop database privilege which I don't have.

Any ideas how to solve this problem?

sajushko
  • 418
  • 4
  • 13
  • I was saying to DROP DATABASE first but then I saw "no privilege". You really need to access server or at least need to be able to DROP this table. – smozgur Jan 30 '16 at 12:05
  • When I am trying to drop the table I get error Unknown table `table` – sajushko Jan 30 '16 at 12:10
  • what about DROP TABLESPACE? https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html – smozgur Jan 30 '16 at 12:13
  • DROP TABLESPACE `table` throw this error: 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 '' – sajushko Jan 30 '16 at 18:47

0 Answers0