Compiling recent mysql version in RHEL

tanveer · 09-03-2007, 10:26 PM

Hi all,
I have installed RHEL4 with mysql-4.1.17. Now I downloaded 5.0.27-standard and installed it the server along with the previous one.
I have followd the specifications written in the INSTALL-BINARY file after untarring the mysql.

Code:

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root  .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

Now, I stopped the previous mysql and when run new mysql after installing then it gives me this as below which means its running the new one

Code:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Now my question is how come its getting the databases from my previous mysql or is it normal and what about my.cnf file as the default one is located at /etc? SHould I have to overrite the default one with new one?

Thanks in advance.

bathory · 09-04-2007, 02:46 AM

Quote:

Now my question is how come its getting the databases from my previous mysql or is it normal

If you want to use your old databases, you can remove the /usr/local/mysql/data directory and create a symlink to the previous mysql database directory:

Code:

ln -s /path/to/mysql4/data /usr/local/mysql

Of course doing so mysql5 users/credentials are those created for mysql4.

Quote:

what about my.cnf file as the default one is located at /etc? SHould I have to overrite the default one with new one?

By default mysqld will use /etc/my.cnf. If you want to use a different one, you can start mysqld using:

Code:

mysqld_safe --defaults-file=/etc/my.cnf-5.0.27 --user mysql &

tanveer · 09-04-2007, 08:10 AM

Thanks a lot. That was a great help for my understanding.