SELECT INTO OUTFILE Error

Help
1

Hi Team,
I am getting below error when trying to run ‘SELECT INTO OUTFILE’ command.

"Feature ‘SELECT INTO OUTFILE when running MemSQL as a managed service’ is not supported by MemSQL. "

am I missing something basic? Below is the version .

memSQL>select version();
±----------+
| version() |
±----------+
| 5.5.58 |
±----------+

Thanks,
Anand.

2

Hi Anand,

Can you run select @@local_file_system_access_restricted and select @@memsql_version (select @@version reports the mysql compatible version)

3

Hi Adam,
Thanks for reply. Below are the details.

memSQL>select @@local_file_system_access_restricted;
±--------------------------------------+
| @@local_file_system_access_restricted |
±--------------------------------------+
| 1 |
±--------------------------------------+
memSQL>select @@memsql_version;
±-----------------+
| @@memsql_version |
±-----------------+
| 7.0.5 |
±-----------------+

Thanks,
Anand.

4

I’m not sure how, but it looks like local_file_system_access_restricted is set on your cluster. That is what’s blocking outfile (access_restricted is off by default).

Run: set global local_file_system_access_restricted =0 on your MA to get outfile working.

Also, 7.0.5 is a beta version of 7.0. You may want to consider switching for to a released version at some point (latest is 7.0.19. You can’t upgrade a Beta build, so you’ll need to reinstall.

-Adam

5

Hi ,
Thanks for the reply.
Tried same on version 7.0.16 with local_file_system_access_restricted = 0.
But, getting “Can’t resolve path …” error. Though I am able to load data using same path.
Thanks.

6

Can I see the full error message if you still have it (and ideally the select stmt your running to hit it)?

-Adam