Tablespace for table xxx exists

[mysqld]

innodb_data_file_path=ibdata1:10M:autoextend

be sure to add within mysqld
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 still occur with larger queries and such (lots of non-table ‘stuff’ is stored in there, undo logs, caches, etc…).


innodb_data_file_path

Leave a Comment

Your email address will not be published. Required fields are marked *

To Resolve this issue at just 5$ from ServerExpert

https://serverexpert.io/

For Hosting please visit Hostingwebsite.io

You have Successfully Subscribed!

Open chat