Thanks for the reply - that was indeed a typo. I resolved this buy making these 
changes:

mysqldump --defaults-extra-file="c:\sql\dump.cnf" dname > c:\loc

with my cnf containing:

[client]
user = user
password = pass

Looks like I misplaced "" and or [client] / [mysqldump] in the cnf

Thanks



-----Original Message-----
From: Johan De Meersman [mailto:vegiv...@tuxera.be] 
Sent: vrijdag 29 januari 2016 15:06
To: Harrie Robins <har...@eyequestion.nl>
Cc: MySql <mysql@lists.mysql.com>
Subject: Re: my.cnf authencication

----- Original Message -----
> From: "Harrie Robins" <har...@eyequestion.nl>
> Subject: my.cnf authencication
> 
> mysqldump --defaults-file  dbase > c:\sql\dbase.sql 2>> c:\log.tct

Might just be a typo in your mail, but you'll need to actually pass the 
defaults-file, too: --defaults-file=c:\sql\dump.cnf .

I think there may be another typo somewhere, too, as it seems to think that 
lts-file is the user you're passing. I'm wondering if you haven't accidentally 
put only a single - in front of defaults-file.


> 
> 
> My log shows:
> 
> mysqldump: Got error: 1045: Access denied for user 
> 'lts-file=c:\sql\dump.cnf'@'localhost' (using password: NO) when 
> trying to connect
> 
> It looks like credentials are not filled in!?
> 
> Regards,
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

--
Unhappiness is discouraged and will be corrected with kitten pictures.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to