MySQL Forums
Forum List  »  Newbie

Re: Proper syntax of LOAD DATA INFILE
Posted by: Barry Galbraith
Date: November 26, 2013 03:01PM

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.

Options: ReplyQuote


Subject
Written By
Posted
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.