mysql修改表报ERROR 1878 (HY000): Temporary file write failure

mysql> alter table news add create_time datetime null;
ERROR 1878 (HY000): Temporary file write failure.

原因默认tmp空间不够

处理方法:

[root@s110732 ~]# vim /etc/my.cnf #把tmpdir设置到 /data/tmp
[root@s110732 ~]# mkdir -p /data/tmp
[root@s110732 ~]# service mysqld restart
Shutting down MySQL..... SUCCESS! 
Starting MySQL. ERROR! The server quit without updating PID file 
[root@s110732 ~]# chown -R mysql:mysql /data/tmp
[root@s110732 ~]# service mysqld restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL.. SUCCESS! 

标签: none

非特殊说明,本博所有文章均为博主原创。

最新文章

发表评论