DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) Error creating InnoDB

Info Catalog (mysql.info.gz) InnoDB init (mysql.info.gz) InnoDB init
 
 15.6.1 Dealing with `InnoDB' Initialization Problems
 ----------------------------------------------------
 
 If `InnoDB' prints an operating system error in a file operation,
 usually the problem is one of the following:
 
    * You did not create the `InnoDB' data file directory or the InnoDB
      log directory.
 
    * `mysqld' does not have access rights to create files in those
      directories.
 
    * `mysqld' does not read the proper `my.cnf' or `my.ini' option
      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 data file
      you specified.
 
    * There is a syntax error in `innodb_data_home_dir' or
      `innodb_data_file_path'.
 
 If something goes wrong when `InnoDB' attempts to initialize its
 tablespace or its log files, you should delete all files created by
 `InnoDB'. This means all `ibdata' files and all `ib_logfile's. In case
 you created some `InnoDB' tables, delete the corresponding `.frm' files
 for these tables (and any `.ibd' files if you are using multiple
 tablespaces) from the MySQL database directories as well. Then you can
 try the `InnoDB' database creation again.  It is best to start the
 MySQL server from a command prompt so that you see what is happening.
 
Info Catalog (mysql.info.gz) InnoDB init (mysql.info.gz) InnoDB init
automatically generated byinfo2html