Dump file export import in mysql table using node js

 

const host = 'localhost';

const user = 'root';

const password = 'root@123';

const database = 'namedb';

const Importer = require('mysql-import');

const { exec } = require('child_process');

function createTableDump(dbName, tableName, fileName) {

 exec(`mysqldump -u root -p'root@123' ${dbName} ${tableName} > ${fileName}`, (error, stdout, stderr) => {

   if (error) {

     console.error(`exec error: ${error}`);

     return;

   }

   console.log(`Table dump file created: ${fileName}`);

 });

}

       createTableDump('PPARK', 'trx_data', 'final.sql');

       const importer = new Importer({host, user, password, database});

       importer.onProgress(progress=>{

       var percent = Math.floor(progress.bytes_processed / progress.total_bytes * 10000) / 100;

       console.log(`${percent}% Completed`);

       });

       importer.import('final.sql').then(()=>{

       var files_imported = importer.getImported();

       console.log(`${files_imported.length} SQL file(s) imported.`);

       }).catch(err=>{

       console.error(err);

       });