Questions about MySQL 4.1.22 from Centos 4.9 on Centos 6.

General support questions
Post Reply
mysteron
Posts: 28
Joined: 2007/02/27 08:38:40

Questions about MySQL 4.1.22 from Centos 4.9 on Centos 6.

Post by mysteron » 2011/07/15 13:22:08

Hi.

I have an old server which is running Centos4 with MySQL 4.1.22 which comes with Centos4.9.

Now I'm building the mysql server daemon from the extracted source of mysql-4.1.22-2.el4_8.4.src.rpm.

My questions are about the patches that come with that source package. Some patches tries to patch other versions than 4.1.22.

Now, do I have to apply these patches also, or are they already applied to the mysql-4.1.22.tar.gz source package? If yes, how do I go about applying these "non-4.1.22" patches?

And no, I cannot update to to the mysql version that comes with Centos 6 as there is too much data that could be lost in the conversion :(


Thx,
/mysteron

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Questions about MySQL 4.1.22 from Centos 4.9 on Centos 6.

Post by gerald_clark » 2011/07/15 13:57:30

Dump the data on the old server, and load it into the new server.
Use the MySQL that comes with the new server.

User avatar
TrevorH
Site Admin
Posts: 33219
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Questions about MySQL 4.1.22 from Centos 4.9 on Centos 6.

Post by TrevorH » 2011/07/15 14:13:08

[quote]
And no, I cannot update to to the mysql version that comes with Centos 6 as there is too much data that could be lost in the conversion :(
[/quote]

What?! :-o

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

Re: Questions about MySQL 4.1.22 from Centos 4.9 on Centos 6.

Post by pschaff » 2011/07/16 20:29:51

[quote]
mysteron wrote:
...
And no, I cannot update to to the mysql version that comes with Centos 6 as there is too much data that could be lost in the conversion :(
[/quote]
That's why one does backups, dumps and restores, and tests the new server before retiring the old one.

I harbor serious doubts about converting an obsolete MySQL SRPM from CentOS-4 into a kludge on CentOS-6, but to answer your question, no the patches are not in the mysql-4.1.22.tar.gz. They are applied to the tarball during the build process. A source tree with the patches applied can be obtained with "rpm -bp mysql.spec".

Why not just follow [url=http://wiki.centos.org/HowTos/RebuildSRPM]How to Rebuild a Source RPM[/url] and do:[code]
rpmbuild --rebuild mysql-4.1.22-2.el4_8.4.src.rpm[/code]?

Realize that even if you succeed you will have an unsupported configuration and will have to backport any future security patches as 4.9 is near EOL and is the final 4.X release. I'd put a lot of effort into getting the data into the current MySQL before pursuing that path.

Post Reply