Page 1 of 1

Using TMyDump within an Intraweb application ...

Posted: Thu 17 Feb 2011 20:29
by Pete B
Hi
I'm trying to get to grips with using TMyDump in an Intraweb application which is running on a remote IIS machine. To be honest I'm a bit lost. I can get a SQL dump on to the IIS server machine itself but I thought that was more like what TMyBackup was for.
What I'm really trying to do is get an Intraweb application client user to be able to download a SQL dump to their client machine through their browser. This really needs something such as a Savefile dialog, then the ability to download the SQL dump to the chosen folder but I'm struggling to get this functionality at all.
Can anyone advise on the way to achieve this please ? ... I can't see through it at the moment.
... and then of course there's always the restore !!! :)

best regards

Pete B.

Posted: Fri 18 Feb 2011 04:31
by Justmade
TMyBackup are doing backup in MySQL Server Machine.

TMyDump are doing backup in MyDAC Application (In your case the IIS Server Machine).

Maybe you are using the same machine for them but one can use different machine for the two role. So they are different (in addition to the fact that the backup mechanism is completely different).

If you want your user to get the dump file, you have to send the file to the browser for the user to save. And restore load file from browser machine to IIS and then use TMyDump to restore.

See Intraweb samples, there are example of how to send file to browser and get file also.

Posted: Fri 18 Feb 2011 09:09
by Pete B
Justmade: thanks for the advice and the insight, it's appreciated.
I will investigate the Intraweb samples much more closely to try and achieve the functionality I'm after.

cheers