Page 1 of 1

tmydump: can i fill in - - where option?

Posted: Mon 02 Jun 2014 16:24
by vindac
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!

Re: tmydump: can i fill in - - where option?

Posted: Tue 03 Jun 2014 11:22
by PavloP
To obtain a dump of a part of table records using the TMyDump component, use the BackupQuery method. For example:

Code: Select all

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

Re: tmydump: can i fill in - - where option?

Posted: Tue 03 Jun 2014 11:30
by vindac
Thank you very much! :D

Re: tmydump: can i fill in - - where option?

Posted: Tue 03 Jun 2014 13:36
by PavloP
Feel free to contact us if you have any further questions.