Bug #61566 Unknown option '-û' when using '-u' on command-line

• Submitted: 20 Jun 2011 2:30
• Modified: 20 Jun 2011 12:16
• Reporter: LUI JAMES
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.5.13
• OS: Other (Win7 (home premium) 64 bit)
• CPU Architecture: Any
• Tags: input file, unknown option

[20 Jun 2011 2:30] LUI JAMES

Description:
Hi,

My problem is when I'm trying issue command below:

D:\www\legion\mysql>mysql -u username --password=password < input_110614.sql
mysql: unknown option '-û'

already tried to use "--user=username" option but still the same error.

I'm using the following:
OS: Windows 7 (Home premium)
MySQL Server version: 5.5.13 MySQL Community Server (GPL)

How to repeat:
on commandline, issue mysql with input file

[20 Jun 2011 6:25] MySQL Verification Team

does this work?

mysql.exe --no-defaults -u username --password=password < input_110614.sql

If yes, then please upload my.ini or my.cnf.  If not, then upload input_110614.sql
I couldn't repeat it on my system;

[20 Jun 2011 6:32] LUI JAMES

I managed to run it except that I have to type it to command-line manually

I was trying to run multiple SQL files (about 5), using copy and paste method.  The issue may be related to with the other stuff and not directly to mysql.

[20 Jun 2011 9:19] MySQL Verification Team

from where did you copy and paste it?  was it some utf8 editor that might have put extra characters on the clipboard ?  if you manage to get more details, or can upload a file that we can copy/paste from with instructions that would be good.

[20 Jun 2011 9:33] LUI JAMES

sample file

Attachment: sample.ods (application/vnd.oasis.opendocument.spreadsheet, text), 8.29 KiB.

[20 Jun 2011 9:45] LUI JAMES

I have attached a sample file.

Here's what I exactly did.

Apps used:
1: Windows command-line (cmd)
2: OpenOffice (scalc)

1: Using command-line - issued "dir" command, copy the resulting file list and paste it to column 2 on SCALC (note: was prompted of encoding... I chose Unicode)
2: on SCALC, put "mysql -u username --password=password < " on the first column
and "=concatenate(A1;B1)" on the third column to have the exact commands to be issued on for mysql.

I hope this help.

Regards,
James

[20 Jun 2011 12:15] MySQL Verification Team

I got a similar problem like this:

I:\mysql\5.5\5.5.13\mysql-5.5.13-winx64\bin>mysql -u username –password=password < Sqlfile_4.sql
ERROR 1049 (42000): Unknown database 'ûpassword=password'

In the .ods file, you wrote  "mysql -u username –password=password < "
instead of "mysql -u username --password=password < "

Notice the difference. your dash is 0x96 "en dash" and you only have one of them. I have two 0x2D "hyphen-minus"  characters for the password option.

So, this is not a bug.