#!/bin/bash
filename=`date "+%Y.%m.%d %H:%M:%S"`
MYSQL_HOME=/usr/local/mysql
PATH=$MYSQL_HOME/bin:$PATH
mysqldump --opt ucenter -u root -predhat >/mysqlbacku/ucenter$filename.sql




$>mysqldump -u root -p ucneter | gzip > ucneter_050519.sql.gz


从压缩文件直接恢复：
$>gunzip < ucenter2009.01.12\ 02\:56\:09.sql .gz | mysql -u root -p ucenter

以上是备份脚本，以下这个是恢复脚本。

mysql$>bin/mysql -u root -predhat ucenter < /mysqlbacku/ucenter2009.01.12\ 02\:56\:09.sql


字符集问题
mysql$>bin/mysql -u root -p --default-character-set=utf-8 ucenter < /mysqlbacku/ucenter2009.01.12\ 02\:56\:09.sql




mysql>create database ucenter;

discuz


mysql> GRANT ALL PRIVILEGES ON ucenter.* TO mysql@192.168.88.34
    -> IDENTIFIED BY 'redhat' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| discuz             |
| mysql              |
| test               |
| ucenter            |
+--------------------+
5 rows in set (0.00 sec)

mysql> use mysql;
Database changed
mysql> DELETE FROM user WHERE User="ucenter";
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)



mysql> drop database ucenter;
Query OK, 0 rows affected (0.00 sec)