ect, I'll be able to
store it? That should work... But I though there was a -include_column_names
option or something :)
Which way should I go?
Ariel
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 01 de marzo de 2006 10:58
Para: Ariel Sán
[snip]
This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
[/snip]
Any sel
nsaje original-
De: unplug [mailto:[EMAIL PROTECTED]
Enviado el: martes, 28 de febrero de 2006 21:55
Para: mysql@lists.mysql.com
Asunto: file permission
Hi,
When I use a query "SELECT * into outfile '/tmp/report.csv' fields terminated
by ',' lines terminated by '
Actually, here is my case.
There is a script owned by user A running daily.
script---
rm -rf /tmp/report.csv
mysql -umysql -pabc table -e "SELECT * into outfile '/tmp/report.csv'
fields terminated by ',' lines terminated by '\n' FROM table;"
In the first run, a file with the following p
On Tuesday 28 February 2006 23:41, Joshua Kugler wrote:
> You can't do that. The mysql server runs as user mysql, so it cannot
> create files owned by another user. If you run the mysql server as root
> (don't!), you might be able to do that, but I do not believe mysql has a
> facility for changi
g a script as the
user you want to own the file and outputing the results via the script.
j- k-
On Tuesday 28 February 2006 19:18, unplug wrote:
> Thanks!
> But I want to change the default setting of the file permission and
> ownership. (i.e. the file will be created
Thanks!
But I want to change the default setting of the file permission and
ownership. (i.e. the file will be created with permission and
ownerhsip according to my setting).
On 3/1/06, CodeHeads <[EMAIL PROTECTED]> wrote:
> On Tuesday 28 February 2006 22:55, unplug wrote:
> > Hi,
On Tuesday 28 February 2006 22:55, unplug wrote:
> Hi,
> When I use a query "SELECT * into outfile '/tmp/report.csv' fields
> terminated by ',' lines terminated by '\n' FROM table;", it will
> create a file with the following permission and owner.
>
> -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 r
Hi,
When I use a query "SELECT * into outfile '/tmp/report.csv' fields
terminated by ',' lines terminated by '\n' FROM table;", it will
create a file with the following permission and owner.
-rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv
How can I change the default permission or the ow
Thank you Gerald.
That was the problem. I thought I read that FILE permission could not
be set to a specific table so I was using somedatabase.*.
David Scott
On Monday, August 4, 2003, at 11:42 AM, gerald_clark wrote:
Since you don't show your grant statement, it is difficult
Since you don't show your grant statement, it is difficult tell you what
the problem is.
Since FILE is a global permission you need to grant it on *.* not
somedatabase.*
David Scott wrote:
Greetings all
I am not able to GRANT file permission to users. All permissions end
up being issued
Greetings all
I am not able to GRANT file permission to users. All permissions end up
being issued with FILE being left out. What could I be missing? I
running 3.23.53 on Mac OS 10.2.
Thank you.
-
David Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
At 11:13 PM -0400 5/8/01, A. Chris Nichols wrote:
>Hello everyone,
>
>I was wondering if anyone could help me out and explain a bit about
>the FILE permissions and how they relate to two particular scenarios:
>
>In both cases MySQL is running on SunOS 5.7 and running MySQL client
>version 3.22.
Hello everyone,
I was wondering if anyone could help me out and explain a bit about the
FILE permissions and how they relate to two particular scenarios:
In both cases MySQL is running on SunOS 5.7 and running MySQL client
version 3.22.23b
MySQL UserA has permissions only on DatabaseA and is
14 matches
Mail list logo
