Re: [gentoo-user] Problems Upgrading to Slotted MYSQL
On 2/8/06, Josh Pryor [EMAIL PROTECTED] 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
Sarpy Sam wrote: On 2/8/06, Josh Pryor [EMAIL PROTECTED] 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
[gentoo-user] Problems Upgrading to Slotted MYSQL
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
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 pgpsGbLAzLLen.pgp Description: PGP signature
Re: [gentoo-user] Problems Upgrading to Slotted MYSQL
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
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 [EMAIL PROTECTED] -- gentoo-user@gentoo.org mailing list