Hi,

When trying to export data from infobright table to CSV file using SELECt…...OUTFILE query the following error is displayed
“Brighthouse specific error: Unable to open file or named pipe.”.
However, this happens if the table is located in a remote machine but works fine if tried locally.

Please revert.

Regards,
Ganesh.S

Hi Ganesh,

The file is generated on the server where Infobright is running. So in order to use this, you need local permissions on the server filesystem in the directory where you are trying to put the file.

More specifically, the user running mysqld (typically “mysql”) needs permissions there. Your mysql login user also needs to be granted the FILE permission.

Geoffrey