[求助] 发现一个问题,管理帮忙看看 啥情况

qq682907

mysql用脚本升级
64位的升级到5.5.43
mysql启动脚本就变成
最新的wdcp

数据库文件目录 跑data了 不知道什么情况 32位的 centos5.8我测试了 又是正常的 费解  

我前端3台全是64位的 都需要升级了 数据库了  加内存加不起啊--。 只能测试升级数据库了。。。

升级脚本在2楼

1. #!/bin/bash
   
2. IN_DIR="/www/wdlinux"
   
3. MYS_VER="5.5.43"
   
4. if [ ! -f mysql-${MYS_VER}.tar.gz ];then
   
5.         wget -c http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-${MYS_VER}.tar.gz
   
6. fi
   
7. yum install -y cmake
   
8. tar zxvf mysql-${MYS_VER}.tar.gz
   
9. cd mysql-${MYS_VER}
   
10. 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
    
11. [ $? != 0 ] && echo "configure err" && exit
    
12. make
    
13. [ $? != 0 ] && echo "make err" && exit
    
14. make install
    
15. [ $? != 0 ] && echo "make install err" && exit
    
16. service mysqld stop
    
17. if [ ! -d /www/wdlinux/mysql_bk ];then
    
18. mkdir -p /www/wdlinux/mysql_bk
    
19. cp -pR /www/wdlinux/mysql/var/* /www/wdlinux/mysql_bk
    
20. fi
    
21. rm -f /www/wdlinux/mysql
    
22. ln -sf $IN_DIR/mysql-$MYS_VER /www/wdlinux/mysql
    
23. sh scripts/mysql_install_db.sh --user=mysql --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/var
    
24. chown -R mysql.mysql /www/wdlinux/mysql/var
    
25. mv /www/wdlinux/mysql/var/mysql /www/wdlinux/mysql/var/mysqlo
    
26. cp -pR /www/wdlinux/mysql_bk/* /www/wdlinux/mysql/var/
    
27. cp support-files/mysql.server /www/wdlinux/init.d/mysqld
    
28. chmod 755 /www/wdlinux/init.d/mysqld
    
29. service mysqld restart
    
30. echo
    
31. if [ -d /www/wdlinux/mysql-5.1.63 ];then
    
32.         ln -sf /www/wdlinux/mysql-5.1.63/lib/mysql/libmysqlclient.so.16* /usr/lib/
    
33. fi
    
34. sleep 2
    
35. sh /www/wdlinux/tools/mysql_wdcp_chg.sh
    
36. echo
    
37. echo "mysql update is OK"

复制代码

qq682907

1. 150427 13:36:23 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: ready for connections.
   
2. Version: '5.5.43'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
   
3. 150427 13:42:53 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: Normal shutdown
   
4. 
   
5. 150427 13:42:53 [Note] Event Scheduler: Purging the queue. 0 events
   
6. 150427 13:42:53  InnoDB: Starting shutdown...
   
7. 150427 13:42:53  InnoDB: Shutdown completed; log sequence number 1595675
   
8. 150427 13:42:53 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: Shutdown complete
   
9. 
   
10. 150427 13:42:53 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.43/data/iZ23c87g06kZ.pid ended
    
11. 150427 13:42:54 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.43/data
    
12. 150427 13:42:54 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
    
13. 150427 13:42:54 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
    
14. 150427 13:42:54 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld (mysqld 5.5.43) starting as process 28339 ...
    
15. 150427 13:42:54 InnoDB: The InnoDB memory heap is disabled
    
16. 150427 13:42:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
17. 150427 13:42:54 InnoDB: Compressed tables use zlib 1.2.3
    
18. 150427 13:42:54 InnoDB: Initializing buffer pool, size = 128.0M
    
19. 150427 13:42:54 InnoDB: Completed initialization of buffer pool
    
20. 150427 13:42:54 InnoDB: highest supported file format is Barracuda.
    
21. 150427 13:42:54  InnoDB: Waiting for the background threads to start
    
22. 150427 13:42:55 InnoDB: 5.5.43 started; log sequence number 1595675
    
23. 150427 13:42:55 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
    
24. 150427 13:42:55 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
    
25. 150427 13:42:55 [Note] Server socket created on IP: '127.0.0.1'.
    
26. 150427 13:42:55 [Note] Event Scheduler: Loaded 0 events
    
27. 150427 13:42:55 [Note] /www/wdlinux/mysql-5.5.43/bin/mysqld: ready for connections.
    
28. Version: '5.5.43'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
29. 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).

复制代码

错误日志

我是自己手动 复制var里面的数据库文件到data目录下 才启动成功了  很临时的解决办法