The troubleshooting steps for
problems depend on when the problem occurs: during startup of
the MySQL server, or during normal operations when a DML or DDL
statement fails due to problems at the file system level.
If something goes wrong when
to initialize its tablespace or its log files, delete all files
ibdata files and all
ib_logfile files. If you already created
InnoDB tables, also delete the
.frm files for these tables,
.ibd files if you are using
multiple tablespaces, from the MySQL database directories. Then
InnoDB database creation again. For
easiest troubleshooting, start the MySQL server from a command
prompt so that you see what is happening.
InnoDB prints an operating system error
during a file operation, usually the problem has one of the
Make sure the
InnoDB data file directory
InnoDB log directory exist.
Make sure mysqld has access rights to create files in those directories.
Make sure mysqld can read the proper
option file, so that it starts with the options that you
Make sure the disk is not full and you are not exceeding any disk quota.
Make sure that the names you specify for subdirectories and data files do not clash.
Doublecheck the syntax of the
values. In particular, any
MAX value in
option is a hard limit, and exceeding that limit causes a