Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT

A little late here but generally I’ve seen this problem occur when you get a ‘tablespace full’ error when running in a ‘innodb_file_per_table’ mode. Without going into too much detail (more here), the database server’s tablespace is defined by the innodb_data_file_path setting and by default is rather small. Even made larger, the ‘tablespace full’ can … Read more