GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

SELECT INTO OUTFILE where target is network storage

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SELECT INTO OUTFILE where target is network storage

    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.
Working...
X