Looks there is problem with the file, i'm pointing to. When i created a new .monetdb file and setting it to the path, fixed the issue.
Thank you.
Regards, Aravind.S
-----Original Message----- From: users-list [mailto:users-list-bounces+aravind.reddy=altair.com@monetdb.org] On Behalf Of Aravind S Reddy Sent: 14 July 2015 20:03 To: Communication channel for MonetDB users Subject: RE: Provide --password option for msqldump tool
Stefan,
Thank you for the quick reply. I have set the ENVIRONMENT variable as follows in my WINDOWS7 system and trying to run the mclient
> set DOTMONETDBFILE="c:\Program Files\MonetDB\MonetDB5\etc.monetdb"
where ".monetdb" have the following entries user=<username> password=<pwd>
After this, while launching mclient i'm seeing error as below
>mclient failed to open file '(null)': Invalid argument user(win32):
Any idea, whats going wrong here?
Regards, Aravind.S
-----Original Message----- From: users-list [mailto:users-list-bounces+aravind.reddy=altair.com@monetdb.org] On Behalf Of Stefan Manegold Sent: 14 July 2015 19:37 To: Communication channel for MonetDB users Subject: Re: Provide --password option for msqldump tool
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