Sorry I wasn't clear. I understand it's a DELETE statement, I don't understand how to use this with macro scheduler. I could have 50 - 100 delete statements. I usually create a txt file with all my DELETE commands, ftp it to the server, then use Macro scheduler to SSH in and run mysql in batch mode ...

I have a file named runsql.txt that is created each night and holds SQL statements, such as: DELETE FROM table1 WHERE ID = '1'; DELETE FROM table1 WHERE ID = '15'; DELETE FROM table1 WHERE ID = '56'; Normally, I FTP the file to the server and run MySql in batch mode to process the commands. I have b...

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

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?

I've been using Macro Scheduler for about 3 years now. My latest project is a routine to update and backup the MySql database on my remote web server nightly.
Works Great!

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 wil...

Thanks, support. Seems to work fine now!

Support, that may be what I need. How can I have MyString contain an entire text file I tried this, but got an error: VBSTART Function CountPatterns(patrn, strng) Dim regEx, Match, Matches Set regEx = New RegExp regEx.Pattern = patrn regEx.IgnoreCase = True regEx.Global = True Set Matches = regEx.Ex...

I'm a newbie here, but I'm trying to use Readfile to count the number of times the word ON is in a text file, IF the number is >2, then do something. This is further complicated by the fact that the word NONE is in the file, so I really need to count ON, if you get my drift.

Any help?