mysql³£ÓÃÃüÁî

mysql³£ÓÃÃüÁî 
  
¹Ø±ÕÊý¾Ý¿â
/data01/mysql/bin/mysqladmin -p shutdown
µ¼³öÊý¾Ý¿â
/usr/local/mysql/bin/mysqldump -opt -uroot -p -h10.15.0.45 bbsdb > 20070918.bbsdb.sql
µ¼ÈëÊý¾Ý¿â
/usr/local/mysql/bin/mysql target_db_name < backup-file.sql
ÏÞÖÆÖ»ÓÐÄÚ²¿ip¿ÉÒÔÁ´½Ó
/usr/local/mysql/bin/mysqld_safe --bind-address=10.15.0.72 &
Êý¾Ý¿â°²×°
./configure --prefix=/usr/local/mysql --with-charset=gbk --with-collation=gbk_chinese_ci
Êý¾Ý¿âÐÞ±í
/usr/local/mysql/bin/myisamchk --safe-recover table_name
¸ü¸ÄmysqlÓû§ÃÜÂ룺
mysql -h 10.15.11.2 -u root -p
Enter password: ********
ERROR 1130 (00000): Host '10.15.11.2' is not allowed to connect to this MySQL server
½â¾ö°ì·¨£¬ÔÚ10.15.11.2»úÆ÷ÉÏÖ´ÐÐ
mysql>grant all on *.* to root@'%' identified by 'yourpassword';
mysql>flush privileges; //Ë¢ÐÂȨÏÞ
##########################################
mysql±¸·Ý½Å±¾
#!/bin/sh
BACK_HOME="/server/back/www.test_db" ####±¸·Ý¿â·Åµ½µÄĿ¼
MYSQLDUMP="/server/mysql/bin/mysqldump" ###ÃüÁî
MYSQLCMD="/server/mysql/bin/mysql"
DB_NAME_LIST_FILE="/server/back/www.test_db/dbnamelist" ###¿âÁбí
##########
TAR="/bin/tar"
MYSQL_SERVER="10.15.0.52" ###Òª±¸·ÝÖ÷»úipµØÖ·
###µ¼Êý¾Ý¿âÁбí
$MYSQLCMD -uzhp -p12345 -h $MYSQL_SERVER </root/showdbcmd.sql>$DB_NAME_LIST_FILE
############
TODAY=`date +%Y%m%d`
MONTH=`date "+%d"`
WEEK=`date "+%w"`
##################
cd $BACK_HOME
for i in `cat $DB_NAME_LIST_FILE`
do
if [ $i != "Database" ]
then
echo "start $i..."
$MYSQLDUMP -Q -uzhp -p12345 -h $MYSQL_SERVER $i >$TODAY.$i.sql && echo "$TODAY.$i.sql good" >>mail.txt ####µ¼¿âÃüÁî
fi
done
echo "start tar...."
$TAR cvzfp $TODAY.db.test.sql.tar.gz *.sql && echo "$TODAY smsdbgood" >> mail.txt
cd $BACK_HOME
rm -rf *.sql
###########################
A.my.cnfÅäÖÃ
±¾ÎÄÖеÄÅäÖö¼ÊÇ´Ó¡¶MySQL5ȨÍþÖ¸ÄÏ(3rd)¡·ÖÐÕª³­³öÀ´µÄ£¬¸öÈËÈÏΪ¶ÔÓÚʹÓÃMySQLÊ®·ÖÓÐÓ᣷ÅÔÚ´Ë´¦·½±ã×Ô¼ºËæʱ²éÔÄ£¬Ò²Ï£Í