node.js exec sql file

Question

I have a sql file that contains:

DROP TABLE IF EXISTS aodb;
CREATE TABLE aodb (lowid INT, highid INT, lowql INT, highql INT, name VARCHAR(150), icon INT);
INSERT INTO aodb VALUES (275403, 275403, 1, 1, '"A History of Rubi-Ka" by Prof. Arthur B. Diggins', 136331);

It has about 275k inserts, is there a way I can use it with node? I need a way to create that table and insert the data from inside a node file w/o any kind of interaction from the user.

zlumer · Accepted Answer · 2015-06-09 09:26:43Z

2

Connect to your MySql database with any Node.js MySql client, read SQL from the file (using fs module) and execute it.

answered Jun 9, 2015 at 9:26

zlumer

7,0521 gold badge27 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mingfei · Accepted Answer · 2017-11-09 01:36:12Z

0

I have the same question today, here is my final solution:


const cp = require('child_process');

cp.exec('mysql -u<your_user> -p<your_password> < your_file.sql', (error, stdout, stderr) => {
    if (error) throw error;
    console.log(`stdout: ${stdout}`);
    console.log(`stderr: ${stderr}`);
});

edited Nov 9, 2017 at 1:36

answered Nov 8, 2017 at 8:50

Mingfei

1,6791 gold badge13 silver badges14 bronze badges

Collectives™ on Stack Overflow

node.js exec sql file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related