Re: select into dumpfile

2001-11-27 Thread Carl Troein
CRAUSAZ Yann writes: > For a project in my school, I have to store files into a MySql DB, and to > retrieve them to special locations. My problem is that I'm unable to write > the files anywhere else than in (something like) /var/lib/mysql (the > standard location of MySql). The error message is

select into dumpfile

2001-11-27 Thread CRAUSAZ Yann
Hi all, For a project in my school, I have to store files into a MySql DB, and to retrieve them to special locations. My problem is that I'm unable to write the files anywhere else than in (something like) /var/lib/mysql (the standard location of MySql). The error message is "cannot create/write

Re: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Peter Pentchev
er-side operation, as (again) clearly outlined in the docs :) * The `SELECT ... INTO OUTFILE 'file_name'' form of `SELECT' writes the selected rows to a file. The file is created on the server host and cannot already exist... So.. yes, you'll have to upgrade th

Re: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Bill Moran
Peter Pentchev wrote: > So, MySQL 3.22.x does not have the capability to produce dumpfiles, > only outfiles. > > Ah. I just read the whole of your message. You are using a 3.22.32 server - > so, sorry, but you're out of luck :( A Curses, I was hoping to avoid an upgrade (since we've ha

Re: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Peter Pentchev
at: Changes in release 3.23.6 - * Added `mysqld' option `-O lower_case_table_names={0|1}' to allow users to force table names to lowercase. * Added `SELECT ... INTO DUMPFILE'. . So, MySQL 3.22.x does not have the capability to produce dum

Re: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Bill Moran
om' clauses :) > > G'luck, > Peter > > -- > I am the thought you are now thinking. > > > Robin Keech wrote: > > > > > > use > > > SELECT * INTO OUTFILE 'filename' . > > > > > > -Original Message- >

Re: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Peter Pentchev
Original Message- > > From: Bill Moran [mailto:[EMAIL PROTECTED]] > > Sent: 09 May 2001 00:44 > > To: [EMAIL PROTECTED] > > Subject: Problem using "SELECT INTO DUMPFILE" > > > > I get an error stating: "you have an error in your SQL syntax near > &

Re: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Bill Moran
hat I need. Any other suggestions? -Bill Robin Keech wrote: > > use > SELECT * INTO OUTFILE 'filename' . > > -Original Message- > From: Bill Moran [mailto:[EMAIL PROTECTED]] > Sent: 09 May 2001 00:44 > To: [EMAIL PROTECTED] > Subject: Problem u

RE: Problem using "SELECT INTO DUMPFILE"

2001-05-09 Thread Robin Keech
use SELECT * INTO OUTFILE 'filename' . -Original Message- From: Bill Moran [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 00:44 To: [EMAIL PROTECTED] Subject: Problem using "SELECT INTO DUMPFILE" I get an error stating: "you have an error in your SQL syn

Problem using "SELECT INTO DUMPFILE"

2001-05-08 Thread Bill Moran
puters. I'm using client version 3.23.36 on machine redfs Server version 3.22.32 on machine redsql Do I need to upgrade the server before this will be possible? I understand that SELECT INTO DUMPFILE must put the file on the local machine, but does that mean when running the client on