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
16 years agoRetired GoTo Contributor
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. ...
- 8 years ago
https://github.com/knix15/LogMeIn-One2Many-Community-Scripts/
Scripts can be found here as well for better future organization.
LouieLouI
13 years agoNew Member
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!