2007/8/5, Leo Eraly :

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

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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Ciro Iriarte wrote:

2007/8/5, Ciro Iriarte :

...

2007/8/5, Leo Eraly :

...

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 - mmarek@suse.cz - fixed build for older distributions in the buildservice This has nothing to do with SP4. Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

2007/8/7, Michal Marek :

...

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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

2007/8/9, Michal Marek :

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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

2007/8/10, Michal Marek :

Ciro Iriarte wrote:

...

2007/8/9, Michal Marek :

...

...

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,

Ciro Iriarte wrote: 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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Ciro Iriarte wrote:

Succesfully installed the 5.1 packages from http://download.opensuse.org/repositories/server:/database:/mysql51/SLES_9/x... and i'm currently restoring from a DB dump. Would be great just to start with the binary files though...

Hi, any news? I'm quite interested in experience with the 5.1 rpms, as that will sooner or later become part of the distribution. thanks, Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org