Re: Scheduled Backups Issue...

2006-07-05 Thread cnelson
 I am attempting to set and and schedule automated MySQL backups 
 using the MySQL Administrator Tool downloaded from mysql.com.  All 
 of my back ups work fien when I perform them manually.  However 
 none of the scheduled backups ever get done.  I am not sure where 
 the glicth is but here is what the details are...
   
   
  I have a remote server (*nx box colocated at an offsite 
 location).  MySQL 5.0.21 is on the box.
  Logged in as root to the MySQL.
   
  Created a Backup Project.
  Added Schema to it.
  Under Advanced left all options at default EXCEPT changed to Lock 
 All Tables.
  Set a local path to save the back ups.
  Set backup to run daily.
  Saved and said to use the root as the user to perform the back up.
   
  Nada...
   
   
  Please advise if I am being a toal DFU or what.

There's an issue with MySQL Administrator creating bad scheduled items
in 'Windows.  I found a note about it but not a bug report or a fix. 
Try going to the Windows Scheduler, opening the backup item and removing
-c (including the quotes) from the middle of the command to run.  (I
found it helpful to copy the command to Notepad, edit it there, and copy
back as it is quite long.)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Scheduled Backups Issue...

2006-07-01 Thread JB
I am attempting to set and and schedule automated MySQL backups using the MySQL 
Administrator Tool downloaded from mysql.com.  All of my back ups work fien 
when I perform them manually.  However none of the scheduled backups ever get 
done.  I am not sure where the glicth is but here is what the details are...
   
   
  I have a remote server (*nx box colocated at an offsite location).  MySQL 
5.0.21 is on the box.
  Logged in as root to the MySQL.
   
  Created a Backup Project.
  Added Schema to it.
  Under Advanced left all options at default EXCEPT changed to Lock All Tables.
  Set a local path to save the back ups.
  Set backup to run daily.
  Saved and said to use the root as the user to perform the back up.
   
  Nada...
   
   
  Please advise if I am being a toal DFU or what.
   
   
  Thanks,
  DB


-
Yahoo! Music Unlimited - Access over 1 million songs.Try it free.