[RDD] How do I get RECORDINGS table?

2014-12-29 Thread Mike Price
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?

2014-12-29 Thread Cowboy
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?

2014-12-29 Thread Mike Carroll
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