Bug #65891 Erreur mysqldump.exe with Unknown suffix
Submitted: 13 Jul 2012 9:38 Modified: 13 Jul 2012 10:42
Reporter: OLIVIER BARTHOULOT Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version:5.1 To 5.6 OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: Erreur suffixe, mysqldump.exe

[13 Jul 2012 9:38] OLIVIER BARTHOULOT
Description:
I Have a serious problem since 3 day ago.

I can't save or restaure data with mysqldump.exe

the message following :

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqldump
Unknown suffix 'd' used for variable 'port' (value 'd3306')
mysqldump: Error while setting value 'd3306' to 'port'

I have already modify all file ini (with stop and restart server) but the same message come 

an extract from my.ini :
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]

port=3306

[mysql]

default-character-set=utf8

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

How to repeat:
For me, just launch mysqldump.exe from the console windows ("cmd.exe")
[13 Jul 2012 10:12] Valeriy Kravchuk
I have two ideas:

1. Try to search with OS level tools for any (or just *.ini) file on the entire machine with "d3306" in the content.

2. Try to run:

mysqldump --no-defaults --version

and send me the output.
[13 Jul 2012 10:37] OLIVIER BARTHOULOT
//[13 Jul 10:12] Valeriy Kravchuk
// I have two ideas:
// 
// 1. Try to search with OS level tools for any (or just *.ini) file on
// the entire machine with "d3306" in the content.
//
// 2. Try to run:
//
// mysqldump --no-defaults --version
//
// and send me the output.

The first way is the good. I search only int the "data" and "mysql" repertory. But I discover an another "my.ini" int the windows repertory with 'd3306'.
I have modify too this file and it seemms good.

Thanks for your help. I will search on the all HDD now.
[13 Jul 2012 10:42] Valeriy Kravchuk
So I assume this problem was not a result of any bug in MySQL code.