User Tools

Site Tools


mysql_backup_locally

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mysql_backup_locally [2009/05/02 03:11] (current)
k2patel created
Line 1: Line 1:
 +====== Mysql Backup Locally ======
  
 +
 +<code bash | mysqlbk.sh>​
 +#!/bin/sh
 +
 +DIR=<​backup_directory>​
 +PW=<​root_password>​
 +USER=<​owner_of_file>​
 +DATE=$(date +%Y%m%d)
 +
 +mysqldump=$(which mysqldump)
 +mysql=$(which mysql)
 +tar=$(which tar)
 +chown=$(which chown)
 +
 +for i in $($mysql -p$PW -e "SHOW DATABASES"​|grep -v Database); do
 +        $mysqldump -p$PW --allow-keywords $i > $DIR/$i.sql
 +done
 +
 +cd $DIR
 +$tar -cvf $DATE.tar *.sql
 +rm $DIR/*.sql
 +$chown -R $USER $DIR
 +
 +exit 0
 +</​code>​
mysql_backup_locally.txt ยท Last modified: 2009/05/02 03:11 by k2patel