4 Aug
2007
4 Aug
'07
12:06
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: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
5 Aug
5 Aug
09:34
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 <leo(a)unstable.be>
--
To unsubscribe, e-mail: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
12:35
2007/8/5, Leo Eraly <leo(a)unstable.be>be>:
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte
wrote:
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(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
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 <leo(a)unstable.be>
6 Aug
6 Aug
14:08
2007/8/5, Ciro Iriarte <cyruspy(a)gmail.com>om>:
2007/8/5, Leo Eraly <leo(a)unstable.be>be>:
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: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte
wrote:
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
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 <leo(a)unstable.be> 
7 Aug
7 Aug
07:24
Ciro Iriarte wrote:
2007/8/5, Ciro Iriarte <cyruspy(a)gmail.com>om>:
They appeared recently because the SLES9 builds were broken previously:
* Fri Jun 01 2007 - mmarek(a)suse.cz
- fixed build for older distributions in the buildservice
This has nothing to do with SP4.
Michal
--
To unsubscribe, e-mail: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
2007/8/5, Leo Eraly <leo(a)unstable.be>be>:
> 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?
07:38
Ciro Iriarte wrote:
2007/8/5, Leo Eraly <leo(a)unstable.be>be>:
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: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte
wrote:
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. 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 <leo(a)unstable.be>
9 Aug
9 Aug
10:27
2007/8/7, Michal Marek <mmarek(a)suse.cz>cz>:
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(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
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
13:01
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: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
23:40
2007/8/9, Michal Marek <mmarek(a)suse.cz>cz>:
Ciro Iriarte wrote:
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
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).
Ciro
--
To unsubscribe, e-mail: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
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
10 Aug
10 Aug
07:35
Ciro Iriarte wrote:
2007/8/9, Michal Marek <mmarek(a)suse.cz>cz>:
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: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
Ciro Iriarte wrote:
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 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
08:34
2007/8/10, Michal Marek <mmarek(a)suse.cz>cz>:
Ciro Iriarte wrote:
Ok, i'll try it.. I'm curious about the difference between
libmysqlclient15 and libmysqlclient_r15.
Ciro
--
To unsubscribe, e-mail: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
2007/8/9, Michal Marek <mmarek(a)suse.cz>cz>:
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
Ciro Iriarte wrote:
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 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
26 Jan
26 Jan
13:50
2007/8/9, Michal Marek <mmarek(a)suse.cz>cz>:
Ciro Iriarte wrote:
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/…
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: opensuse+unsubscribe(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
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
31 Jan
31 Jan
11:33
Ciro Iriarte wrote:
Succesfully installed the 5.1 packages from
http://download.opensuse.org/repositories/server:/database:/mysql51/SLES_9/…
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(a)opensuse.org
For additional commands, e-mail: opensuse+help(a)opensuse.org
4985
days inactive
5165
days old
12 comments
3 participants
participants (3)
-
Ciro Iriarte -
Leo Eraly -
Michal Marek