FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the MySQL Adapter Adapter, which may answer your question: CSV text file import , data migrating , exporting only new records

Copying a MYSQL database

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
11 years 10 months ago #2093 by FlowHeater-Team
Copying a MYSQL database was created by FlowHeater-Team
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.

Please Log in or Create an account to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
11 years 10 months ago #2094 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Copying a MYSQL database
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)
Code:
@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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.288 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en