mysqlStreamImporter

A nodejs importer who uses a stream reader to import huge SQL dump scripts into MySQL database

0. Installation:

npm install -g mysql-stream-importer

1. Exemple to use:

• $node cli -u root -p password -d database_file_name -s sql_file_name.sql
• $node cli -u root -p password -port 3308 -d database_file_name -s sql_file_name.sql

2. A CLI has been added to facilitate usage:

• $simport -u root -p password -d database_file_name -s sql_file_name.sql
• $simport -u root -p password -port 3308 -d database_file_name -s sql_file_name.sql

Here are console responses during the command running :

2017/12/31 19:14:09                             \vhosts\mysqlStreamImporter\jetwaves\cli
┏---- INFO: ----- start [args] -----
{ s: 'sqlDumpFileName.sql',
  d: 'databaseName',
  p: 123456,
  port: 3306,
  u: 'root' }
┗---- INFO: -----  end  [args] -----
2017/12/31 19:14:09                             \vhosts\mysqlStreamImporter\jetwaves\cli
┏---- INFO: ----- start [dbConnection  001 ] -----
{ host: 'localhost',
  user: 'root',
  password: '123456',
  port: 3306,
  database: 'databaseName' }
┗---- INFO: -----  end  [dbConnection] -----
2017/12/31 19:14:09                             \vhosts\mysqlStreamImporter\jetwaves\cli
        INFO:   filename = sqlDumpFileName.sql
2017/12/31 19:14:09                             \vhosts\mysqlStreamImporter\jetwaves\index.js
        INFO:   Starting Import from file: sqlDumpFileName.sql
2017/12/31 19:14:09                             \vhosts\mysqlStreamImporter\jetwaves\index.js
        INFO:   Connected to MySQL DB successfully
 ==== PROCESSING SQL IMPORT:  100 queries executed =====
 ==== PROCESSING SQL IMPORT:  200 queries executed =====
 ==== PROCESSING SQL IMPORT:  300 queries executed =====
2017/12/31 19:14:16                             \vhosts\mysqlStreamImporter\jetwaves\index.js
        INFO:   Total lines imported : 933
2017/12/31 19:14:16                             \vhosts\mysqlStreamImporter\jetwaves\index.js
        INFO:   found end of SQL at cnt 933     total line Count = 398
2017/12/31 19:14:16                             \vhosts\mysqlStreamImporter\jetwaves\index.js
        INFO:   Import SQL file Ended successfully
┏---- INFO: ----- start [timeElapse] -----
{ startImportTs: '1514718849455',
  endImportTs: '1514718856970',
  timeElapsed: '7515 ms' }
┗---- INFO: -----  end  [timeElapse] -----
   ---- LOG: \vhosts\mysqlStreamImporter\jetwaves\cli
        success  res   = 398