Re: table to output "into outfile"

[Bill Karwin]

The INTO OUTFILE syntax will create a filename, but not a directory.

Also note that when using relative paths, the file will be created relative to the current working directory of the thread in the MySQL Server, not the client. The current working directory is the data directory of the database you are using.

Say for example your MySQL data directory is "/var/lib/mysql" and your database name is "eCBOT". The relative path you gave will try to create a file "/var/lib/mysql/eCBOT/kss/lauradata.csv".

Regards,
Bill K.