Posted on: 01/11/03 12:03pm
By: Anonymous (Anonymous)
I would like to automatically backup the entire GL folder as well as the database each evening, anybody know of a good tool to handle this?Thanks!
Automating GL Backup on Windows?
Posted on: 01/11/03 03:06pm
By: Dirk
I would guess there is some equivalent for cron on Windows? If so, you could use this script[*1] .
bye, Dirk
Automating GL Backup on Windows?
Posted on: 01/11/03 04:21pm
By: nurseryboy
Hello,
If you can run .bat files on your server, and can set things in the Task Scheduler, then there is a pretty easy way.
You can create a .bat file with this code in it:
@echo off
cd "c:mysqlbin"
mysqldump --user=username --password=password --all thedatabase > c:/wherever/thesql.sql
Just point the cd to the directory where mysqldump.exe is, change username to your username, and password to your password, thedatabase to the database you want to backup, and the .sql location to where ever you want the sql file to be created. (Change the forward slashes to backslashes.. GL doesn't seem to like backslashes, so I couldn't use them).
Then, have Window's Task Scheduler run the file whenever you want. Im sure there is a way to have msdos set a different name for the file each time it does that, but I am no msdos expert.
Hope that helps. I tried it out and it worked great for me.
Matthew
Automating GL Backup on Windows?
Posted on: 01/11/03 04:44pm
By: Anonymous (Anonymous)
This looks good, is there a variable I could use to write the date in to the file name? I would like to keep multiple backups..
Automating GL Backup on Windows?
Posted on: 01/12/03 07:08am
By: nurseryboy
I have no idea, but hopefully someone else does
Matthew
Automating GL Backup on Windows?
Posted on: 01/15/03 09:11pm
By: Anonymous (Anonymous)
After toying with the batch files a bit, I have a batch file that you can setup in Scheduled Tasks to dump your gl database complete with the correctly formatted (date included) file name into your geeklog backups folder (so that you can see it when you look at the DB admin page).
Place
these contents[*2] into a file called
DateTime.bat
.
Place
these separate contents[*3] into a file called
glbackup.bat
.
Edit
glbackup.bat
to include your mysql user and password and db and correct path to where you want to store the two batch files.
Setup a Scheduled task to run
glbackup.bat
and you should be ready to go!
Re:Automating GL Backup on Windows?
Posted on: 01/10/04 01:11pm
By: emagin
Could this be set up to back up multiple MySQL databases on Win32 windows?