Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Windows scheduler not actively backing up MySQL dump

 
Ahsan Bagwan
Ranch Hand
Posts: 254
1
Java MySQL Database Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My primary environment is Windows where I'm making use of Scheduled Tasks for automating the running of my batch file. I've set the scheduler to spit the dump file each day at 06:30 PM.

However, I've discovered recently that it has stopped running the scheduled tasks. It did run for a few days for that matter. The content of my .bat is as follows:

mysqldump -h localhost -u root -p***** -R schemaname > "D:\mysqldumpbackup.sql"

Has anyone faced a similiar problem? Am I missing something trivial?
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The scheduler should list the date a task was run for the last time. Is this date for your task several days old? If it is, the problem is with scheduler itself, at this point I'd try to review the properties of the task and perhaps also Windows Event log to see whether anything is amiss.

If the scheduler seems to be running your task, the problem might lie in the BAT file itself. Try to run the BAT file from the console. If it doesn't work, you'll obviously have to fix your BAT file. If it does work, try to run the scheduled task manually from the Task Scheduler (Run command on the context menu). If the BAT File doesn't work when run from the scheduler, my bet would be that it runs in a different security context and it's causing problems. You might want to change the user account under which the Scheduler runs the task in the Properties options - for example, set it to your own user account.
 
Ahsan Bagwan
Ranch Hand
Posts: 254
1
Java MySQL Database Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Turns out the password in the dialog that appears on clicking Properties in context menu is to be changed if and when you change the system password.
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The "password has changed" issue bites me every 90 days... :-)
 
Paul Clapham
Sheriff
Pie
Posts: 20955
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What's more fun is when you have automated systems connecting to the application. When its password changes the first thing that happens is that they can't connect, and within seconds after that they have retried 10 times and the application's user ID has been frozen by the security system.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic