Posted by Frances on 06/08/06 23:51

Virginner wrote:
> "Frances" <fdr58@yahoo.com> wrote in message
> news:44888ad9$0$15791$14726298@news.sunsite.dk...
> | a few days ago I installed XAMPP in my Windows 2000 machine, it
> | completely messed my existing MySQL installation.. I've had it installed
> | for over a year now (4.1) have never had any problems with it whatsoever
> | (I connect to it from Tomcat and from stand-alone Java classes), now
> | since I installed XAMPP I cannot connect to it at all, cannot start
> | service... I uninstalled XAMPP completely, and my MySQL server still
> | doesn't work.. so why does XAMPP not come with a warning that it can
> | mess up existing MySQL installations? can there be a version of it
> | without MySQL (and thus without the demos that pull info from db?) I
> | have spent two days now trying to fix this problem, and after trying to
> | get help here and elsewhere I still have not been able to fix this..
> |
> | this is error I get (from .err file) when try to start service now:
> |
> | InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760
> | bytes
> | InnoDB: than specified in the .cnf file 0 5242880 bytes!
> | 060607 22:47:57 [ERROR] Can't init databases
> | 060607 22:47:57 [ERROR] Aborting
> |
> | 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
> |
>
> I'm sorry you have had problems.
>
> It came about as you installed MySQL 5 straight over a copy of MySQL 4.1.

> It can be solved by editing your my.ini file.
>
> Check the entry innodb_log_file_size=xxxxx
>
> and change it to innodb_log_file_size=10M which is what it's expecting.

people keep telling me to change this var.. when I first looked at it
yesterday it was already set to 10MB, today at someone's suggestion
changed it to 20MB, none of it made any difference.. I think I will
uninstall 4.1 and install it again, don't think I have any choice at
this point, I think I have exhausted all options here now..

and really I think XAMPP should come with a warning that this could
happen if you already have MySQL installed, and I think there should be
a verion of it w/o MySQL, so as not to cause these problems.. will have
to opt for http://us2.php.net/get/php-5.1.4-Win32.zip/from/a/mirror if
want to do PHP any development on my machine, hopefully can it make it
work with IIS, is probably simpler than spending a whole week figuring
out how to config Apache.. oh man.. ok, Virginner, again, many thanks
for your help.. Frances

[Back to original message]