7.5.4.1 If Something Goes Wrong in Database Creation

If InnoDB prints an operating system error in a file operation, usually the problem is one of the following:

• You did not create InnoDB data or log directories.
• `mysqld' does not have the rights to create files in those directories.
• `mysqld' does not read the right `my.cnf' or `my.ini' file, and consequently does not see the options you specified.
• The disk is full or a disk quota is exceeded.
• You have created a subdirectory whose name is equal to a datafile you specified.
• There is a syntax error in innodb_data_home_dir or innodb_data_file_path.

If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all datafiles, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding `.frm' files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again.

User Comments

Add your own comment.