InnoDB Table SpaceInnoDB data files and log files exist and that the MySQL server has access rights to those directories.
InnoDB does not create directories, only files.
InnoDB prints an operating system error during a file operation, usually the problem has one of the following causes:
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.
innodb_data_home_dir or innodb_data_file_path value.
InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB.
ibdata files and all ib_logfile files.
.frm files for InnoDB tables from the MySQL database directories as well.
InnoDB database creation again.
How do I create an InnoDB table?
© 2007 John Michael Pierobon