改了之后，需要把其中的文件也复制过去。 cp -rf /var/lib/mysql/ /home 启动MySQL还是起不来 报错： Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] ll /home/mysql 看一下内容。 [root@localhost mysql]# ll /home/mysql/ total 20528 -rw-r----- 1 mysql mysql 10485760 2009-12-08 12:38 ibdata1 -rw-r----- 1 mysql mysql 5242880 2009-12-08 12:38 ib_logfile0 -rw-r----- 1 mysql mysql 5242880 2009-12-08 12:38 ib_logfile1 drwx------ 2 mysql mysql 4096 2009-12-08 12:38 mysql drwx------ 2 mysql mysql 4096 2009-12-08 12:38 test 贴一下你的 my.cnf 和你启动mysql服务用的命令。 091208 13:09:14 mysqld started 091208 13:09:14 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: 'open'. InnoDB: Cannot continue operation. 091208 13:09:14 mysqld ended
请高手指点,我对一张表查询后再更新,查询是子查询,报错: You can't specify target table 'a_table' for update in from clause 完整SQL语句是 UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
