sOlsTiCezA
Programmer
Hi
MySQL states that there is no limit on the number of tables that can be created, but the problem I have is that when I reach +- 7500 tables, I receive an error stating 'Cant create/write to file .\DbName\TableName.myi Error 13' ( 13 = Permission Denied ) If I drop 'n' tables, then I can create 'n' tables, but no more than that, which suggests a limit. I have tried changing tuning parameters, but this is to no avail. Has anyone else experienced this problem/ know a solution.
Thanks
MySQL states that there is no limit on the number of tables that can be created, but the problem I have is that when I reach +- 7500 tables, I receive an error stating 'Cant create/write to file .\DbName\TableName.myi Error 13' ( 13 = Permission Denied ) If I drop 'n' tables, then I can create 'n' tables, but no more than that, which suggests a limit. I have tried changing tuning parameters, but this is to no avail. Has anyone else experienced this problem/ know a solution.
Thanks