Using TMyDump within an Intraweb application ...

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Pete B
Posts: 15
Joined: Sat 13 Feb 2010 17:13
Location: NORWICH, UK

Using TMyDump within an Intraweb application ...

Post by Pete B » Thu 17 Feb 2011 20:29

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.

Justmade
Posts: 108
Joined: Sat 16 Aug 2008 03:51

Post by Justmade » Fri 18 Feb 2011 04:31

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.

Pete B
Posts: 15
Joined: Sat 13 Feb 2010 17:13
Location: NORWICH, UK

Post by Pete B » Fri 18 Feb 2011 09:09

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

Post Reply