Description:
On client site doing 4.1 to 5.0 migration. Trying 6.0 with a few free cycles for comparisons on loading data times, data sizing and query execution time.
Repeating the steps of installation with MySQL Version 5 on MySQL Version 6 had the startup of MySQL fail.
In absence of a general 6.0 Documentation Page it's important that differences are documented.
Startup failure makes reference to http://dev.mysql.com/doc/mysql/en/mysqld_safe.html
This page indicates that what I'm doing in 5 is correct, however it doesn't work in 6.
How to repeat:
# Installation of 5.0 is performed with the following commands
su -
cd /opt/mysql
tar xvfz mysql-enterprise-gpl-5.0.44sp1a-linux-x86_64-glibc23.tar.gz
ln -s mysql-enterprise-gpl-5.0.44sp1a-linux-x86_64-glibc23 mysql
chown -R mysql:mysql mysql-enterprise-gpl-5.0.44sp1a-linux-x86_64-glibc23
su - mysql
cd /opt/mysql/mysql
MYSQL_HOME=`pwd`;export MYSQL_HOME
PATH=$MYSQL_HOME/bin:$PATH; export PATH
scripts/mysql_install_db
bin/mysqld_safe &
MySQL Starts.
Later addition of /opt/mysql/mysql/my.cnf for additional instances
#MySQL 6 Installation
su -
cd /opt/mysql
tar xvfz mysql-6.0.3-alpha-linux-x86_64-glibc23.tar.gz
ln -s mysql-6.0.3-alpha-linux-x86_64-glibc23 mysql6
chown -R mysql:mysql mysql-6.0.3-alpha-linux-x86_64-glibc23
su - mysql
cd /opt/mysql/mysql6
MYSQL_HOME=`pwd`;export MYSQL_HOME
PATH=$MYSQL_HOME/bin:$PATH; export PATH
echo "[mysqld]
basedir=/opt/mysql/mysql6
datadir=/opt/mysql/mysql6/data
log-error=/var/log/mysql/mysql6.error.log
port=3366
socket=/tmp/mysql.sock.3366
[mysqld_safe]
port=3366
socket=/tmp/mysql.sock.3366
[mysql]
port=3366
socket=/tmp/mysql.sock.3366
[client]
port=3366
socket=/tmp/mysql.sock.3366
" > /opt/mysql/mysql6/my.cnf
scripts/mysql_install_db
bin/mysqld_safe &
bin/mysqld_safe &
071107 10:05:14 mysqld_safe Logging to '/var/log/mysql/mysql6.error.log'.
071107 10:05:14 mysqld_safe The file /usr/local/mysql/bin/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more information
Suggested fix:
Make mysqld_safe in 6 work like in 5.