tmydump: can i fill in - - where option?

vindac · Post by **vindac** » Mon 02 Jun 2014 16:24

Hi,
I want the use the mydump component, but I need to use the --where option which is provided by mysqldump. Where can I set this?

thanks!

PavloP · Post by **PavloP** » Tue 03 Jun 2014 11:22

To obtain a dump of a part of table records using the TMyDump component, use the BackupQuery method. For example:

MyDump1.BackupQuery('select * from emp where empno > 7000 ');

The result will be put into the SQL property of the TMyDump component.
More details at http://www.devart.com/mydac/docs/index. ... tring).htm

vindac · Post by **vindac** » Tue 03 Jun 2014 11:30

Thank you very much!

PavloP · Post by **PavloP** » Tue 03 Jun 2014 13:36

Feel free to contact us if you have any further questions.

Devart Forums