Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Copying a MYSQL database

Copying a MYSQL database 5 years 8 months ago #2093

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Re:Copying a MYSQL database 5 years 8 months ago #2094

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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)
@echo off

fhbatch.exe table_invoices.fhd
fhbatch.exe table_parts.fhd
...
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.071 seconds