WDlinux官方论坛 - Powered by Discuz! Board

#!/bin/bash
IN_DIR="/www/wdlinux"
MYS_VER="5.5.43"
if [ ! -f mysql-${MYS_VER}.tar.gz ];then
wget -c http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-${MYS_VER}.tar.gz
fi
yum install -y cmake
tar zxvf mysql-${MYS_VER}.tar.gz
cd mysql-${MYS_VER}
cmake -DCMAKE_INSTALL_PREFIX=$IN_DIR/mysql-$MYS_VER -DSYSCONFDIR=$IN_DIR/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_SSL=no -DWITH_DEBUG=OFF -DWITH_EXTRA_CHARSETS=complex -DENABLED_PROFILING=ON -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1
[ $? != 0 ] && echo "configure err" && exit
make
[ $? != 0 ] && echo "make err" && exit
make install
[ $? != 0 ] && echo "make install err" && exit
service mysqld stop
if [ ! -d /www/wdlinux/mysql_bk ];then
mkdir -p /www/wdlinux/mysql_bk
cp -pR /www/wdlinux/mysql/var/* /www/wdlinux/mysql_bk
fi
rm -f /www/wdlinux/mysql
ln -sf $IN_DIR/mysql-$MYS_VER /www/wdlinux/mysql
sh scripts/mysql_install_db.sh --user=mysql --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/var
chown -R mysql.mysql /www/wdlinux/mysql/var
mv /www/wdlinux/mysql/var/mysql /www/wdlinux/mysql/var/mysqlo
cp -pR /www/wdlinux/mysql_bk/* /www/wdlinux/mysql/var/
cp support-files/mysql.server /www/wdlinux/init.d/mysqld
chmod 755 /www/wdlinux/init.d/mysqld
service mysqld restart
echo
if [ -d /www/wdlinux/mysql-5.1.63 ];then
ln -sf /www/wdlinux/mysql-5.1.63/lib/mysql/libmysqlclient.so.16* /usr/lib/
fi
sleep 2
sh /www/wdlinux/tools/mysql_wdcp_chg.sh
echo
echo "mysql update is OK"

复制代码

150427 13:36:23 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: ready for connections.
Version: '5.5.43' socket: '/tmp/mysql.sock' port: 3306 Source distribution
150427 13:42:53 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: Normal shutdown
150427 13:42:53 [Note] Event Scheduler: Purging the queue. 0 events
150427 13:42:53 InnoDB: Starting shutdown...
150427 13:42:53 InnoDB: Shutdown completed; log sequence number 1595675
150427 13:42:53 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: Shutdown complete
150427 13:42:53 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.43/data/iZ23c87g06kZ.pid ended
150427 13:42:54 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.43/data
150427 13:42:54 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
150427 13:42:54 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
150427 13:42:54 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld (mysqld 5.5.43) starting as process 28339 ...
150427 13:42:54 InnoDB: The InnoDB memory heap is disabled
150427 13:42:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150427 13:42:54 InnoDB: Compressed tables use zlib 1.2.3
150427 13:42:54 InnoDB: Initializing buffer pool, size = 128.0M
150427 13:42:54 InnoDB: Completed initialization of buffer pool
150427 13:42:54 InnoDB: highest supported file format is Barracuda.
150427 13:42:54 InnoDB: Waiting for the background threads to start
150427 13:42:55 InnoDB: 5.5.43 started; log sequence number 1595675
150427 13:42:55 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150427 13:42:55 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150427 13:42:55 [Note] Server socket created on IP: '127.0.0.1'.
150427 13:42:55 [Note] Event Scheduler: Loaded 0 events
150427 13:42:55 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: ready for connections.
Version: '5.5.43' socket: '/tmp/mysql.sock' port: 3306 Source distribution
150427 14:44:22 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).

复制代码