[RDD] How do I get RECORDINGS table?

Hello, I have need to export the RECORDINGS table of the Rivendell database. I have tried: mysql select * from RECORDINGS INTO OUTFILE '/home/rd/Documents/Test.txt'; but got the error: ERROR 1045 (28000): Access denied for user 'rduser'@'localhost' (using password: YES) We have over 1600

Re: [RDD] How do I get RECORDINGS table?

On Monday 29 December 2014 10:39:49 am Mike Price wrote: I have need to export the RECORDINGS table of the Rivendell database.  I have tried: mysql select * from RECORDINGS INTO OUTFILE '/home/rd/Documents/Test.txt'; but got the error: ERROR 1045 (28000): Access denied for user

Re: [RDD] How do I get RECORDINGS table?

You need to assign file access for the MySQL rduser account to be able to write files on the server. The Rivendell system doesn't set this grant when creating the rduser account. See http://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_file Also note this comment from the MySQL