Comments - load data infile referencing one path while mariadb uses a totally different path and can't find input file
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
answering my own question, here.
Mariadb sets the data path in my.ini (in windows), so when you enter the argument to INFILE, it is looking for a file name located in the folder the data path is set to. That's why I was losing my backslashes.
1. put the data file into the data folder. 2. use the data file name alone as argument to the INFILE keyword.
Is there a way to mark this question "answered"?