1  #!/bin/sh
2  # Filename: backup.sh
3  # Function: do daily backups of databases
4  # updated 10-07-2000
5  # -- added changelog to this file
6 
7 
8 
9  # Change To fit your system
10  userid=root
11  # On my development system I don't have the root password
12  # You will also need add -p${password} to
13  #password=passwd
14 
15  # Create a cron job to run every night at 4:30am
16  # 30 04 * * * /patch/to/pccs_mysqladm/bin/backup.sh
17 
18  # Location of Mysql bin directory
19  mysqlbinclient="/usr/local/bin/mysql -u$userid}"
20  mysqlbindump="/usr/local/bin/mysqldump -u$userid}"
21 
22  # Location of Mysql Database backup directory
23  dbbackupdir=/home/www/htdocs/pccsmysqladm/dumpfiles
24 
25  $mysqlbinclient -e 'SHOW DATABASES' | sed 's/|//g' | grep -v 'Database' \
26   | while read dbname; do
27  if [ -d $dbbackupdir/$dbname}_db ]; then
28  echo -n 2>/dev/null
29  else
30   mkdir $dbbackupdir/$dbname}_db
31  fi
32 
33  curr_time=`date | sed 's/ //g' | sed 's/:/_/g'`
34  $mysqlbindump --opt $dbname} > $dbbackupdir/$dbname}_db/$curr_time}.$dbname}_dumpsql.BACKUP 2>/dev/null
35 
36  done