[ 
http://mifosforge.jira.com/browse/MIFOS-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=58510#action_58510
 ] 

Adam Monsen edited comment on MIFOS-3183 at 6/23/10 1:25 PM:
-------------------------------------------------------------

Used script:
{code}
#!/bin/sh
mysqldump -u root --single-transaction --create-options --flush-logs 
--flush-privileges --master-data=2 --delete-master-logs --all-databases | gzip 
> /to_backup/mifos_mysql_full_backup.sql.gz
{code}

Crontab entry (for root):
{code}
# full dump at midnight every month on the 1st
0 2 1    * * full_mysql_backup || echo 'Please see the mail spool for the 
mifosadmin user on cloudtest.mifos.org for details' | mail -s 'MySQL full 
backup failure on cloudtest' [email protected]
{code}

      was (Author: meonkeys):
    Used script:
{code}
#!/bin/sh
mysqldump -u root --single-transaction --create-options --flush-logs 
--flush-privileges --master-data=2 --delete-master-logs --all-databases | gzip 
> /to_backup/mifos_mysql_full_backup.sql.gz
{code}
  
> stage full database backups in /mnt/to_backup
> ---------------------------------------------
>
>                 Key: MIFOS-3183
>                 URL: http://mifosforge.jira.com/browse/MIFOS-3183
>             Project: mifos
>          Issue Type: Dev Task
>            Reporter: Adam Monsen
>            Assignee: Van Mittal-Henkle
>             Fix For: Release E - Iteration 1, Release E
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to