A nice backup for Kayako

[rohmelec]

I looked all over this forum and all over the web and finally just created this little thing which works great for backups.

To create this backup just open notepad paste in the following code
----------------------------------------------------------------------
@echo off
echo Running dump...
"c:\program files\MySQL\Mysql server 5.0\bin\mysqldump" -uroot -p<your password here without the brackets> --result-file="c:\Kayako_Backup\Kayako_backup.%DATE:~0,3%.s ql" kayako_suite
------------------------------------------------------------------------
Save it as whatever you like .bat

Now create a scheduled task in windows to run this whenever you want and you now have your automated backup for Kayako.

Keep in mind if the path to your mysql is different you will need to modify the path above and you should probably know the admin password on your box also.

[phalseid]

Originally Posted by rohmelec

I looked all over this forum and all over the web and finally just created this little thing which works great for backups.

To create this backup just open notepad paste in the following code
----------------------------------------------------------------------
@echo off
echo Running dump...
"c:\program files\MySQL\Mysql server 5.0\bin\mysqldump" -uroot -p<your password here without the brackets> --result-file="c:\Kayako_Backup\Kayako_backup.%DATE:~0,3%.s ql" kayako_suite
------------------------------------------------------------------------
Save it as whatever you like .bat

Now create a scheduled task in windows to run this whenever you want and you now have your automated backup for Kayako.

Keep in mind if the path to your mysql is different you will need to modify the path above and you should probably know the admin password on your box also.

posting this to the wiki....