mysql 주기적 backup 방법

1. script #!/bin/sh dir=/home/user/backup/homepage/db/test time=`date +%Y%m%d` mysqldump -uroot -p12345 test > "test_"$time".sql" tar czf $dir"/test_"$time".tar.gz" "test_"$time".sql" rm -rf "test_"$time".sql" #find $dir -atime +2 -print -exec rm -rf {} ;   dir=/home/user/backup/homepage/db/test…

0 Comments