I created a modified an existing script located the examples folder. F:\Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\Examples.
this is the code that we are using. it backups up MYSQL to a other folder. I have it scheduled to run at every night using a schedule task. Hope this helps. I am still working on a bat file that will look in that folder adn delete files that are older than a few days so the folder doesn't get too large.
The .bat names the file with at date.
Set DateLabel=%date:~10,4%%date:~4,2%%date:~7,2%
Set backup_file_name=Shorewarebk_%DateLabel%.sql
"F:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysqldump.exe" --user root --password=shorewaredba --databases shorewarecdr --routines --single-transaction>"F:\\Daily_backups\\%backup_file_name%
|