Schedule Backup Question

[Frizzled]

Hello –

First off, thank-you for this awesome program. I'm a paid user (SSH tunneling rocks!) and this is one of the best programs I've used for MySQL.

I've gone through a few pages of searches on this forum about backing up a database, but I couldn't find one that quite answered this question.

I have a database that I'd like to export nightly as a SQL dump. I've used Power Tools -> Schedule Backups to setup a nightly backup of the database, but it looks like it's going to either overwrite the file when the backup happens or append each backup to the same file.

Is there anyway the date can be appended to the backup's name so that each day's backup is its own unique file?

(ie. mydatabase_08.03.05.sql, mydatabase_08.04.05.sql, mydatabase_08.05.05.sql … etc.)

If there's anyway to do this I would really appreciate a heads-up. I'm going to need to dig through several days worth of backups in the future and it's going to save me a huge headache if I can jump right to a certain day and start from there.

Thanks for your time,

_f

[peterlaursen]

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!

[peterlaursen]

Please note that I edited a little bit above!

[Frizzled]

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

[peterlaursen]

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.

[kengaun]

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

[Ritesh]

This feature is already in the TO-DO list.

It will be implemented in v4.2 which is another 3-4 weeks away.

[Ritesh]

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&#038;

[Frizzled]

Awesome! 😀

Thanks Ritesh!

[Author]

Posts