Re: Proper syntax of LOAD DATA INFILE
No restart required.
As long as your login has sufficient privilege, consider this.
mysql> show global variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set (0.00 sec)
mysql> SET GLOBAL local_infile =1;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
1 row in set (0.00 sec)
// do your LOAD DATA LOCAL INFILE stuff here
//
//
mysql> SET GLOBAL local_infile =0;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
Good luck,
Barry.
Subject
Written By
Posted
November 23, 2013 11:34AM
November 23, 2013 08:50PM
November 24, 2013 11:19AM
November 25, 2013 10:53AM
November 25, 2013 03:32PM
November 25, 2013 03:51PM
November 26, 2013 08:37AM
Re: Proper syntax of LOAD DATA INFILE
November 26, 2013 03:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.