Schedule Backup Question

This topic is empty.

Viewing 7 reply threads

Author

Posts
- August 4, 2005 at 5:15 am #18845
  
  peterlaursen
  Participant
  
  actually there has been a similar request recently. So maybe the save options are not flexible enough for some users.
  
  What you can do by now is exexuting SJA from a windows .bat file and schedule the execution of the batfile insted of SJA itself. A simple example:
  
  Code:
  
  copy newbackup.sql oldbackup.sql
  SJA newbackup.xml
  
  thus you'll always have two backups
  
  You can of course expand the example to have 7 like
  
  Code:
  
  delete 7backup.sql
  rename 6backup.sql 7backup.sql
  rename 5backup.sql 6backup.sql
  ….
  rename newbackup.sql 1backupsql
  SJA newbackup.xml
  
  Thus the name 4backup.sql will tell you that this is a backupfile 4 days old if you do backup once a day.
  
  I honestly don't know if the weekday or date can be fetched into a bat file and be used for naming another file. I'll do some research on it if requested!
- August 4, 2005 at 8:46 am #18846
  
  peterlaursen
  Participant
  
  Please note that I edited a little bit above!
- August 4, 2005 at 6:33 pm #18847
  
  Frizzled
  Member
  
  Hmmm,
  
  Thanks for the reply.
  
  It's not quite what I was hoping for. <_< I'd rather have all the data, instead of just the last three days. I take it if I choose to append each backup to the same file, then I can save all the data. Unfortunately, that sounds like it's going to be a major pain when I try to sort through it to find a certain day's backup. I'll dig around as-well to see if there's some way to rename the file automatically, thanks for your help 😀 _f
- August 4, 2005 at 6:44 pm #18848
  
  peterlaursen
  Participant
  
  Quite a lot to look at here:
  
  http://lists.gpick.com/pages/File_Rename_Tools.htm
  
  If programs can be started from command-line you could easily build an apporpriate .bat-file.
- August 9, 2005 at 6:00 am #18849
  
  kengaun
  Member
  
  Hi SQLyog,
  
  Would like to find out whether SQLyog include this in the enhancement list ?
  
  Currently MySQL Administrator Tool is able to provide such features. Each backup file is ended with datetime.
  
  Thanks,
  
  Kengaun
- August 9, 2005 at 6:11 am #18850
  
  Ritesh
  Member
  
  This feature is already in the TO-DO list.
  
  It will be implemented in v4.2 which is another 3-4 weeks away.
- September 22, 2005 at 5:24 pm #18851
  
  Ritesh
  Member
  
  v4.2 BETA 2 has been released that implements the above feature.
  
  http://www.webyog.com/forums/index.php?sho…63&st=0&p=7278&
- October 13, 2005 at 5:58 pm #18852
  
  Frizzled
  Member
  
  Awesome! 😀
  
  Thanks Ritesh!
Author

Posts