MySQL Forums
Forum List  »  General

Re: Problem with my.cnf file
Posted by: Scott Nemes
Date: June 28, 2013 01:45PM

You need to resolve the actual issue; switching the mode to 777 to start MySQL will not help anything as then it simply starts with default settings, which does not help you.

The log was initially complaining about your ib_logfile* size being different. So just do the following:

1. Stop MySQL
2. chmod /etc/my.cnf to 644
3. Move the ib_logfile* files from your data directory to another location for safe keeping.
4. Start MySQL as root or using sudo

That will force MySQL to re-create your ib_logfiles as the new size to fix the issue.

After you do all of that, please post up the error log again if it still does not start.

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Written By
Posted
June 28, 2013 07:30AM
Re: Problem with my.cnf file
June 28, 2013 01:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.