The Ultimate Guide to High Availability with MariaDB

Comments - Importing CSV File to mariadb

1 year, 3 months ago Ian Gilfillan
Re: Importing CSV File to mariadb [Answer]

Please give full details in a question in order for someone to be more likely to help. What are you using to connect to MariaDB? There is no version 2 of MariaDB Server, perhaps you are using Node MySQL 2? I see this thread saying that node-mysql2 does not allow local access, but gives a possible workaround.

Or else try MariaDB Connector/Node.js which has the permitLocalInfile parameter, which should help you.

mariadb.createConnection({
   host: 'FULLY_QUALIFIED_DOMAIN_NAME',
   port: 'TCP_PORT',
   user:'DATABASE_USER',
   password: 'DATABASE_PASSWORD',
   permitLocalInfile: 'true'
 });
 
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.