MySQL Full Dump

[a.alekizoglou]

For MySQL the UniDump does not export triggers, procedures and functions. I've made some changes on MyServicesUni.pas to support exporting those objects as well.

AlexP, let me know how to send them to you, so that you can study if you want to include them in the next UniDAC version.

[stlcours]

Just Post here and he will see. thanks.

[a.alekizoglou]

Well, I think it would not be appropriate to post a 1800 lines of code MyServicesUni.pas has, just to show some changes.

AlexZ might want me to send an email with the file.

[maltseff]

a.alekizoglou
Could you share this code?

[a.alekizoglou]

Sure,

here it is a zip file containing only MyServicesUni.pas in UniDAC\Source\UniProviders\MySQL\MyServicesUni.pas Changes are marked with \\QUALISYS

Beware, MySQL user must have access to mysql table in order to read procedures and triggers. This might have been the reason why DevArt hasn't implemented that in their code

https://dl.dropboxusercontent.com/u/6632864/UniDAC.zip

[maltseff]

Ok. Thanks.
By the way it would be good to add props like
prBackupTriggers, prBackupStoredProcedures in order to make this configurable.
Anyway this is a good candidate for adding to UniDAC.

I've voted already for the idea
http://devart.uservoice.com/forums/1046 ... at-it-can-

[Nanolo]

Escuse me for asking, is this solution still avaiable? The link do not works. Doesn't seem to be possible, for the moment, to implement it with the original component. Am I misunderstanding something?

[a.alekizoglou]

Nanolo,

I have made changes to MyServicesUni.pas to backup Triggers and Stored Procs/Functions.

You are correct the dropbox is not working. I suppose devs should have implemented this functionality to newer versions of UniDAC.

[ViktorV]

At the moment UniDAC, unlike MyDAC, doesn't support this functionality. If the proposal https://devart.uservoice.com/forums/104 ... at-it-can- gets a lot of votes we will consider its implementation.