Windows 平台上的 InnoDB

快来打我* 2022-08-12 00:18 91阅读 0赞

出错详解：  
  
E:/LAMP/mysql/bin>mysqld-max-nt --standalone --console  
InnoDB: Error: you must set the log group home dir in my.cnf the  
InnoDB: same as log arch dir.  
020410 23:52:53 Can't init databases  
解释：两个目录必须相同！  
  
  
E:/LAMP/mysql/bin>mysqld-max-nt --standalone --console  
InnoDB: Operating system error number 3 in a file operation.  
InnoDB: See http://www.innodb.com/ibman.html for installation help.  
InnoDB: The error means the system cannot find the path specified.  
InnoDB: In installation you must create directories yourself, InnoDB  
InnoDB: does not create them.  
InnoDB: File name d:/data/mysqldbf/ibdata/ibdata1  
InnoDB: Cannot continue operation.  
解释：目录没有建立，必须手工用 mkdir 先！  
  
  
  
E:/LAMP/mysql/bin>mysqld-max-nt --standalone --console  
InnoDB: The first specified data file d:/data/mysqldbf/ibdata/ibdata1 did not ex  
ist:  
InnoDB: a new database to be created!  
020410 23:54:44 InnoDB: Setting file d:/data/mysqldbf/ibdata/ibdata1 size to 30  
0 MB  
InnoDB: Database physically writes the file full: wait...  
020410 23:55:11 InnoDB: Log file c:/iblogs/ib\_logfile0 did not exist: new to be  
created  
InnoDB: Setting log file c:/iblogs/ib\_logfile0 size to 30 MB  
InnoDB: Database physically writes the file full: wait...  
020410 23:55:14 InnoDB: Log file c:/iblogs/ib\_logfile1 did not exist: new to be  
created  
InnoDB: Setting log file c:/iblogs/ib\_logfile1 size to 30 MB  
InnoDB: Database physically writes the file full: wait...  
020410 23:55:17 InnoDB: Log file c:/iblogs/ib\_logfile2 did not exist: new to be  
created  
InnoDB: Setting log file c:/iblogs/ib\_logfile2 size to 30 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  
020410 23:55:27 InnoDB: Started  
020410 23:55:28 mysqld-max-nt: Table 'mysql.func' doesn't exist  
020410 23:55:28 Can't open mysql/func table  
mysqld-max-nt: ready for connections  
  
解释：成功了！  
  
把原先的 MyISAM 表全部转换成了 InnoDB ：  
1.mysqldump --opt dbname>dbname.sql  
2.mysqladmin drop dbname  
3.mysqladmin create dbname  
4.修改 dbname.sql ，首行加  
set autocommit=0;  
末行加  
commit;  
并把所有的 type=myisam 修改为 type=innodb 。  
5.mysql dbname < dbname.sql  
6.重新建立相关的索引，以提高性能。