On Dec 29, 2014, at 10:39 49, Mike Price <[email protected]> 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';
You can also do this with a pipeline, which avoids the need for the FILE
permission, e.g.:
echo "select * from RECORDINGS" | mysql -u rduser -p Rivendell >
/home/rd/Documents/Test.txt
Cheers!
|----------------------------------------------------------------------|
| Frederick F. Gleason, Jr. | Chief Developer |
| | Paravel Systems |
|----------------------------------------------------------------------|
| The real problem with hunting elephants is carrying the decoys. |
| -- Anonymous |
|—————————————————————————————————---|
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
