mysql 更改数据库目录以后不能启动！

dc10221203 发表于 2012-10-25 11:12:25

121025 10:55:01 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 10:55:05 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 10:55:05 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 10:55:05InnoDB: Initializing buffer pool, size = 16.0M
121025 10:55:05InnoDB: Completed initialization of buffer pool
121025 10:55:05InnoDB: 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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 10:55:05 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 10:55:56 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 10:55:56 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 10:55:56InnoDB: Initializing buffer pool, size = 16.0M
121025 10:55:56InnoDB: Completed initialization of buffer pool
121025 10:55:56InnoDB: 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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 10:55:56 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 10:59:14 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 10:59:15 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 10:59:15InnoDB: Initializing buffer pool, size = 16.0M
121025 10:59:15InnoDB: Completed initialization of buffer pool
121025 10:59:15InnoDB: 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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 10:59:15 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended

dc10221203 发表于 2012-10-25 11:25:48

军哥出来看看哈

谢谢

licess 发表于 2012-10-25 11:53:47

Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
可能这个表没复制过去

/usr/local/mysql/bin/mysql_upgrade 执行试试，或重新将数据复制到新目录试试

dc10221203 发表于 2012-10-25 12:26:28

121025 12:15:42 Event Scheduler: Purging the queue. 0 events
121025 12:15:42InnoDB: Starting shutdown...
121025 12:15:48InnoDB: Shutdown completed; log sequence number 0 44233
121025 12:15:48 /usr/local/mysql/libexec/mysqld: Shutdown complete

121025 12:15:48 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 12:16:35 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
121025 12:16:35InnoDB: Initializing buffer pool, size = 16.0M
121025 12:16:35InnoDB: Completed initialization of buffer pool
121025 12:16:35InnoDB: Started; log sequence number 0 44233
121025 12:16:35 Event Scheduler: Loaded 0 events
121025 12:16:35 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
121025 12:22:00 mysqld_safe A mysqld process already exists
121025 12:22:16 mysqld_safe A mysqld process already exists
121025 12:22:25 mysqld_safe A mysqld process already exists

重新复制CP重启还是有问题哦

licess 发表于 2012-10-25 14:39:10

回复 4# 的帖子

日志没错误

mysqld_safe A mysqld process already exists这个的话停掉mysql看看还有没有进程，有的话把mysql相关的进程都kill掉再启动

dc10221203 发表于 2012-10-25 15:13:12

121025 14:12:50 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 14:12:50 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 14:12:50InnoDB: Initializing buffer pool, size = 16.0M
121025 14:12:50InnoDB: Completed initialization of buffer pool
121025 14:12:50InnoDB: 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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 14:12:50 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 14:13:31 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 14:13:34 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 14:13:34InnoDB: Initializing buffer pool, size = 16.0M
121025 14:13:34InnoDB: Completed initialization of buffer pool
121025 14:13:34InnoDB: 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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 14:13:34 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
军哥在那里呢

dc10221203 发表于 2012-10-25 16:38:21

root@ubuntu:~# /root/lnmpa status
=========================================================================
Manager for LNMPA V0.9,Written by Licess
=========================================================================
LNMPA is a tool to auto-compile & install Nginx+MySQL+PHP+Apache on Linux
This script is a tool to Manage status of LNMPA
For more information please visit http://www.lnmp.org

Usage: /root/lnmpa {start|stop|reload|restart|kill|status}
=========================================================================
Nginx is runing!
/etc/init.d/httpd: 112: /etc/init.d/httpd: lynx: not found
* MySQL running (1186)

现在数据库正常了但是 httpd不能启动

dc10221203 发表于 2012-10-25 16:38:44

回复 5# 的帖子

dc10221203 发表于 2012-10-25 18:55:02

licess 发表于 2012-10-25 21:06:42

回复 9# 的帖子

常见问题里都已经写过了，不用再重复说了。

页: [1]

VPS侦探论坛's Archiver