Actually, it's even easier than that:
put "/usr/local/mysql/bin/mysql -u username -p password --execute='show
databases'" into tCmd
put shell(tCmd)
The only minor downside is to get the TRUE list, you need to clean up the
result a bit (the first line just says "Database" and the last line is
empt
If you put "SHOW DATABASES;" in a text file on the target
machine then you can execute the following statements
(watch for line breaks):
put "/usr/local/mysql/bin/mysql -u username -ppassword <
'/usr/local/ShowDatabases.txt'" into myCommand
put shell(myCommand) into message box
That wor
HI Joe,
You are correct and this has help solve my problem.
regards,
Glen
On Tue, May 25, 2010 at 10:32 AM, Joe F. wrote:
> This script would make promysql evaluate to "mysqlshow - u nrl -pnrl1"
>
> On May 23, 2010, at 3:36 PM, Glen Bojsza wrote:
>
> > Hello,
> >
> > Has anyone successfully
This script would make promysql evaluate to "mysqlshow - u nrl -pnrl1"
On May 23, 2010, at 3:36 PM, Glen Bojsza wrote:
> Hello,
>
> Has anyone successfully used either "open process" or "get shell()" to list
> the databases available on a machine.
>
>> From the command line I do the following