Re: [opensuse] SLES9 and MySQL5
2007/8/9, Michal Marek [EMAIL PROTECTED]: Ciro Iriarte wrote: Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah). If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as well btw, or adding the repo to yast (if you want to update all packages). For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)? I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is soon after the official release ;) I'll report back the result of my tests. Cool. Looking forward for your results :) Michal Hi, reporting back :D Unlukily i couldn't get enought disk space in my workstation to install a VM and copy over all the production datafiles to test a direct upgrade. Two weeks ago one of our replicated 4.1 servers crashed and couldn't recover the datafiles, so last night I wiped the DB filesystem and started from scratch. Succesfully installed the 5.1 packages from http://download.opensuse.org/repositories/server:/database:/mysql51/SLES_9/x86_64/ and i'm currently restoring from a DB dump. Would be great just to start with the binary files though... I'll report any issue. Regards, Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
2007/8/10, Michal Marek [EMAIL PROTECTED]: Ciro Iriarte wrote: 2007/8/9, Michal Marek [EMAIL PROTECTED]: Ciro Iriarte wrote: Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah). If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as That probably won't do it, the package are not the same. We currently have: mysql-4.1.10a-3.4 taken from suse 9.3 mysql-client-4.1.10a-3 taken from suse 9.3 mysql-shared-4.0.18-32.1 --- stock, needed by php and other packages. It'll be a mess to try to compile php with the new libs i guess mysql-devel-4.0.18-32.20 --- stock too MySQL5: libedit-devel-2.10.snap20070302-11.1.x86_64.rpm libedit0-2.10.snap20070302-11.1.x86_64.rpm --- huh? libmysqlclient-devel-5.0.45-2.1.x86_64.rpm libmysqlclient15-5.0.45-2.1.x86_64.rpm --- confused libmysqlclient_r15-5.0.45-2.1.x86_64.rpm --- confused mysql-5.0.45-2.1.x86_64.rpm --- goes in mysql-Max-5.0.45-2.1.x86_64.rpm -- not interested in mysql-bench-5.0.45-2.1.x86_64.rpm -- not interested in mysql-client-5.0.45-2.1.x86_64.rpm --- goes in mysql-debug-5.0.45-2.1.x86_64.rpm -- not interested in mysql-test-5.0.45-2.1.x86_64.rpm -- i don't think we need it mysql-tools-5.0.45-2.1.x86_64.rpm -- not sure pgpool-3.1.1-4.3.x86_64.rpm -- sounds out of place And what's the problem? 'rpm -Uvh mysql-5.0.*.rpm mysql-client-5.0.*.rpm libmysqlclient15-5.0.*.rpm' will give you a working mysql5 setup. And it'll keep the 4.x libs for apps linked against it (php). Michal Ok, i'll try it.. I'm curious about the difference between libmysqlclient15 and libmysqlclient_r15. Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: 2007/8/9, Michal Marek [EMAIL PROTECTED]: Ciro Iriarte wrote: Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah). If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as That probably won't do it, the package are not the same. We currently have: mysql-4.1.10a-3.4 taken from suse 9.3 mysql-client-4.1.10a-3 taken from suse 9.3 mysql-shared-4.0.18-32.1 --- stock, needed by php and other packages. It'll be a mess to try to compile php with the new libs i guess mysql-devel-4.0.18-32.20 --- stock too MySQL5: libedit-devel-2.10.snap20070302-11.1.x86_64.rpm libedit0-2.10.snap20070302-11.1.x86_64.rpm --- huh? libmysqlclient-devel-5.0.45-2.1.x86_64.rpm libmysqlclient15-5.0.45-2.1.x86_64.rpm --- confused libmysqlclient_r15-5.0.45-2.1.x86_64.rpm --- confused mysql-5.0.45-2.1.x86_64.rpm --- goes in mysql-Max-5.0.45-2.1.x86_64.rpm -- not interested in mysql-bench-5.0.45-2.1.x86_64.rpm -- not interested in mysql-client-5.0.45-2.1.x86_64.rpm --- goes in mysql-debug-5.0.45-2.1.x86_64.rpm -- not interested in mysql-test-5.0.45-2.1.x86_64.rpm -- i don't think we need it mysql-tools-5.0.45-2.1.x86_64.rpm -- not sure pgpool-3.1.1-4.3.x86_64.rpm -- sounds out of place And what's the problem? 'rpm -Uvh mysql-5.0.*.rpm mysql-client-5.0.*.rpm libmysqlclient15-5.0.*.rpm' will give you a working mysql5 setup. And it'll keep the 4.x libs for apps linked against it (php). Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
2007/8/7, Michal Marek [EMAIL PROTECTED]: Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade. I would be interested as well. But I'm affraid the buildservice packages for SLES9 don't have many users, given that two months ago they didn't exist. You'll probably be the first one! ;-) Michal Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah). For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)? I'll report back the result of my tests. Regards, Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah). If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as well btw, or adding the repo to yast (if you want to update all packages). For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)? I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is soon after the official release ;) I'll report back the result of my tests. Cool. Looking forward for your results :) Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
2007/8/9, Michal Marek [EMAIL PROTECTED]: Ciro Iriarte wrote: Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah). If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as That probably won't do it, the package are not the same. We currently have: mysql-4.1.10a-3.4 taken from suse 9.3 mysql-client-4.1.10a-3 taken from suse 9.3 mysql-shared-4.0.18-32.1 --- stock, needed by php and other packages. It'll be a mess to try to compile php with the new libs i guess mysql-devel-4.0.18-32.20 --- stock too MySQL5: libedit-devel-2.10.snap20070302-11.1.x86_64.rpm libedit0-2.10.snap20070302-11.1.x86_64.rpm --- huh? libmysqlclient-devel-5.0.45-2.1.x86_64.rpm libmysqlclient15-5.0.45-2.1.x86_64.rpm --- confused libmysqlclient_r15-5.0.45-2.1.x86_64.rpm --- confused mysql-5.0.45-2.1.x86_64.rpm --- goes in mysql-Max-5.0.45-2.1.x86_64.rpm -- not interested in mysql-bench-5.0.45-2.1.x86_64.rpm -- not interested in mysql-client-5.0.45-2.1.x86_64.rpm --- goes in mysql-debug-5.0.45-2.1.x86_64.rpm -- not interested in mysql-test-5.0.45-2.1.x86_64.rpm -- i don't think we need it mysql-tools-5.0.45-2.1.x86_64.rpm -- not sure pgpool-3.1.1-4.3.x86_64.rpm -- sounds out of place well btw, or adding the repo to yast (if you want to update all packages). For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)? I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is soon after the official release ;) I'll report back the result of my tests. Cool. Looking forward for your results :) Michal Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: 2007/8/5, Ciro Iriarte [EMAIL PROTECTED]: 2007/8/5, Leo Eraly [EMAIL PROTECTED]: On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) Also noticed that those packages appeared on July (in many years i've looked after SLES9, there weren't packages for mysql5), maybe they're going to be included on SP4? They appeared recently because the SLES9 builds were broken previously: * Fri Jun 01 2007 - [EMAIL PROTECTED] - fixed build for older distributions in the buildservice This has nothing to do with SP4. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: 2007/8/5, Leo Eraly [EMAIL PROTECTED]: On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) Best thing to do is to check: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html Leo -- Leo Eraly [EMAIL PROTECTED] Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade. I would be interested as well. But I'm affraid the buildservice packages for SLES9 don't have many users, given that two months ago they didn't exist. You'll probably be the first one! ;-) Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
2007/8/5, Ciro Iriarte [EMAIL PROTECTED]: 2007/8/5, Leo Eraly [EMAIL PROTECTED]: On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) Best thing to do is to check: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html Leo -- Leo Eraly [EMAIL PROTECTED] Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade. Ciro Also noticed that those packages appeared on July (in many years i've looked after SLES9, there weren't packages for mysql5), maybe they're going to be included on SP4? Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) Best thing to do is to check: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html Leo -- Leo Eraly [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
2007/8/5, Leo Eraly [EMAIL PROTECTED]: On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) Best thing to do is to check: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html Leo -- Leo Eraly [EMAIL PROTECTED] Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade. Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[opensuse] SLES9 and MySQL5
Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) Ciro -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
