[gentoo-user] Problems Upgrading to Slotted MYSQL

[gentoo-user] Problems Upgrading to Slotted MYSQL

[Sarpy Sam]

I presented this problem on the forums and have made no head way so I
present it here to see if I can find a solution.

I am going to ask a real stupid question here so bear with me.

I currently have mysql 5.0.18 installed and am trying to upgrade to
the slotted version 5.0.18-r30. I am following the upgrade guide found
at:

http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml

I am having trouble at step 3

Important: If you are upgrading between version revisions (ie.
dev-db/mysql-5.0.18 to dev-db/mysql-5.0.18-r30), you can simply stop
the database, move from one data directry to the other, and restart
the server. This allows you to skip this section entirely.


Can somebody please tell me how I "move from one data directry to the
other." I am not quite sure what that means or how to do it. Thanks.

Somebody on the forums asked if I copied the contents of
/var/lib/mysql to /var/lib/mysql-500.  I tried this but then mysql-500
failed to start like the procedure said.  The error I got in the log
was;

In the /var/log/mysql-500/mysqld.err

060205 13:01:32 [Warning] No argument was provided to --log-bin, and
--log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=host-bin' to avoid this problem.
/usr/sbin/mysqld-500: File './host-bin.index' not found (Errcode: 13)
060205 13:01:32 [ERROR] Aborting

060205 13:01:32 [Note] /usr/sbin/mysqld-500: Shutdown complete

So now where do I go and what do I do? I will add the host-bin.index
file is in the directory.

 Thanks for any help.

Kirby

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Problems Upgrading to Slotted MYSQL

[Martins Steinbergs]

[-- Attachment #1: Type: text/plain, Size: 2239 bytes --]

On Thursday 09 February 2006 01:14, Sarpy Sam wrote:
> I presented this problem on the forums and have made no head way so I
> present it here to see if I can find a solution.
>
> I am going to ask a real stupid question here so bear with me.
>
> I currently have mysql 5.0.18 installed and am trying to upgrade to
> the slotted version 5.0.18-r30. I am following the upgrade guide found
> at:
>
> http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml
>
> I am having trouble at step 3
>
> Important: If you are upgrading between version revisions (ie.
> dev-db/mysql-5.0.18 to dev-db/mysql-5.0.18-r30), you can simply stop
> the database, move from one data directry to the other, and restart
> the server. This allows you to skip this section entirely.
>
>
> Can somebody please tell me how I "move from one data directry to the
> other." I am not quite sure what that means or how to do it. Thanks.
>
> Somebody on the forums asked if I copied the contents of
> /var/lib/mysql to /var/lib/mysql-500.  I tried this but then mysql-500
> failed to start like the procedure said.  The error I got in the log
> was;
>
> In the /var/log/mysql-500/mysqld.err
>
> 060205 13:01:32 [Warning] No argument was provided to --log-bin, and
> --log-bin-index was not used; so replication may break when this MySQL
> server acts as a master and has his hostname changed!! Please use
> '--log-bin=host-bin' to avoid this problem.
> /usr/sbin/mysqld-500: File './host-bin.index' not found (Errcode: 13)
> 060205 13:01:32 [ERROR] Aborting
>
> 060205 13:01:32 [Note] /usr/sbin/mysqld-500: Shutdown complete
>
> So now where do I go and what do I do? I will add the host-bin.index
> file is in the directory.
>
>  Thanks for any help.
>
> Kirby

you need to rename /etc/mysql to something like /etc/mysql-999 or delete if 
you are going to unmerge 5.0.18
then use eselect mysql  to set your desired version
check my.cnf is it to your likings and /etc/conf.d/mysql points to correct 
version at mycnf=
start server

few weeks ago here was email about sloted mysql explaining all

m
-- 
Linux 2.6.15-ck3 AMD Athlon(tm) 64 Processor 3200+
 02:05:50 up  2:21,  4 users,  load average: 2.46, 2.27, 2.14

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-user] Problems Upgrading to Slotted MYSQL

[Sarpy Sam]

> you need to rename /etc/mysql to something like /etc/mysql-999 or delete if
> you are going to unmerge 5.0.18
> then use eselect mysql  to set your desired version
> check my.cnf is it to your likings and /etc/conf.d/mysql points to correct
> version at mycnf=
> start server
>
> few weeks ago here was email about sloted mysql explaining all
>
> m

Maybe I didn't make myself clear.  I am following the guide given by
Gentoo.  I am having trouble and am looking for help.  At the point in
the guide where it states.

Important: If you are upgrading between version revisions (ie.
dev-db/mysql-5.0.18 to dev-db/mysql-5.0.18-r30), you can simply stop
the database, move from one data directry to the other, and restart
the server. This allows you to skip this section entirely.

I am not sure what to do, the guide does not state how to do this, and
am looking for help.  I cannot move on to the point of deleting
databases or unmerging things or setting eselect mysql until I get
past the point I am having trouble.

Hopefully I made myself clear enough now.

Kirby

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Problems Upgrading to Slotted MYSQL

[Josh Pryor]

Kirby:

I ran into the same problem upgrading 5.0.18 > 5.0.18-r30.  Copying 
the /var/lib/mysql directory to /var/lib/mysql-500 is correct, but you also 
need to change the owner/group of the new directory:

chown mysql:mysql -R /var/lib/mysql-500

Then after completing the rest of the guide you should be ready to go.  hth,

On Wednesday 08 February 2006 7:23 pm, Sarpy Sam wrote:
> > you need to rename /etc/mysql to something like /etc/mysql-999 or delete
> > if you are going to unmerge 5.0.18
> > then use eselect mysql  to set your desired version
> > check my.cnf is it to your likings and /etc/conf.d/mysql points to
> > correct version at mycnf=
> > start server
> >
> > few weeks ago here was email about sloted mysql explaining all
> >
> > m
>
> Maybe I didn't make myself clear.  I am following the guide given by
> Gentoo.  I am having trouble and am looking for help.  At the point in
> the guide where it states.
>
> Important: If you are upgrading between version revisions (ie.
> dev-db/mysql-5.0.18 to dev-db/mysql-5.0.18-r30), you can simply stop
> the database, move from one data directry to the other, and restart
> the server. This allows you to skip this section entirely.
>
> I am not sure what to do, the guide does not state how to do this, and
> am looking for help.  I cannot move on to the point of deleting
> databases or unmerging things or setting eselect mysql until I get
> past the point I am having trouble.
>
> Hopefully I made myself clear enough now.
>
> Kirby

-- 
Josh Pryor
jpryor_99@yahoo.com
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Problems Upgrading to Slotted MYSQL

[Sarpy Sam]

On 2/8/06, Josh Pryor <jpryor_99@yahoo.com> wrote:
> Kirby:
>
> I ran into the same problem upgrading 5.0.18 > 5.0.18-r30.  Copying
> the /var/lib/mysql directory to /var/lib/mysql-500 is correct, but you also
> need to change the owner/group of the new directory:
>
> chown mysql:mysql -R /var/lib/mysql-500
>
> Then after completing the rest of the guide you should be ready to go.  hth,
>

Is that where I messed up?  I never thought about the permissions.  I
will give it a try this weekend when my server load is low.  Thanks.

Kirby

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Problems Upgrading to Slotted MYSQL

[Francesco Riosa]

Sarpy Sam wrote:
> On 2/8/06, Josh Pryor <jpryor_99@yahoo.com> wrote:
>   
>> Kirby:
>>
>> I ran into the same problem upgrading 5.0.18 > 5.0.18-r30.  Copying
>> the /var/lib/mysql directory to /var/lib/mysql-500 is correct, but you also
>> need to change the owner/group of the new directory:
>>
>> chown mysql:mysql -R /var/lib/mysql-500
>>
>> Then after completing the rest of the guide you should be ready to go.  hth,
>>
>>     
>
> Is that where I messed up?  I never thought about the permissions.  I
> will give it a try this weekend when my server load is low.  Thanks.
>
> Kirby
>
>   

if /var/lib/mysql-500 has been installed with group and user different
from mysql, please fill a bug report.

-- 
gentoo-user@gentoo.org mailing list