Devart Forums

Hello collegues,

we have a MySQL database with some views.

I get nice dump after I call:
Some days before we changed views structure and now I execute the same procedure to create a dump file.

And now I have an interesting problem with views creation order.

We have next views (alphabetical order): Problem is geraetecounter view selects some data from geraete_full_short.
So geraetecounter must be create after geraete_full_short.

TUniDump provides me dump file with views creation order as below:
So we have a problem to load this dump file back to a database.

What should we do?


Thanks.

PS:
mysqldump.exe creates file with correct order.
SQLYog creates file with correct order.

You can use the TUniDump.TableNames property to specify the concrete tables and views for backup. The tables and views will be backup in the order in which they are listed in this property.

Hello,

thanks for the answer.

In my case it is so:

we have database administrators and developers. It would be good if developers can be independent from DBA actions.

Why should developers know about dependencies between views?
They ONLY want to make dump of the database with correct documented API provided by Unidac.

It is quite possible with other tools.
Maybe have we any workaround here with perfect Unidac?

Thanks.

UniDAC backups tables and views in the sequence corresponding to their order in the query result to the system tables of MySQL server.
If you want us to change this behavior, please write about it on our User Voice forum: https://devart.uservoice.com/forums/104 ... 939-unidac. If your proposal gains enough votes we will consider a possibility of its change.

ok, it is clear.

Thanks a lot for support.

We have realized it using mysqldump.exe and mysql.exe.

Thank you for your interest to our product.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.