Export table data to SQL file

[mlauber71]

@skullbeast420

export it to a .sql file?

@skullbeast420 .sql would typically refer to a MySQL (or MariaDB) dump of a database to backup or transfer it. A quick google research found no R or Python tool (you might be able to use in KNIME) to create such a dump without the databases themselves.

mysqldump

The good news is MySQL, as well as MariaDB, are free and KNIME should offer a Connector (for the later there seems to be a debate going on).

It might be possible to trigger such a backup from within KNIME (maybe with the help of a R or Python snippet with a MySQL driver).

For educational purposes, I created a workflow to do it the other way round to import a mysql dump into KNIME (or H2 database) without the database itself

Reading Mysql dump(.sql)

This blog describes an approach using Unix tool awk and a script. It might be possible to set up such a solution with KNIME although it is not straightforward: This high ranked stackoverflow entry describes an approach using R. There are also some limitations mentioned. Or you could try and set up new MySQL database and import the dump.