在做导出数据的时候遇到的问题,遇到此问题。
Select * into outfile '/tmp/test.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '/n' from TABLE limit 100;
ERROR 1 (HY000): Can't create/write to file '/test.txt' (Errcode: 13)
解决方法:
1.修改my.cnf,在MYSQLD中去除#tmodir 的#号;
2.保存修改,退出;
3.重启MYSQL服务;
>serivce mysqld stop;
>service mysqld start;