0

While trying to create table Users with command

CREATE TABLE Users(
name varchar(200) NOT NULL,
username varchar(200) NOT NULL UNIQUE,
password varchar(200) NOT NULL);

I get error

ERROR 1005 (HY000): Can't create table test.Users (errno: 184 "Tablespace already exists")

I'm working with MariaDB, and I don't know how to remove tablespace as MariaDB doesn't support DROP TABLESPACE future. So my question is, how to remove the tablespace?

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828
Sevada 797
  • 346
  • 1
  • 8
  • Some reading https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp – RiggsFolly Mar 11 '23 at 13:28
  • 1
    Thanks removing /usr/var/lib/mysql/(database_name)/(table_name).ibd solved the problem. – Sevada 797 Mar 11 '23 at 13:37

0 Answers0