Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Copying a MYSQL database

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
13 years 2 weeks 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 to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
13 years 2 weeks 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 to join the conversation.

Time to create page: 0.307 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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