Export table data to 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.

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

1 Like