Add skip-innodb TO my. ini (/etc/my. cnf in linux.
After I set it like this, there is no problem in linux. I started MYSQL in winXP on my local machine today, prompting that the MYSQL cannot be started. Check the error log of the mysql directory:
Reference
090613 10:15:27 [ERROR] Default storage engine (InnoDB) is not available
090613 10:15:27 [ERROR] Aborting
090613 10:15:27 [Note] C: \ www \ mysql \ bin \ mysqld-nt: Shutdown complete
It is estimated that after the parameter is added last time, it never starts up... Mysql of the local machine has not been used for a long time.
Check, my. in ini, the default-storage-engine = INNODB engine is set to INNODB, and skip-innodb is added to it.
Change default-storage-engine to MYISAM, and MYSQL starts OK!
You can delete the ibdata1, ib_logfile0, and ib_logfile1 files in the data directory under skip-innodb.
After the test, when skip-innodb is not added, the three files are deleted and the three files are automatically created at startup. The log is as follows:
Reference
InnoDB: The first specified data file. \ ibdata1 did not exist:
InnoDB: a new database to be created!
090613 10:19:37 InnoDB: Setting file. \ ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090613 10:19:37 InnoDB: Log file. \ ib_logfile0 did not exist: new to be created
InnoDB: Setting log file. \ ib_logfile0 size to 24 MB
InnoDB: Database physically writes the file full: wait...
090613 10:19:38 InnoDB: Log file. \ ib_logfile1 did not exist: new to be created
InnoDB: Setting log file. \ ib_logfile1 size to 24 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090613 10:19:39 InnoDB: Started; log sequence number 0 0
090613 10:19:39 [Note] C: \ www \ mysql \ bin \ mysqld-nt: ready for connections.
Delete these three files, add skip-innodb, and then start the log:
Reference
090613 10:30:12 [Note] C: \ www \ mysql \ bin \ mysqld-nt: Normal shutdown
090613 10:30:12 [Note] C: \ www \ mysql \ bin \ mysqld-nt: Shutdown complete
090613 10:30:17 [Note] C: \ www \ mysql \ bin \ mysqld-nt: ready for connections.
Version: '5. 0.45 'socket: ''' port: 3306 Source distribution
The three files will not be generated automatically.