Re: [gentoo-user] Problems with mysql 4.1 upgrade

[Kevin Philp]

I edited the my.cnf file and changed

innodb_log_file_size            = 5M

to

innodb_log_file_size            = 8M

and now it works again.

Kevin.


On 07/11/05, Kevin Philp <kevin.philp@×××××.com> wrote:
> I don't seem to have the log file you mention but this is in the
> mysqld.err file.
>
> /var/log/mysql/mysqld.err
> InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes
> InnoDB: than specified in the .cnf file 0 5242880 bytes!
> 051107  9:13:17 [ERROR] Can't init databases
> 051107  9:13:17 [ERROR] Aborting
>
> I did read that innodb was a use flag (its not in my make.conf) and
> emerge -pv mysql doesn't show it up.
>
> On 07/11/05, Catalin Trifu <catalin@××××××××××××.de> wrote:
> >      Hi,
> >
> >      What does the mysql log say ? /var/lib/mysql/host.err
> >
> >  Catalin
> >
> >
> >
> >  Kevin Philp wrote:
> >  Last week I upgraded to mysql 4.1.14. I carefully followed every line
> > of the upgrade guide inlcuding the revdep-rebuild and at the end I had
> > a lovely new mysql 4.1 and all my databases had imported with no
> > problems, phpmyadmin also worked fine. Now....about a week later I
> > can't start mysql:
> >
> > /etc/init.d/mysql start - says mysql has already started but it hasn't
> > (ps aux | grep -i my* shows nothing)
> >
> > mysql shows
> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > '/var/run/mysqld/mysqld.sock' (2)
> >
> > I have checked permissions on var/run/mysqld as recommended in another
> > post and they are correct. I am running out of ideas....anyone any
> > further ideas??
> >
> > Thanks
> >
> > Kevin.
> >
> >
> >
>

-- 
gentoo-user@g.o mailing list