To resolve this error, please go into the following location:
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data
and delete “ib_logfile0″ and “ib_logfile1″.
Then go to Services and start your MySql. It will resolve the error and start you MySql.
Why: According to my search: Open the my.ini file and check the InnoDB variables’s size. When above file exides the mentioned size it will prompt this(“Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.”) error.
Regards,
Vijay Modi
About Vijay Modi
Having 12+ years of experience in web application development. Expertise in various domains like E-Commerce, E-Learning, Insurance. I have expertise in web application development, window application development, Performance improvement, bug fixing etc. I have worked on various Microsoft technologies including ASP.Net, MVC, WebApi, WCF, Entity Framework, WPF, Window Application Development, AWS, Azure, AngularJS 2.0 / 1.5.2, .NetCore framework, jQuery. I am believing in quality work and achieving deadlines. Also like to work on new technologies and quick learner.
This entry was posted in Uncategorized and tagged
My Sql. Bookmark the
permalink.
Hi Dude
jigarchaudhari.wordpress.com
good Jigar,
U r great.
Cheers.
You are AWESOME!! I have searched for over an hour on MySQL.com and other sites. I’ve edited the registry, uninstalled/reinstalled, change admin passwords, added a local admin account, all to no avail. Your simple solution worked perfectly!!!
Thanks!!!
Mark
Hi Vijay,
jigarchaudhari.wordpress.com
Is this our jigar chaudhari’s worpress blog from patan. 🙂
Gr8 work man.. your site is very good.
Hey Great solution man , it works!!!
THANK YOU VERY MICH SIR
oh how i hate this db 😦
[mysqld]
tmpdir=C:/temp
The C:\temp directory must exist and have sufficient space for the MySQL server to write to
THANKS SO MUCH! I was going nutz
Been having the exact same problem, except that deleting the two mentioned files doesn’t seem to do anything at all.
These people apparently are using Windows. When I try this on Linux, the problem persists. I have two different Linux versions (RHEL 5.5 and Centos 6.3) with exactly the same MySQL distribution [
MySQL-client-advanced-5.5.28-1.rhel4.x86_64.rpm
MySQL-devel-advanced-5.5.28-1.rhel4.x86_64.rpm
MySQL-server-advanced-5.5.28-1.rhel4.x86_64.rpm
]
The server comes up on RHEL but it does not on Centos. I have deleted the ib_logfile* files on both systems. This does not change the behavior.
thanks vijay, it works for me..i did so many things but i got the answer from u only…….thnk u very much
deleting those files doesn’t make a difference
It worked for me. Saved a lot of time, thanks.
Great, I did not know about that up to now. Thankz!
Thank you so much man !
I’ve had this error monday morning and thank to you I fixed it before any customer can notice our server was down.
Thank you so much!!!
Spot on..
You are right on this.
Thank you !!!
I had the same error and in my situation in addition to the mentioned log files I also had to delete ibdata1 file in the same directory.
And then I could restart the server.
If you don’t want to lose data, instead execute the MySQL command set global innodb_fast_shutdown=0; before you shut down the server. When you shut down, this should solve the problem without causing you to lose data. Then you can reconfigure and restart.
Great solution and explanation, work for me fine; upgrading form mysql 5.1.47 to 5.5.9
Thanks you very much
Thanks Rafael.
Great solution, it work!!!
Thank you very much.
That helped for MySQL 5.5 too.
Worked for me on 5.5! Huge props.
Thank you for this!
Thanks a lot
Saved me a lot of time. Great post! Thanks!
I wish I found your post six hours ago and I wouldn’t have had wasted half a day uninstalling and reinstalling MySQL trying to figure out what the problem was.
Thank you very much for this solution!
Thanks my friend. This really works. I was trying to reinstall mysql 5.5 on my windows 7 machine, and somehow it just can’t start.
What I did was go to
C:\ProgramData\MySQL\MySQL Server 5.5\data
to find those log files, and then delete as you stated.
Then I restarted, and it works.
I hope this message helps anyone with reinstalling mysql on windows 7.
Cheers
Steven Yip
You rock! Thanks for the tip – had this same problem with MySQL 5.5 on Windows 2008 R2
Thanks …. It works…
Great!
It resolved my issue.
Thank you, save me a starting headache !
Thanks A lot man
God bless you 🙂