#!/bin/bashmysqladmin -uroot -p flush-logsmysqldump plog -uroot -p > /tmp/plog.sqltar czvf /tmp/plog.tgz ./plog/scp /tmp/plog.sql user@blog.hsjh.tc.edu.tw:/tmp/plog.sqlscp /tmp/plog.tgz user@blog.hsjh.tc.edu.tw:/tmp/plog.tgz
#! /bin/bashtar xzvf /tmp/plog.tgzchown -R www-data:www-data /var/www/plogmysql plog -uroot -p < /tmp/plog.sql