smirea

Backup mysql script

Apr 27th, 2014
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.28 KB | None | 0 0
  1. #!/bin/sh
  2.  
  3. if [ $# -lt 2 ]; then
  4.   echo "Usage: backup_mysql database_name backup_folder"
  5. else
  6.   name="$1_$(date +%F_%T).sql"
  7.   output="$2/$name"
  8.   last="$2/last_backup.sql"
  9.   mysqldump -utak3r $1 > $output
  10.   if [ -f $last ]; then
  11.     rm -f $last
  12.   fi
  13.   cp $output $last
  14. fi
Advertisement
Add Comment
Please, Sign In to add comment