0

Hi can somebody tell me how to delete a table space? Some days ago I deleted a table because I thought I didn't need it anymore.
When I tried to recreate it I got this error:
ERROR 1813(HY000): Tablespace for table 'test','employees' exists.PLEADE DISCARD the table space before import;

I searched on the web but the solutions offered seem so complicated is there an easy way to do it? Thank you

3
Contributors
4
Replies
29
Views
4 Years
Discussion Span
Last Post by Fiorentino01^
0

please try:

DROP TABLESPACE tablespace_name
    ENGINE [=] engine_name

engine_name can be (myisam & innodb). they are commonly used engines.

0

I tried but it does not work maybe I did it wrong like this?
DROP TABLESPACE learndb
ENGINE [innodb]

0

I think you are missing out values for engine_name, that depends on your MySQl version.

Try with NDB and NDBCLUSTER.

0

Hi I tried with NDB and NDBCLUSTER but gives error message 'unknown NDB engine or ndbcluster engine'.Since the db still exists I even tried to recreate the table and then delete the db, it deletes the table but not the db.I guess I'll give up and leave it there.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.