But I get this error when I run it:
SELECT * INTO OUTFILE 'books.txt'
FIELDS TERMINATED BY '|'
Error 1045: Access denied for user 'user'@'localhost' (using password: YES)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?