Help with MySql

mikeyd03 · Post by **mikeyd03** » Fri Apr 14, 2006 4:01 pm

I'm using Macro Scheduler 8.01 to update a MySql database in batch mode.
I use it to upload a file with insert and update statements to a server, then connect in with SSH (using putty) then run the file. everything works great! My question - errors!
For instance, for a duplicate record a message will be on the screen, like "ERROR 1062 at line 2: Duplicate entry".
Is it possible to "read the screen" to see if there is an error message, and if so stop the macro?

Bob Hansen · Post by **Bob Hansen** » Fri Apr 14, 2006 8:57 pm

The quick answer is YES.

Use the IfWindowOpen command to break out and process the contents

Code: Select all

Label>DoStuff
DoStuff
IfWindowOpen>ErrorWindowName*,ReadErrorMsg,DoStuff

Label>ReadErrorMsg
Process contents of window, depending on content.  Pehaps use a group of
FindWindowWithText>Error 1,1,Error1

If>Error1<>"NOT FOUND",%Error1%,DoOtherStuff

Label>Error1
Do stuff reacting to error code1
Goto>DoStuff

Label>DoOtherStuff

====================================
NOTE: the syntax above is not correct, just a quick sample of how this might be handled with some of Macro Scheduler's commands.

mikeyd03 · Post by **mikeyd03** » Thu Apr 27, 2006 9:57 pm

I'm using putty.exe for an SSH connection.
I've been testing this and it seems to me that macro scheduler will detect the putty window open, but will not read the text in it.

Anyone using Macro Scheduler and SSH?

JRL · Post by **JRL** » Thu Apr 27, 2006 10:17 pm

Doesn't Putty run in a DOS window?

Try the technique in this thread:

Good Luck,
Dick

Post by **Marcus Tettmar** » Fri Apr 28, 2006 7:41 am

Why don't you install the MySQL ODBC drivers and then you can do all the SQL within the script directly and will not need to manipulate SSH.

mikeyd03 · Post by **mikeyd03** » Fri Apr 28, 2006 6:22 pm

Don't think I can use ODBC, no external Mysql ports open.