| 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: | |
| 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 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.
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")