Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

Upgrade led to mysql conflicts

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


gordon at haywired

May 6, 2008, 2:30 AM

Post #1 of 4 (220 views)
Permalink
Upgrade led to mysql conflicts

I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the
end of the process. DBMAIL (2.2.10) continues to work as expected. But
a subsequent "yum update" to catch all the post-FC8 updates threw up a
number of errors like this:

file /usr/bin/msql2mysql from install of
mysql-5.0.45-6.fc8.x86_64 conflicts with file from
package
mysql-5.0.27-1.fc6.i386

Apparently there are conflicts between the FC8 64-bit packages and the
FC6 32-bit packages.

How can I get past this?
I've asked on the Fedora list, but with no luck yet...

I'm reluctant to simply "yum remove" the old MYSQL then "yum install"
the new one, in case my DBMAIL database get lost in the process...

Are there MYSQL experts here who can advise?

Any help will be most welcome!


_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


aleksander at krediidiinfo

May 6, 2008, 2:43 AM

Post #2 of 4 (213 views)
Permalink
Re: Upgrade led to mysql conflicts [In reply to]

Gordon Hay wrote:
> I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the
> end of the process. DBMAIL (2.2.10) continues to work as expected. But
> a subsequent "yum update" to catch all the post-FC8 updates threw up a
> number of errors like this:
>
> file /usr/bin/msql2mysql from install of
> mysql-5.0.45-6.fc8.x86_64 conflicts with file from
> package
> mysql-5.0.27-1.fc6.i386
>
> Apparently there are conflicts between the FC8 64-bit packages and the
> FC6 32-bit packages.

> I'm reluctant to simply "yum remove" the old MYSQL then "yum install"
> the new one, in case my DBMAIL database get lost in the process...

It won't, rpm will only remove packages that belong to it, try:

rpm -q -filesbypkg mysql-version-release.arch

You should see that the database files don't belong to the package.

Although doing a backup is still a good idea before you start deleting
stuff.


If 'yum remove' wants to delete too many packages as dependencies, then
remove the offending packages by hand, that is with 'rpm -e -nodeps
packagename-version-release.arch'.

HTH,

--
Aleksander Kamenik
System Administrator
Krediidiinfo AS
an Experian Company
Phone: +372 665 9649
Email: aleksander[at]krediidiinfo.ee

http://www.krediidiinfo.ee/
http://www.experiangroup.com/
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


gordon at haywired

May 6, 2008, 3:28 AM

Post #3 of 4 (214 views)
Permalink
Upgrade led to mysql conflicts [In reply to]

On Tue, 6 May 2008, Gordon Hay wrote:

> > I upgraded my server from Fedora FC6 to FC8, and all seemed OK at
the
> > end of the process. DBMAIL (2.2.10) continues to work as expected.
But
> > a subsequent "yum update" to catch all the post-FC8 updates threw up
a
> > number of errors like this:
> >
> > file /usr/bin/msql2mysql from install of
> > mysql-5.0.45-6.fc8.x86_64 conflicts with file from
> > package
> > mysql-5.0.27-1.fc6.i386
> >
> > Apparently there are conflicts between the FC8 64-bit packages and
the
> > FC6 32-bit packages.
> >
> > How can I get past this?
> > I've asked on the Fedora list, but with no luck yet...
> >
> > I'm reluctant to simply "yum remove" the old MYSQL then "yum
install"
> > the new one, in case my DBMAIL database get lost in the process...
>
> So back it up first.
>
> > Are there MYSQL experts here who can advise?
>
> Mixing 32-bit and 64-bit packages is ill advised at best. Since you
just
> upgraded the distro and are using FC, I am assuming that this is not
a
> production system. If you are concerned about losing the DB, back it
up first,
> but traditionally, removing the mysql package doesn't result in
> /var/lib/mysql/* getting dropped.
>
> Actually, re-reading what you wrote - are you saying you just upgraded
the
> mysql package, not the whole distro? That's just asking for trouble.
> Considering you weren't running the 64-bit version before, is your
actual
> installed distro 64-bit? If it isn't, just slapping on a 64-bit
package won't
> work - you'll need 64-bit kernel, glibc, and probably a few hundred MB
of other
> 64-bit libraries before that'll have even a remote chance of working.
>
> Gordan
>

Sorry if I wasn't clear: I upgraded the whole FC6 system to FC8, and it
was 64-bit from the start, so I'm not trying to migrate from 32-bit
MYSQL to 64-bit MYSQL (Lots of 64-bit packages seem to require that
their 32-bit counterparts are also installed.)

My question still is: can MYSQL experts recommend the best way to remove
these conflicts with minimum risk to my DBMAIL system? I'm not
experienced with MYSQL, so the more detailed your instructions, the
better my chances of doing it right...

Again, thanks in advance for any help.



_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


dbmail at bobich

May 6, 2008, 3:35 AM

Post #4 of 4 (213 views)
Permalink
Re: Upgrade led to mysql conflicts [In reply to]

On Tue, 6 May 2008, Gordon Hay wrote:

> On Tue, 6 May 2008, Gordon Hay wrote:
>
>>> I upgraded my server from Fedora FC6 to FC8, and all seemed OK at
> the
>>> end of the process. DBMAIL (2.2.10) continues to work as expected.
> But
>>> a subsequent "yum update" to catch all the post-FC8 updates threw up
> a
>>> number of errors like this:
>>>
>>> file /usr/bin/msql2mysql from install of
>>> mysql-5.0.45-6.fc8.x86_64 conflicts with file from
>>> package
>>> mysql-5.0.27-1.fc6.i386
>>>
>>> Apparently there are conflicts between the FC8 64-bit packages and
> the
>>> FC6 32-bit packages.
>>>
>>> How can I get past this?
>>> I've asked on the Fedora list, but with no luck yet...
>>>
>>> I'm reluctant to simply "yum remove" the old MYSQL then "yum
> install"
>>> the new one, in case my DBMAIL database get lost in the process...
>>
>> So back it up first.
>>
>>> Are there MYSQL experts here who can advise?
>>
>> Mixing 32-bit and 64-bit packages is ill advised at best. Since you
> just
>> upgraded the distro and are using FC, I am assuming that this is not
> a
>> production system. If you are concerned about losing the DB, back it
> up first,
>> but traditionally, removing the mysql package doesn't result in
>> /var/lib/mysql/* getting dropped.
>>
>> Actually, re-reading what you wrote - are you saying you just upgraded
> the
>> mysql package, not the whole distro? That's just asking for trouble.
>> Considering you weren't running the 64-bit version before, is your
> actual
>> installed distro 64-bit? If it isn't, just slapping on a 64-bit
> package won't
>> work - you'll need 64-bit kernel, glibc, and probably a few hundred MB
> of other
>> 64-bit libraries before that'll have even a remote chance of working.
>>
>> Gordan
>>
>
> Sorry if I wasn't clear: I upgraded the whole FC6 system to FC8, and it
> was 64-bit from the start, so I'm not trying to migrate from 32-bit
> MYSQL to 64-bit MYSQL (Lots of 64-bit packages seem to require that
> their 32-bit counterparts are also installed.)

You must be looking at it wrong. I have several large RHEL5 installs with
_NO_ 32-bit packages or 32-bit dependencies. x86-64 only. No way will a
64-bit package have a 32-bit dependency.

> My question still is: can MYSQL experts recommend the best way to remove
> these conflicts with minimum risk to my DBMAIL system? I'm not
> experienced with MYSQL, so the more detailed your instructions, the
> better my chances of doing it right...

rpm -e mysql; yum install mysql.x86_64 ought to do it. If you don't trust
it, just mv the /var/lib/mysql directory to /var/lib/mysql.bak first then
move it back after the upgrade. You may also want to back up your
/etc/my.cnf file before the upgrade.

Gordan
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.