mysqlc.exe missing - how to have readline then on windows

Iīm running mysql 4.1.13 and want to have readline capabilities

[phoenix_fly]

Hello folks,

I am tired of not having the up-arrow repeat-command function in windows and am trying to find a way to get it.
Iīve read if I run mysqlc.exe, instead of mysql.exe, I will get it, but the problem is that there is no mysqlc.exe in my \bin directory. And not even the cygwinb19.dll library, wich I read must be copied to the \windows\system directory in order mysqlc.exe could run. (like if I had it!)

Please let me know if you guys found any solution for this.

Thanks!

phoenix_fly

[coopster]

To use the command line on Windows I create a cmd.exe shell and use that. It does not retain commands from session to session (as soon as you close your current session your buffer is cleared).

As far as mysqlc.exe, it is deprecated from MySQL >= 4.1. Beginning with MySQL 4.1.8, it is no longer included in MySQL Windows distributions.
Testing The MySQL Installation [dev.mysql.com]

[phoenix_fly]

Hello Coopster,

In fact, I followed your link and say that itīs been abandoned.

But Iīm very interessted in the cmd.exe solution you mentioned. Is that something easy to do? Can be found somewhere this file? Iīm know nothing about .exe crafting.

Thanks

phoenix_fly

[coopster]

It's quite simple, really. Create a Windows command prompt window as a shortcut to c:\mysql\bin. At the command prompt you can start using the mysql command line commands. You can right click on the shortcut and set all kinds of other options for the command window. In the "Options" tab itself you will find the "Command history" options.

[phoenix_fly]

Sorry coopster, I didnīt get it.
You mean having a 'MS-DOS prompt' shortcut?
I didnīt find this 'options' tab.

If you can, please give me more details... Thanks

[coopster]

Exactly.
Create a shortcut with a target of

%SystemRoot%\system32\cmd.exe

I've found the *easy* way to do this is to copy the already existing shortcut on the

Start Menu > All Programs > Accessories > Command Prompt

to your desired location, be it your desktop, Quick Launch Toolbar ... whatever. Then modify that Shortcut by right-clicking it and choosing Properties from the pop-up context menu. In the Shorcut tab you'll notice the Target looks like (or much like) the example given earlier. The "Start in:" textbox is where you will change the path to the path in which your MySQL binary exists. I happened to installed mine in the root:

c:\mysql\bin

Next tab over then is your Options tab and that is where you can modify the information I referred to. I also modified my Colors so I can quickly recognize the MySQL shell that I have open (I changed the default icon to the MySQL icon as well, so I can tell it apart from my usual Command Prompt).

[phoenix_fly]

I know why I canīt see this 'options' tab. Im under win 98! You're probably XP right? Guess I will have to go on without readline capabilities, just typing my fingers out here, query after query.

I donīt understand why mysql discontinued this mysqlc.exe. Iīm almost going back my mysql version to get it...

Thanks for the effort anyway, coopster.

Cheers

phoenix_fly

[coopster]

I donīt understand why mysql discontinued this mysqlc.exe. Iīm almost going back my mysql version to get it...

mysqlc was intended for use primarily with Windows 9x/Me. It does not support the updated authentication protocol used beginning with MySQL 4.1, and is not supported in MySQL 4.1 and above.

Yes, you are correct about command.exe versus cmd.exe. The former is an old DOS carryover.

You should really think about updating that OS -- it's a tad old now ;)