MySQL Forums
Forum List  »  Newbie

Re: Converting a MySQL Table to PDF File
Posted by: Barry Galbraith
Date: May 28, 2023 04:28PM

As I said in a previous post
Quote

Any file you want to write to will need to be specified as being in the folder on the server specified in secure_file_priv variable, currently /var/lib/mysql-files/

SELECT INTO OUTFILE doesn't magicaly transport your results from the mysql server to your client machine. It can only put them in the "secure-file-priv" folder on the server.
See the Refman, in particular the note at the bottom of the page.
Your system has secure-file-priv set to /var/lib/mysql-files

https://dev.mysql.com/doc/refman/5.7/en/select-into.html

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Converting a MySQL Table to PDF File
May 28, 2023 04:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.