Restore MySQL sql dump by nodejs without mysqldump

Question

There is sql file. It has to be used for test cases. I need to restore it. I would like to restore it without third party utils. I've made few attempts. I receive new limitations these I can not resolve easy. An easier solution has to exist. Another solutions I have seen from networks do not satisfy requirements. I can not restore functions because of semicolons in sql text.

async function rawSQLFromFile(connection, path) {
  const text = fs.readFileSync(path).toString()
  const queries = text.split(';')
  for(const query of queries) {
    await runQuery(connection, query)
  }
}

I use mysql library But it does not have the functionality.

Can you add some info about I can not restore functions because of brackets and it does not have the functionality ? It is a bit unclear what you mean by that... — Luuk
– Luuk, Commented Feb 24, 2020 at 9:56
And did you notice this package: npmjs.com/package/mysql-import — Luuk
– Luuk, Commented Feb 24, 2020 at 10:00
I've corrected. It is because of semicolons. The text is divided into subqueries by semicolons. The problem is that the function definition have semicolons. — Victor Shelepen
– Victor Shelepen, Commented Feb 24, 2020 at 10:15
I will check the library. It looks better than I have tried before. — Victor Shelepen
– Victor Shelepen, Commented Feb 24, 2020 at 10:16
@Luuk I've checked the library npmjs.com/package/mysql-import. :) It also does not import the function. I have been looking at code. It does not process begin end constructions at all. So the library has the same issue as my code. — Victor Shelepen
– Victor Shelepen, Commented Feb 24, 2020 at 10:40

Stock Overflaw · Accepted Answer · 2020-02-24 10:47:54Z

1

Untested, although this should work with your lib:

const connection = mysql.createConnection({
  // described at https://www.npmjs.com/package/mysql#multiple-statement-queries
  multipleStatements: true,
  // your connection options follow here
});
connection.query(yourSqlFileContent, (err) => { console.log(err ? err : 'restored!') });

answered Feb 24, 2020 at 10:47

Stock Overflaw

3,3411 gold badge15 silver badges14 bronze badges

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

1 Comment

Victor Shelepen Over a year ago

It has to work at core level according to the lines: // May send multiple statements per COM_QUERY and COM_STMT_PREPARE defaultFlags.push('+MULTI_STATEMENTS'); But it does not ...

Collectives™ on Stack Overflow

Restore MySQL sql dump by nodejs without mysqldump

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related