I want to dump the contents of a table from my database into a text file. My logon (host, username, password) are all correct. And my query syntax is good. [quote]SELECT * INTO OUTFILE 'books.txt' FIELDS TERMINATED BY '|' FROM books[/quote] But I get this error when I run it:[code]Error 1045: Access denied for user 'user'@'localhost' (using password: YES)[/code] I was hoping that it would write the txt file to the directory from where I was running the query. But I am thinking that it is trying to write it to the MySQL server which, of course, I don't have permission to do. How can I dump this? Sam
