Problems Creating The InnoDB Table Space

• Before starting MySQL, verify the directories for InnoDB data files and log files exist and that the MySQL server has access rights to those directories.
  • InnoDB does not create directories, only files.
  • Check also there is enough disk space for the data and log files.

• If InnoDB prints an operating system error during a file operation, usually the problem has one of the following causes:
  • The InnoDB data file directory or the InnoDB log directory was not created.
  • mysqld does not have access rights to create files in those directories.
  • mysqld cannot read the proper my.cnf file.
  • The disk is full or a disk quota is exceeded.
  • A subdirectory was created whose name is equal to a data file that was specified, so the name cannot be used as a filename.
  • There is a syntax error in the innodb_data_home_dir or innodb_data_file_path value.

• If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB.
  • This means all ibdata files and all ib_logfile files.
  • Delete the corresponding .frm files for InnoDB tables from the MySQL database directories as well.
  • Then try the InnoDB database creation again.

How do I create an InnoDB table?

---

---

© 2007 John Michael Pierobon

Notes