The MySQL service fails to run just after MySQL install : what's wrong ?
YoLed
to install the development environment on my own station (even if final
will be on remote one).
My station is a Windows 2000 Pro FR in a LAN. Actually, I've
successfully installed and tested Apache 2.0 and PHP 5 ; I've also Perl
5.8 but it's another subject.
From the point to install MySQL, I've downlowded "mysql-5.1.22-rc-
win32.zip" (84MB). Then, I've ran setup.exe : the installation has been
successfull. At the end, I've choosen to launch the Config Wizard on
which I've simply indicated a root password and to start MtSQL as a
service at Windows start-up.
To finish, I've restarted my PC... And the problem is that the MySQL
service is not running. I've started to run it manually, but it fails.
Here is what I can see in the .err file in the "e:/mysql/data" directory
(knwoing I've installed MySQL under "e:/mysql").
***********
InnoDB: Error: log file .\ib_logfile0 is of different size 0 5242880
bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
071220 13:00:00 [ERROR] Plugin 'InnoDB' init function returned error.
071220 13:00:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
071220 13:00:00 [ERROR] Unknown/unsupported table type: INNODB
071220 13:00:00 [ERROR] Aborting
071220 13:00:00 [Note] E:\mysql\bin\mysqld: Shutdown complete
***********
I don't know what's going wrong and what to do. I'm new in the MySQL
field and what I read here doesn't speak to me.
I've though to donwload the MySQL GUI Tools (mysql-gui-tools-5.0-r12-
win32.msi), but maybe it's better to solve this service problem first...
Could you help me to get a good and running MySQL Server ?
J.O. Aho
> To finish, I've restarted my PC... And the problem is that the MySQL
> service is not running. I've started to run it manually, but it fails.
> Here is what I can see in the .err file in the "e:/mysql/data" directory
> (knwoing I've installed MySQL under "e:/mysql").
>
> ***********
> InnoDB: Error: log file .\ib_logfile0 is of different size 0 5242880
> bytes
> InnoDB: than specified in the .cnf file 0 10485760 bytes!
The logfile on the hard drive is of a different size than what is specified in
your my.ini, a quick fix is to ensure that the mysqld is not running and then
just delete the ib_logfile0 and then start up mysql.
--
//Aho
YoLed
says...
> The logfile on the hard drive is of a different size than what is specified in
> your my.ini, a quick fix is to ensure that the mysqld is not running and then
> just delete the ib_logfile0 and then start up mysql.
>
Not really understood the reason why, but I'vs followed your tip and it
works. Thanks a lot J.O. Aho :)