MySQL Forums
Forum List  »  General

Re: exporting table
Posted by: Sean Nolan
Date: April 01, 2005 10:27AM

According to the documentation for SELECT ... INTO OUTFILE, the file must not exist, so if it does exist you'll need to delete it before you run the statement. Here is the quote from 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, so you must have the FILE privilege to use this syntax. The file cannot currently exist, which among other things prevents files such as /etc/passwd and database tables from being destroyed."

Sean

Options: ReplyQuote


Subject
Written By
Posted
March 31, 2005 07:18PM
Re: exporting table
April 01, 2005 10:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.