#!/bin/bash

## Backup script. RUN AS ROOT AND DBADMIN

sudo /etc/init.d/tomcat5 stop
sudo /etc/init.d/mysql stop
mysqldump --flush-logs --opt olat > /usr/local/olatbackups/olatdb.sql -u root -p DBAMDIN_PW 
mysqlhotcopy olat /usr/local/olatbackups/olat_db --keepold --flushlog -u=root -p=DBADMIN_PW
sudo /etc/init.d/mysql start
sudo /etc/init.d/tomcat5 start