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
非特殊说明，本博所有文章均为博主原创。
如若转载，请注明出处：https://www.isres.com/database/57.html