The GoTo Community is currently experiencing some technical issues affecting new posts and comments. You may need to reload the page you are on before you can post a comment. We are actively working with our service provider and apologize for the frustration.

Forum Discussion

KevinA's avatar
KevinA
Retired GoTo Contributor
16 years ago
Solved

One2Many Script Repository

Welcome to the LogMeIn Central Script Repository!   What is it? A library of scripts to help you execute automated tasks and manage LogMeIn Pro² computers without having to access them manually. ...
LouieLouI's avatar
LouieLouI
New Member
13 years ago

Here's a handy batch file for MySQL Databases (selects, updates, etc):

 

 

rem - Note SQL Statements that generate files should have their outfile deleted first!
set sqlcommand="Your SQL Statement Here"

rem - Nav to your MySQL / MariaDB Instance, edit path to your preference:
cd d:\
cd "d:\mariadb 5.5\bin\"

rem - Pipe your SQL command into a txt file:
echo %sqlcommand% > sql.txt

rem Execute your SQL, provide username and password as arguments to the batch file:
mysql --user=%1 --password=%2 --database="database name" < sql.txt

Might be messy, but sure as heck effective!

 

Added Bonusl when setting up the task, specify the text file (if one is created by your statement) as the log file in LMI, and now you can view the resulting file in LMI.  (Feature Suggestion: email the log file along with the task summary emails!)

 

Also in hindsight, the database name could be another batch file argument!