[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

installing mysqld with innodb and sphinx

Asked by XK8ER in Unix Operating Systems, Unix Setup, MySQL Server

hello there.
I am trying to setup mysqld with innodb and sphinx but for some reason it works on one server
and in the other two server it just doesn't work.. all 3 are running on centos v5.3
I uploaded the conf file with the mysql start script and wrote here line by line all the procedures
that I did.. when I try to start the mysql I get this..

Starting MySQL. Manager of pid-file quit without updating file.[FAILED]

would really appreciate it if someone can help me out! 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:

mkdir downloaded_src; cd downloaded_src
wget http://www.sfr-fresh.com/unix/misc/mysql-5.1.39.tar.gz
wget http://www.innodb.com/download/innodb_plugin/innodb_plugin-1.0.4.tar.gz
wget http://www.sphinxsearch.com/downloads/sphinx-0.9.8.1.tar.gz
untar mysql-5.1.39.tar.gz; untar sphinx-0.9.8.1.tar.gz; untar innodb_plugin-1.0.4.tar.gz; cd mysql-5.1.39; del storage/innobase/
mv ../innodb_plugin-1.0.4 storage/innobase; mv ../sphinx-0.9.8.1/mysqlse storage/sphinx
rpm -q libtool	if its not installed then 	yum install libtool
sh BUILD/autorun.sh
./configure --help
 
./configure --prefix=/opt/mysql-5.1.39 --with-mysqlmanager --with-mysqld-user=mysql --enable-assembler --enable-local-infile --with-charset=utf8 --with-extra-charsets=all --with-fast-mutexes --with-plugins=partition,archive,csv,federated,heap,innobase,myisam,sphinx,myisammrg
 
make
make install
cd /opt/mysql-5.1.39/; mkdir etc
	copy the file -> /opt/mysql-5.1.39/etc/mysql.server
	copy the file -> /opt/mysql-5.1.39/etc/my.cnf
cp -r /root/downloaded_src/mysql-5.1.39/scripts/ /opt/mysql-5.1.39/; cp -r /root/downloaded_src/mysql-5.1.39/support-files/ /opt/mysql-5.1.39/
./scripts/mysql_install_db --basedir=/opt/mysql-5.1.39/ --datadir=/opt/mysql-5.1.39/data/
chmod +x etc/mysql.server; chown -R mysql:mysql /opt/mysql-5.1.39
/opt/mysql-5.1.39/etc/mysql.server start
ps aux | grep mysql
Attachments:
 
my.cnf.txt (1 KB) (File Type Details) 
mysql conf
 
 
mysql.server.txt (12 KB) (Possible File Type Mismatch) 
mysql start script
 
[+][-]10/28/09 12:19 PM, ID: 25687132Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/28/09 12:37 PM, ID: 25687331Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/28/09 04:27 PM, ID: 25689307Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/28/09 10:19 PM, ID: 25690839Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/29/09 04:25 AM, ID: 25692419Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/30/09 06:32 AM, ID: 25702744Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/30/09 02:20 PM, ID: 25706893Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/31/09 03:47 AM, ID: 25709164Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 06:27 PM, ID: 25735890Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_EXPERT_20070906