MySQL Forums
Forum List  »  Security

Re: Secure File Privilege
Posted by: Peter Brawley
Date: August 19, 2022 11:54AM

With your table on a Windows machine where secure_file_prov="c:/in", this Load Data cmd works ...
LOAD DATA INFILE 'c:/in/aisle.csv'
INTO TABLE aisle
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

select * from aisle;
+---------+------------------+
| idaisle | aisleDescription |
+---------+------------------+
|       1 | 1                |
|       2 | 2                |
|       3 | 3                |
|       4 | 4                |
|       5 | 5                |
|       6 | 6                |
|       7 | 7                |
|       8 | 8                |
|       9 | 9                |
+---------+------------------+

Options: ReplyQuote


Subject
Views
Written By
Posted
418
February 22, 2022 12:17PM
202
February 22, 2022 12:39PM
184
February 22, 2022 01:00PM
202
February 22, 2022 01:03PM
175
February 22, 2022 01:41PM
193
February 22, 2022 03:16PM
187
February 22, 2022 05:09PM
198
February 26, 2022 03:34AM
182
August 18, 2022 12:34PM
113
August 18, 2022 10:47PM
104
August 19, 2022 10:22AM
Re: Secure File Privilege
106
August 19, 2022 11:54AM


Sorry, only registered users may post in this forum.

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.