Build MySQL 5.1.45 configure options

Support for the other architectures (X86_64, IA-64, and PowerPC)
Post Reply
asawyer13
Posts: 5
Joined: 2010/04/06 00:48:28

Build MySQL 5.1.45 configure options

Post by asawyer13 » 2010/04/06 00:51:43

I have a brand new Centos 5.4 server that came with MySQL 5.0.77 installed.

I need to build a new MySQL for version 5.1.45.

I can download the 5.1.45 tar.gz file and get ready to compile it, but I don't know what ./configure options were used for the original install, so I don't know how to override the switches so it will overwrite all the old mysql 5.0.77 stuff.

Is there someway to know what options were used?

Alan

or is there a better way to get and compile a new version mysql??
I need to recompile to add Sphinx plugin.

Also if the suggestion is that I should go ahead and use 5.0.77 that's okay with me, but I still have to recompile 5.0.77, so even if I can get those ./configure options, that would work for me.

User avatar
toracat
Forum Moderator
Posts: 7383
Joined: 2006/09/03 16:37:24
Location: California, US
Contact:

Build MySQL 5.1.45 configure options

Post by toracat » 2010/04/06 01:25:38

Welcome to the CentOS forums. The following reading is recommended for new users:
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14274&forum=47]Readme First[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14408&forum=47]Installing Software[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14273&forum=47]Where to Find Answers[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=25128&forum=47]How to provide information about your system[/url]
The second link explains why installing from source is highly discouraged in a package-based distribution like CentOS. If you must run a newer version of mysql, there are some repositories that provide it. But please keep in mind you will not be officially supported if you do so. For details:

http://wiki.centos.org/AdditionalResources/Repositories

asawyer13
Posts: 5
Joined: 2010/04/06 00:48:28

Re: Build MySQL 5.1.45 configure options

Post by asawyer13 » 2010/04/06 01:30:48

I don't mind using MySQL 5.0.77 but I do have to recompile it in order to add the Sphinx Search Plugin


This is what they say to do:

7.2.1. Compiling MySQL 5.0.x with SphinxSE

Skips steps 1-3 if using already prepared delta tarball.

1.

copy sphinx.5.0.yy.diff patch file into MySQL sources directory and run

patch -p1 < sphinx.5.0.yy.diff

If there's no .diff file exactly for the specific version you need to build, try applying .diff with closest version numbers. It is important that the patch should apply with no rejects.
2. in MySQL sources directory, run

sh BUILD/autorun.sh

3. in MySQL sources directory, create sql/sphinx directory in and copy all files in mysqlse directory from Sphinx sources there. Example:

cp -R /root/builds/sphinx-0.9.9/mysqlse /root/builds/mysql-5.0.24/sql/sphinx

4. configure MySQL and enable Sphinx engine:

./configure --with-sphinx-storage-engine

5. build and install MySQL:

make
make install


They don't have a 5.0.77 patch, so I don't know how well this would work, that's the reason I was wanting the 5.1.45 version of MySQL because the instructions are easier to accomplish.

This is what they say to do to add Sphinx to MySQL 5.1.45.


7.2.2. Compiling MySQL 5.1.x with SphinxSE

Skip steps 1-2 if using already prepared delta tarball.

1. in MySQL sources directory, create storage/sphinx directory in and copy all files in mysqlse directory from Sphinx sources there. Example:

cp -R /root/builds/sphinx-0.9.7/mysqlse /root/builds/mysql-5.1.14/storage/sphinx

2. in MySQL sources directory, run

sh BUILD/autorun.sh

3. configure MySQL and enable Sphinx engine:

./configure --with-plugins=sphinx

4. build and install MySQL:

make
make install



It's much easier, but I really need to know what ./configure options were used so I don't screw everything up.

If you want to email them to me instead of posting here, that's fine. I am just trying to get this going.

My email is asawyer at asbo**inc dot com (please remove asterisks for real email address)

Thanks for any help you can give.

User avatar
AlanBartlett
Forum Moderator
Posts: 9323
Joined: 2007/10/22 11:30:09
Location: ~/Earth/UK/England/Suffolk
Contact:

Re: Build MySQL 5.1.45 configure options

Post by AlanBartlett » 2010/04/06 17:06:41

[quote]
I don't mind using MySQL 5.0.77 but I do have to recompile it in order to add the Sphinx Search Plugin
[/quote]
In view of the above, please have a read of the [url=http://wiki.centos.org/HowTos/SetupRpmBuildEnvironment]Setup An RPM Build Environment[/url] and [url=http://wiki.centos.org/HowTos/RebuildSRPM]Rebuild A SRPM[/url] articles from the [i]CentOS[/i] wiki.

Then download the relevant [i]MySQL 5.0.77[/i] [b].src.rpm[/b] package from your local [i]CentOS[/i] mirror site, install it into your build tree, apply the required patches / configure changes and build your own [b].rpm[/b] package.

All details of the configuration can be found in the [i].spec[/i] file within the [b].src.rpm[/b] package.

Post Reply

Return to “CentOS 5 - X86_64,s390(x) and PowerPC Support”