Hi Aravind, providing a (plain-text) password on the command line is dangerous, and other users might then see your password in the process table. Hence, MonetDB tool do not offer that option. Instead, you can provide the password in the .monetdb file (keeping it readble only for yourself!) as described for mclient; cf., https://www.monetdb.org/Documentation/mclient-man-page Though admittedly not documented properly, Msqldump should use the .monetdb files just as mclient does. Best, Stefan ----- On Jul 14, 2015, at 4:01 PM, Aravind S Reddy aravind.reddy@altair.com wrote:
Hello Team,
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way.
But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.
Regards,
Aravind.S
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |