mysql数据导出

时间：2009-07-23 来源：nychenlei

mysql> select * from pet into outfile '/tmp/pet1.txt';
Query OK, 13 rows affected (0.00 sec) [root@localhost tmp]# cat pet1.txt
buffy   chen    bird    \N      1997-12-09      \N
fang    james   hamster f       1999-11-11      \N
smth    chen    bird    \N      1997-12-09      \N
aa      chen    dog     m       1977-11-11      \N
bb      chen    dog     f       1977-11-11      \N
cc      chen    cat     m       1977-11-11      \N
dd      chen    cat     f       1977-11-11      \N
ee      chen    bird    m       1977-11-11      \N
ff      chen    bird    f       1977-11-11      \N
gg      chen    nn      m       1977-11-11      \N
hh      chen    nn      f       1977-11-11      \N
kk      chen    mm      m       1977-11-11      \N
ww      chen    mm      f       1977-11-11      \N mysql> select * from pet into outfile '/home/pet1.txt';
ERROR 1 (HY000): Can't create/write to file '/home/pet1.txt' (Errcode: 13) 没有权限导出到/home目录下。。。 /tmp目录下可以的。。。。

相关阅读更多 +