[求助] mysql升級(jí)到5.5報(bào)錯(cuò)了

qq682907

wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh我是按著這個(gè)升級(jí)的 是面板安裝好后
升級(jí)的

下載 (30.33 KB)

2013-2-28 23:28

詳細(xì)的錯(cuò)誤日志
130228 23:33:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130228 23:33:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130228 23:33:43 [Note] Server socket created on IP: '0.0.0.0'.
130228 23:33:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130228 23:33:43 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.27/data/MyVPS1970.pid ended

qq682907

回復(fù) 2# admin


   我自己用論壇里腳本升級(jí)的

qq682907

回復(fù) 2# admin


   wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh

是這個(gè)腳本


我把里面的參數(shù) 復(fù)制出來(lái)給你看
#!/bin/bash
IN_DIR="/www/wdlinux"
MYS_VER="5.5.27"
if [ ! -f mysql-${MYS_VER}.tar.gz ];then

wget -c http://dl.wdlinux.cn:5180/soft/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"

qq682907

回復(fù) 5# admin


   mysql-5.1.63 一鍵安裝包 安裝下來(lái)的mysql 然后就直接升級(jí)了

qq682907

回復(fù) 6# qq682907


   管理 報(bào)錯(cuò)了

qq682907

回復(fù) 8# admin


   已經(jīng)發(fā)了 外出了3小時(shí) 剛剛回來(lái)

qq682907

回復(fù) 13# zd305


   沒(méi)升級(jí)成功