sql-file-importer
v0.0.3-alpha.1
Published
import sql file into database for mariadb
Downloads
14
Readme
SQL File Importer
Import sql file to database in mariadb server. Probably also works in MySQL server, but currently only tested in mariadb 10.4.
Usage
const sqlFileImporter = require('sql-file-importer');
const config = {
host: 'localhost',
port: 3306,
user: 'root',
password: '',
database: 'test_db',
charset: 'utf8mb4',
trace: true,
verbose: 2,
};
/** import db data and multiple rows insert statement will be splitted into
* single row statements. **/
const proc = await importer.init(config).importFile(filepath, {
withData: 'single',
dropFirst: true,
});