When i executed the query i got the below error.
mysql> select * into outfile '/tmp/csr.txt' from CRS_STRATEGY_RULES;
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
The fix is to disable the secure_file_priv
mysql> show variables like secure_file_priv';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | |
+------------------+-------+
The variable is an read-only variable and we will need a mysql restart for the same.
Add the variable under [mysqld] in my.cnf as,
secure_file_priv=""
Do a mysql restart and you will be able to perform the query.
service mysqld restart
mysql> show variables like secure_file_priv%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | |
+------------------+-------+
mysql> select * into outfile '/tmp/csr.txt' from CRS_STRATEGY_RULES;
Query OK, 145 rows affected (0.00 sec)
