99精品国产综合久久久久五月天,免费观看欧美大片毛片不用播放器 ,AV无码理论片在线观看免费网站,国产精品国产成人国产三级

Board logo

標(biāo)題: [求助] mysql升級(jí)到5.5報(bào)錯(cuò)了 [打印本頁(yè)]
作者: qq682907    時(shí)間: 2013-2-28 23:28     標(biāo)題: mysql升級(jí)到5.5報(bào)錯(cuò)了

本帖最后由 qq682907 于 2013-2-28 23:37 編輯

wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh我是按著這個(gè)升級(jí)的 是面板安裝好后
升級(jí)的
QQ截圖20130228232600.jpg
詳細(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

圖片附件: QQ截圖20130228232600.jpg (2013-2-28 23:28, 30.33 KB) / 下載次數(shù) 19160
http://fudaan.com/bbs/attachment.php?aid=2481&k=1997d6391fefd7e44fa51e64dfc57baf&t=1745052198&sid=uYVsSp

作者: admin    時(shí)間: 2013-2-28 23:41

你這個(gè)是新下載安裝的嗎?

怎么還是/www/wdlinux/mysql-5.5.27/data目錄,應(yīng)該是
/www/wdlinux/mysql-5.5.27/var
這個(gè)才對(duì)的
作者: qq682907    時(shí)間: 2013-2-28 23:42

回復(fù) 2# admin


   我自己用論壇里腳本升級(jí)的
作者: qq682907    時(shí)間: 2013-2-28 23:43

回復(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"
作者: admin    時(shí)間: 2013-3-1 09:16

之前是安裝的哪個(gè),升級(jí)的?
作者: qq682907    時(shí)間: 2013-3-1 10:16

回復(fù) 5# admin


   mysql-5.1.63 一鍵安裝包 安裝下來(lái)的mysql 然后就直接升級(jí)了
作者: qq682907    時(shí)間: 2013-3-1 11:26

回復(fù) 6# qq682907


   管理 報(bào)錯(cuò)了
作者: admin    時(shí)間: 2013-3-1 11:50

PM IP,密碼來(lái)看看
作者: qq682907    時(shí)間: 2013-3-1 15:45

回復(fù) 8# admin


   已經(jīng)發(fā)了 外出了3小時(shí) 剛剛回來(lái)
作者: tom1978    時(shí)間: 2013-3-25 19:34

這個(gè)怎么解決 我也一樣的
作者: zd305    時(shí)間: 2013-4-1 21:39

求解決辦法？
作者: admin    時(shí)間: 2013-4-2 08:55

檢查mysql是否啟動(dòng),或不能啟動(dòng)的原因,看下日志
作者: zd305    時(shí)間: 2013-4-2 20:10

錯(cuò)誤日志如下，請(qǐng)教如何解決？
130402 20:03:37 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.27/data
/www/wdlinux/mysql-5.5.27/bin/mysqld: Table 'mysql.plugin' doesn't exist
130402 20:03:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130402 20:03:38 InnoDB: The InnoDB memory heap is disabled
130402 20:03:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130402 20:03:38 InnoDB: Compressed tables use zlib 1.2.3
130402 20:03:38 InnoDB: Initializing buffer pool, size = 128.0M
130402 20:03:38 InnoDB: Completed initialization of buffer pool
130402 20:03:38  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
130402 20:03:38 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.27/data/li260-147.pid ended
作者: qq682907    時(shí)間: 2013-4-2 22:48

回復(fù) 13# zd305


   沒升級(jí)成功
作者: qq514408389    時(shí)間: 2013-4-3 09:54

本帖最后由 qq514408389 于 2013-4-3 11:59 編輯

回復(fù) 14# qq682907


    可以修改下/www/wdlinux/init.d/mysqld這個(gè)文件
    里面這兩行basedir=
                  datadir=
    修改如下
    basedir=/www/wdlinux/mysql
    datadir=/www/wdlinux/mysql/var
    然后再重新試試
作者: happyboy    時(shí)間: 2013-4-3 11:09

http://fudaan.com/bbs/viewthread.php?tid=5461
作者: qq514408389    時(shí)間: 2013-4-3 11:15

修改的是init.d目錄下mysqld這個(gè)文件，寫少了，樓上正解
作者: liumingzhij26    時(shí)間: 2013-11-2 16:26

Starting MySQL.... ERROR! The server quit without updating PID file (/www/wdlinux/mysql/var/Centos214.pid).

basedir=/www/wdlinux/mysql
    datadir=/www/wdlinux/mysql/var
我都修改了這個(gè)，為什么還啟動(dòng)不了，已經(jīng)重啟過(guò)了
作者: liumingzhij26    時(shí)間: 2013-11-2 16:28

回復(fù) 18# liumingzhij26


131102 16:21:24 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
131102 16:21:24 InnoDB: The InnoDB memory heap is disabled
131102 16:21:24 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
131102 16:21:24 InnoDB: Compressed tables use zlib 1.2.3
131102 16:21:24 InnoDB: Initializing buffer pool, size = 128.0M
131102 16:21:24 InnoDB: Completed initialization of buffer pool
131102 16:21:24 InnoDB: highest supported file format is Barracuda.
131102 16:21:24  InnoDB: Waiting for the background threads to start
131102 16:21:25 InnoDB: 1.1.8 started; log sequence number 1589339
131102 16:21:25 [ERROR] /www/wdlinux/mysql/bin/mysqld: unknown variable 'default-character-set=utf8'
131102 16:21:25 [ERROR] Aborting


131102 16:21:25  InnoDB: Starting shutdown...
131102 16:21:26  InnoDB: Shutdown completed; log sequence number 1589339
131102 16:21:26 [Note] /www/wdlinux/mysql/bin/mysqld: Shutdown complete


131102 16:21:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql/var/Centos214.pid ended
作者: liumingzhij26    時(shí)間: 2013-11-2 16:31

/www/wdlinux/mysql/bin/mysqld: unknown variable 'default-character-set=utf8'  默認(rèn)配置了efault-character-set=utf8就不能啟動(dòng)了
作者: admin    時(shí)間: 2013-11-4 20:19

把這行去掉
作者: caokai    時(shí)間: 2018-2-14 00:00

升級(jí)后沒有var這個(gè)文件夾啊�。�！



歡迎光臨 WDlinux官方論壇 (http://fudaan.com/bbs/) Powered by Discuz! 7.2