batch file to backup DB under windows

Hi,

Does anyone has an example of windows batch file that can be used to automate redmine database backup (mysql)?

Thanks in advance.

Hi,

You can run the following command or write it in a batch script:

> /installdir/mysql/bin/mysqldump -u root -p database_name > backup.sql

You can find more info at http://wiki.bitnami.com/Components/MySQL#How_to_create_a_database_backup.3f

So I just append mysql backup line to “use bitnami redmine stack” batch file?

(So I can automated it?)

Hi,

I would create a simple batch file, it is not necessary to append in the use_redmine batch file.

@echo off
/installdir/mysql/bin/mysqldump -u root -pyour_password database_name > backup.sql

That’s all. You can create a Windows Schedule Task to run this script periodically.