Chinaunix

标题: 求mysql5.0升级5.1方案 [打印本页]

作者: 狗尾草 时间: 2010-07-23 15:54
标题: 求mysql5.0升级5.1方案
服务器升级是debian，希望mysql升级至5.1.48
改用testing源，安装后，服务起不来。估计是需要执行什么脚本，更新些权限表，但服务器起不来，更新脚本如何执行？
全新安装的方案有的是，但升级的很少，对线上服务器的升级，更得谨慎。

服务启动日志：
Jul 23 15:29:19 debian mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 23 15:29:19 debian mysqld: 100723 15:29:19 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 15:29:19 debian mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Jul 23 15:29:19 debian mysqld: 100723 15:29:19 [ERROR] Can't open the mysql.plugin table. Please
Jul 23 15:29:19 debian mysqld: 100723 15:29:19  InnoDB: Started; log sequence number 0 57246
Jul 23 15:29:19 debian mysqld: 100723 15:29:19 [ERROR] /usr/sbin/mysqld: unknown option '--skip-
Jul 23 15:29:19 debian mysqld: 100723 15:29:19 [ERROR] Aborting
Jul 23 15:29:19 debian mysqld:
Jul 23 15:29:19 debian mysqld: 100723 15:29:19  InnoDB: Starting shutdown...
Jul 23 15:29:25 debian mysqld: 100723 15:29:25  InnoDB: Shutdown completed; log sequence number
Jul 23 15:29:25 debian mysqld: 100723 15:29:25 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 15:29:25 debian mysqld:
Jul 23 15:29:25 debian mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 23 15:29:34 debian /etc/init.d/mysql[6165]: 0 processes alive and '/usr/bin/mysqladmin --def
Jul 23 15:29:34 debian /etc/init.d/mysql[6165]: #007/usr/bin/mysqladmin: connect to server at 'l
Jul 23 15:29:34 debian /etc/init.d/mysql[6165]: error: 'Can't connect to local MySQL server thro
Jul 23 15:29:34 debian /etc/init.d/mysql[6165]: Check that mysqld is running and that the socket
Jul 23 15:29:34 debian /etc/init.d/mysql[6165]:

作者: renxiao2003 时间: 2010-07-23 16:00
是不是需要有个Table 'mysql.plugin'表（这个表不存在）

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)