First check and remove any disable options for innodb in /etc/my.cnf and restart mysql:
Eg: skip-innodb
If that doesn't work, try
#/etc/init.d/mysql stop
#mv /var/lib/mysql/ib_logfile0 /home/ib_logfile0.bak
#mv /var/lib/mysql/ib_logfile1 /home/ib_logfile1.bak
#/etc/init.d/mysql start
InnoDB is enabled by default. But, MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them and restart MySQL, they are recreated and will allow InnoDB to start again.
Eg: skip-innodb
If that doesn't work, try
#/etc/init.d/mysql stop
#mv /var/lib/mysql/ib_logfile0 /home/ib_logfile0.bak
#mv /var/lib/mysql/ib_logfile1 /home/ib_logfile1.bak
#/etc/init.d/mysql start
InnoDB is enabled by default. But, MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them and restart MySQL, they are recreated and will allow InnoDB to start again.
Modified the post: MySQL innodb log files can be moved to /home or any other folder except /var/lib/mysql
No comments:
Post a Comment