This forum is no longer active. Please post your questions to our new community site

Forums Redmine

batch file to backup DB under windows

Subscribe to batch file to backup DB under windows 4 post(s), 2 voice(s)

 
Avatar j2756 11 post(s)

Hi,

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

Thanks in advance.

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

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

 
Avatar j2756 11 post(s)

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

(So I can automated it?)

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

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.

Forums Redmine