FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Copying a MYSQL database

Copying a MYSQL database 7 years 9 months ago #2093

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 314
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.

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.

Re:Copying a MYSQL database 7 years 9 months ago #2094

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 314
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.

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

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.
  • Page:
  • 1

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en