今天在Red Hat Linux 9上面安装了MYSQL,但是在service mysql start以后,查看service mysql status的时候出现以下提示:mysqld 已死,但是 subsys 被锁我起初还看了日志文件,日志文件提示:Cannot initialize InnoDB as "innodb_data_file_path" is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
060806 12:51:01 /usr/libexec/mysqld: Incorrect information in file: "./mysql/host.frm"
060806 12:51:01 mysqld ended我把原版的英文发给大家看看:1. Obviously the "ole check the log file for anything nastycat /var/log/mysqld.log2. Stop the serviceservice mysqld stop3. Check to see if the service stopped, it might be calling the wrong pid.ps aux | grep mysql4. Kill any mysql process that might still be running.kill -9 ??? ???5. (*CAREFUL*) Remove/move/backup any databases from the data directory, only do this step if you need to.rm -Rf /var/lib/mysql/*6. Check your global options configuration file, should be similar to stevanbt"s initial post.cat /etc/my.cnf7. Copy over one of the preconfigured "sample" server-specific options file. Global (/etc/my.cnf) file has priority over server-specific file, but these have more options in them and have been tuned for a certain role.cp /usr/share/doc/mysql-server-?.??.??/my-small.cnf /var/lib/mysql8. Recreate the initial databases, this step is optional as the initscripts will do this anyway.mysql_install_db9. Check and set the runlevels for the service.chkconfig --level 345 mysqld on
chkconfig --list mysqld10. Start the service.service mysqld start11. Check the log file (step 1)Thats just a basic step through check, most of you have probably already done this.其实做到step 9问题都已经解决了。 Linux系统下修改MySQL字符编码问题Linux系统中导出Oracle数据相关资讯 Red Hat Red Hat Linux 9 mysql技巧
- Red Hat公司8200万美元收购 (09/28/2014 10:04:28)
- Red Hat 引导 Anaconda 时常用的参 (03/09/2014 10:19:32)
- Red Hat 竞争优势受益于克隆产品 (08/17/2013 09:26:37)
| - Red Hat Enterprise Linux 5 64- (05/09/2014 06:17:31)
- Red Hat雇用CentOS开发者 (02/12/2014 13:38:50)
- Red Hat CEO:拥抱开源 拥抱克隆 (08/16/2013 19:22:58)
|
本文评论 查看全部评论 (0)