On Tue, 4 Feb 2003, Shomal Bafna wrote:
> The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
> Linux with Duron processor and 256MB Ram. Thera are 10 InnoDb type tables
> created and several MyISAM types too (approx 30 more.). On adding the 11
> table of InnoDb type the following error is displayed:
> ERROR 1005 at line 1: Can't create table './myDB/personalDetails.frm' (errno:
> Need help.
It seems to be no more space in the ibdata file, check the my.cnf
the definition for the ibdata must be set to "autoextend". A problem with
innodb tables is, all the databases and tables goes to the same
tablespace (innodb file), and always grow up, it is necessary make dumps,
of all the databases with innodb tables, creating new innodb files.