Windows – How to run thesql prompt in windows powershell ISE

MySQLpowershellwindows

I want to use PowerShell ISE tab to be able to connect mysql client and tun sql statements, however as soon as I connect to client using following command –

>mysql.exe --defaults-file=<abc.xnf> --datadir=<xyz>

mysql prompt doesn't appear instead console behaves as a continuous process running. Does anyone know how can get mysql prompt ?

Best Answer

Unfortunately, the ISE is not a full-on console host, and does not handle interactive console applications properly. If you try to run a built-in interactive console app, like netsh.exe, you'll get an error like this:

Cannot start "netsh". Interactive console applications are not supported. 
To run the application, use the Start-Process cmdlet or use "Start PowerShell.exe" from the File menu.
To view/modify the list of blocked console applications, use $psUnsupportedConsoleApplications, or consult online help.

Other commands, like mySQL, will just hang indefinitely, since the ISE cannot properly handle user input to the application. You can read more about this limitation here: PowerShell Team blog.

Related Solutions

Windows – How to find what process is holding a file open in Windows

I've had success with Sysinternals Process Explorer. With this, you can search to find what process(es) have a file open, and you can use it to close the handle(s) if you want. Of course, it is safer to close the whole process. Exercise caution and judgement.

To find a specific file, use the menu option Find->Find Handle or DLL... Type in part of the path to the file. The list of processes will appear below.

If you prefer command line, Sysinternals suite includes command line tool Handle, that lists open handles.

Examples

c:\Program Files\SysinternalsSuite>handle.exe |findstr /i "e:\" (finds all files opened from drive e:\"
c:\Program Files\SysinternalsSuite>handle.exe |findstr /i "file-or-path-in-question"

Windows PowerShell – How to Diff Two Text Files

Figured it out myself. Because Powershell works with .net objects rather than text, you need to use get-content to expose the contents of the text files. So to perform what I was trying to do in the question, use:

compare-object (get-content one.txt) (get-content two.txt)

Best Answer

Related Solutions

Windows – How to find what process is holding a file open in Windows

Windows PowerShell – How to Diff Two Text Files

Related Topic