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Ê®·ÖÓÐÓ᣷ÅÔÚ´Ë´¦·½±ã×Ô¼ºËæÊ±²éÔÄ£¬Ò²Ï£Í
Ïà¹ØÎĵµ£º
Galera ÊÇÒ»Ì×ÔÚ MySQL InnoDB ÉÏÃæÊµÏÖ Multi-master ÇÒ synchronous replication µÄϵ統¡£
¸Ã°æ±¾ÐÞ¸´ÁË9¸öbug£¬Ö÷ÒªÊÇ´¦Àí DDL ºÍ DML µÄ²¢·¢ÎÊÌ⣬ÁíÍâ»ù×¼MySQL°æ±¾Éý¼¶µ½ 5.1.41 ¡£
ÏÂÔØµØÖ·£º http://www.codership.com/en/downloads/galera
......
mysqlÖÐchar¡¢varchar¡¢nvarcharÊý¾ÝÀàÐ͵ÄÓ÷¨Çø±ð:
˵Ã÷:
1¡¢char:
¹Ì¶¨³¤¶ÈµÄ·Ç Unicode ×Ö·ûÊý¾Ý£¬×î´ó³¤¶ÈΪ 8,000 ¸ö×Ö·û¡£
2¡¢varchar£º
¿É±ä³¤¶ÈµÄ·Ç Unicode Êý¾Ý£¬×Ϊ 8,000 ¸ö×Ö·û¡£
3¡¢nvarchar£º
¿É±ä³¤¶È Unicode Êý¾Ý£¬Æä×î´ó³¤¶ÈΪ 4,000 ×Ö·û¡£  ......
MYSQL³£ÓÃÃüÁîÁбí
1¡¢ÏµÍ³¹ÜÀí
mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p
Á¬½ÓMYSQL£¨ÔÚmysql/bin£©
exit
Í˳öMYSQLÃüÁî
mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë
ÐÞ¸ÄÃÜÂ루ÔÚmysql/bin£©
grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost£¨"%"£¬ ±íʾÈκÎÖ÷»ú£©identifiedby " ......
mysql ibdata1ÎļþµÄËõС(2009-12-22 15:29:46)
±êÇ©£ºit
mysql ibdata1´æ·ÅÊý¾Ý£¬Ë÷ÒýµÈ£¬ÊÇMYSQLµÄ×îÖ÷ÒªµÄÊý¾Ý¡£
Èç¹û²»°ÑÊý¾Ý·Ö¿ª´æ·ÅµÄ»°£¬Õâ¸öÎļþµÄ´óСºÜÈÝÒ×¾ÍÉÏÁËG£¬ÉõÖÁ10+G¡£¶ÔÓÚijЩӦÓÃÀ´Ëµ£¬²¢²»ÊÇÌ«ºÏÊÊ¡£Òò´ËÒª°Ñ´ËÎļþËõС¡£
·½·¨£ºÊý¾ÝÎļþµ¥¶À´æ·Å¡£
²½Ö裺
1£¬±¸·ÝÊý¾Ý¿â
......