MySQL写在文本文件上 [英] MySQL writing on a text file

问题描述

我试图在MySQL Workbench 5.2.45上的文本文件上使用Mountain Lion OS 10.8.2在Macbook Pro中写入数据;我得到以下错误：
$ b

错误代码：1.无法创建/写入文件'/ Users / JohnnyDahdah / Desktop / datos2'（Errcode：13 - 权限被拒绝）0.001秒

我的代码如下：

pre $ select * from Datos into outfile'/Users/JohnnyDahdah/Desktop/datos2.txt';


解决方案

/ em>那么它没有写入你的主目录的权限。您可以安排 和 it 共享一个组，但最好将它写入 / tmp


I'm trying to write data on a text file on MySQL workbench 5.2.45 in a Macbook Pro with Mountain Lion OS 10.8.2; and I get the following mistake:

"Error Code: 1. Can't create/write to file '/Users/JohnnyDahdah/Desktop/datos2' (Errcode: 13 - Permission denied) 0.001 sec"

My code is the following:

select * from Datos into outfile '/Users/JohnnyDahdah/Desktop/datos2.txt';

解决方案

Unless the server is running as you then it does not have permission to write into your home directory. You could probably arrange for you and it to share a group, but it's probably better to get it to write to /tmp and avoid the whole issue.

这篇关于MySQL写在文本文件上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！