Copying a MYSQL database

Translated submission in the German forum. You can read the original entry here .

Does each table have to be individually selected and copied?

Or is there a function to copy an entire database?

Thanks
Norbert

Yes, but FlowHeater was not originally designed to simply duplicate a complete database. For this the database tools of the database supplier are much better suited. For example, with MySQL you can use mysqldump .

If you do need to transform the contents of lots of tables in one go, an individual FlowHeater Definition is required for each database table and the table transforms need be executed in a sequence that maintains database relations and respects constraints. For example, using the Batch Module you can automate the procedure with a Command Script (CMD) and execute it on a scheduled basis with a Windows Task automatically at specific times of the day.

Example Command Script (database-copy.cmd)