Home | Mirror | Search |
目錄
#!/bin/bash HOST='localhost' USER='neo' PASS='chen' SDB='neo' TDB='netkiller' MYSQLDUMP="mysqldump" MYSQLDUMPOPTS="-h${HOST} -u${USER} -p${PASS}" MYSQL="mysql" MYSQLOPTS="-h${HOST} -u${USER} -p${PASS}" #SED="sed -e 's/netkiller\.8800\.org/netkiller\.sf\.net/g' -e 's/陳景峰/景峰/g' -e 's/Neo/Netkiller/g'" $MYSQL $MYSQLOPTS <<SQL DROP DATABASE $TDB; CREATE DATABASE $TDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; SQL $MYSQLDUMP $MYSQLDUMPOPTS ${SDB} | sed -e 's/netkiller\.8800\.org/netkiller\.sf\.net/g' -e 's/陳景峰/景峰/g' -e 's/Neo/Netkiller/g' | $MYSQL $MYSQLOPTS ${TDB} #echo "$MYSQLDUMP $MYSQLDUMPOPTS ${SDB} | $SED | $MYSQL $MYSQLOPTS ${TDB}"