Raman Singh
asked on
HeidiSQL - Batch File
Hi,
I am trying to create a batch file which executes a query on HeidiSQL.
I created a text file containing the piece of SQL which updates a table in the database. The batch job (attached as test.txt) was then created and be scheduled to run on the first of every month.
If I run test.txt I get an error which I have also attached as BATCHERROR.png.
I am fairly new to HeidiSQL and batch jobs so spent most of my time on google trying to find a solution.
Thanks
batcherror.PNG
test.txt
I am trying to create a batch file which executes a query on HeidiSQL.
I created a text file containing the piece of SQL which updates a table in the database. The batch job (attached as test.txt) was then created and be scheduled to run on the first of every month.
If I run test.txt I get an error which I have also attached as BATCHERROR.png.
I am fairly new to HeidiSQL and batch jobs so spent most of my time on google trying to find a solution.
Thanks
batcherror.PNG
test.txt
Well, there is no MySQL instance listening on localhost. Have you installed one correctly? And if so, have you entered it correctly?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.