homepage Welcome to WebmasterWorld Guest from 67.202.56.112
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
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




msg:1579635
 6:06 pm on Sep 5, 2005 (gmt 0)

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




msg:1579636
 5:28 pm on Sep 6, 2005 (gmt 0)

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




msg:1579637
 9:06 pm on Sep 6, 2005 (gmt 0)

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




msg:1579638
 9:30 pm on Sep 6, 2005 (gmt 0)

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




msg:1579639
 3:15 am on Sep 7, 2005 (gmt 0)

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




msg:1579640
 4:25 pm on Sep 7, 2005 (gmt 0)

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




msg:1579641
 10:01 pm on Sep 7, 2005 (gmt 0)

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




msg:1579642
 10:14 pm on Sep 7, 2005 (gmt 0)


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 ;)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved