高校网站建设规范,项目管理系统开发,做爰动态视频网站,返利网站建设今天在一台MYSQL服务器上发现#xff0c;明明用了engineinnodb创建的表#xff0c;结果创建出来却成了myisam的表。再看show variables like %innodb%;have_innodb 成了DISABLED。经过一番试验#xff0c;发现是我关闭数据库后#xff0c;直接删除ibdata1文件造成的。删除该…今天在一台MYSQL服务器上发现明明用了engineinnodb创建的表结果创建出来却成了myisam的表。再看show variables like %innodb%;have_innodb 成了DISABLED。经过一番试验发现是我关闭数据库后直接删除ibdata1文件造成的。删除该文件以后重启数据库日志文件中会有060330 17:22:07 mysqld startedInnoDB: The first specified data file ./ibdata1 did not exist:InnoDB: a new database to be created!060330 17:22:07 InnoDB: Setting file ./ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...InnoDB: Error: all log files must be created at the same time.InnoDB: All log files must be created also in database creation.InnoDB: If you want bigger or smaller log files, shut down theInnoDB: database and make sure there were no errors in shutdown.InnoDB: Then delete the existing log files. Edit the .cnf fileInnoDB: and start the database again.060330 17:22:07 [Note] /usr/sbin/mysqld: ready for connections.Version: 5.0.19-standard-log socket: /var/lib/mysql/mysql.sock port: 3306 MySQL Community Edition - Standard (GPL)060330 17:22:26 [Note] /usr/sbin/mysqld: Normal shutdown看来只删除ibdata1文件是不行的于是再度关闭数据库把ibdata1和ib_logfile1、ib_logfile0统统删除再启动have_innodb 就变成Yes了。mysq install :./configure --prefix/usr/local/mysql/ --without-debug --with-client-ldflags-all-static --with-mysqld-ldflags-all-static --enable-assembler --with-extra-charsetsgbk,gb2312,utf8 --without-innodb --without-isam --with-pthread --enable-thread-safe-client --with-innodbsource:http://gladness.itpub.net/post/6254/64504
