tag:blogger.com,1999:blog-18337119.post115309394161598026..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: MySQL Failed to open log file (InnoDB)Unknownnoreply@blogger.comBlogger12125tag:blogger.com,1999:blog-18337119.post-7212152591761470622011-01-08T21:53:53.097-05:002011-01-08T21:53:53.097-05:00Thanks so muchThanks so muchhackerteamtesthttps://www.blogger.com/profile/03166056734795959760noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-46566595605618567102010-07-15T15:48:20.326-04:002010-07-15T15:48:20.326-04:00I had a very similar problem, but I found that (so...I had a very similar problem, but I found that (some of) the mysqld-bin.###### files had changed ownership from mysql to root. chown'd them to mysql, and it came back to life!Unknownhttps://www.blogger.com/profile/11832138476896647955noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-39670015761053563262010-07-12T05:17:32.530-04:002010-07-12T05:17:32.530-04:00thank you so muchthank you so muchAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-79276955379526794122009-12-11T04:31:46.778-05:002009-12-11T04:31:46.778-05:00three years and all at same place...
clear index a...three years and all at same place...<br />clear index and start mysqld<br /><br />echo '' >/var/db/mysql/mysql-bin.index<br /><br />/usr/local/etc/rc.d/mysql-server startGrimnirhttps://www.blogger.com/profile/04640087431520978924noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-30532170773584067042009-08-25T11:27:26.021-04:002009-08-25T11:27:26.021-04:00hi, i have a similar problem.
I haven't delete...hi, i have a similar problem.<br />I haven't delete files. can you help me?<br /><br />090824 17:03:26 [Note] Plugin 'FEDERATED' is disabled.<br />090824 17:03:26 InnoDB: Started; log sequence number 0 46409<br /> wampmysqld: File '' not found (Errcode: 2)<br />090824 17:03:26 [ERROR] Failed to open log (file '', errno 2)<br />090824 17:03:26 [ERROR] Could not open log file<br />090824 17:03:26 [ERROR] Can't init tc log<br />090824 17:03:26 [ERROR] AbortingUnknownhttps://www.blogger.com/profile/13281462936895067271noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-87193168492011627122009-08-18T09:01:50.015-04:002009-08-18T09:01:50.015-04:00Helped me too at 2008-08-18. Thank you!Helped me too at 2008-08-18. Thank you!holgihttps://www.blogger.com/profile/16869503993171808139noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-47718438410214050582009-06-19T05:24:53.714-04:002009-06-19T05:24:53.714-04:00saved me a few hours.
Thanks.saved me a few hours.<br />Thanks.Vikash Buchahttps://www.blogger.com/profile/04030948601703283899noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-41463141309962221292008-08-30T03:10:00.000-04:002008-08-30T03:10:00.000-04:00Old post, but still valid!Thanks!Old post, but still valid!<BR/><BR/>Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-36567178653119569072007-06-28T06:52:00.000-04:002007-06-28T06:52:00.000-04:00Adding the "expire_logs_days" environment variable...Adding the "expire_logs_days" environment variable to my.cnf seems to have done the job for me! Thanks, this blog did put me on the right track for getting rid of +600 MB of log files.<BR/><BR/>DimitriAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-85406988973966721512007-03-02T02:59:00.000-05:002007-03-02T02:59:00.000-05:00delete the contents of the file /var/lib/mysql/my...delete the contents of the file /var/lib/mysql/mysql-bin-index.index (empty it) and start mysql /etc/init.d/mysql start<BR/>Mysql service will start without any problemAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1167858920908516292007-01-03T16:15:00.000-05:002007-01-03T16:15:00.000-05:00I checked /etc/init.d/mysqld and /usr/bin/mysql_sa...I checked /etc/init.d/mysqld and /usr/bin/mysql_safe for 2 hours but your entry did it in one minute.<BR/><BR/>Some one should write an automatic fix.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1153098016699730962006-07-16T21:00:00.000-04:002006-07-16T21:00:00.000-04:00Indeed, thanks for pointing that out.FrankIndeed, thanks for pointing that out.<BR/><BR/>FrankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.com