Not the answer you need?
Register and ask your own question!

SELECT INTO OUTFILE where target is network storage

KREAKREA EntrantCurrent User Role Participant
We are testing Percona XtraDB over CentOS 6 build and got everything working (and very happy with the stability and performance) except SELECT * FROM test INTO OUTFILE '//192.168.1.68/data/test.csv' scenario. Right now MySQL runs on a Windows server and above is simply handled by assigning mysql service a different logon criteria via a common user which also exists in network storage. How can we do the same thing over new Percona + CentOS combination? For info, 192.168.1.68 runs windows and "data" folder is shared by everyone. In Percona+CentOS combination LOAD DATA LOCAL INFILE '//192.168.1.68/data/test.csv'... works fine, but SELECT ... INTO OUTFILE '//192.168.1.68/data/test.csv' generates permission error as expected. Thanks in advance.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.