Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlÖ÷´ÓÊý¾Ý¸´ÖÆ

Ò»¡¢Îª´ÓÊý¾Ý¿âÉèÖø´ÖÆÕ˺Å
grant REPLICATION SLAVE on *.* To 'backup'@'%' identified by 'backuppwd'
flush privileges
 
¶þ¡¢µ¼³öÊý¾Ý
(1)Ö±½Ó¸´ÖÆÊý¾ÝÎļþĿ¼·½·¨
a. Í£Ö¹Êý¾Ý¿âдÊý¾Ý
flush tables with read lock
b.ÏÔʾ´ËʱmasterµÄ״̬
show master status
¼ÆÏ´ËʱÖ÷Êý¾Ý¿âµÄbinlogµÄµ±Ç°Îļþ¼°ÎļþÖÐµÄÆ«ÒÆÎ»ÖÃ(Ö÷Êý¾Ý¿â±ØÐë´ò¿ªlog-binÑ¡Ïî)£¬Õâ¸öÔÚÆô¶¯´ÓÊý¾Ý¿âʱÐèÒª£¬ÒÔ±ãʹ´ÓÊý¾Ý¿âÆô¶¯Ê±ÖªµÀ´ÓÄÄÀïÖ´ÐÐÖ÷Êý¾Ý¿âµÄ¸Ä±ä£¨Ö´ÐÐÖ÷Êý¾ÝµÄÈÕÖ¾£©
+---------------+----------+--------------+------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73       |              |                  |
+---------------+----------+--------------+------------------+
c.innodb±íÐèÒª¹Ø±ÕÊý¾Ý¿â
mysqladmin -uroot shutdown
d.µ¼³öÊý¾Ý
tar cvfz data.tar.gz Êý¾Ý¿âÎļþĿ¼
e.½âËøËùÓбí
unlock tables
(2)ÀûÓÃmysqldumpµ¼³ö
nohup /usr/local/mysql/bin/mysqldump -u<user> -p<pwd> -h<host> db --master-data --sock=/usr/local/mysql/tmp/mysqld.sock > master.sql &
Èý¡¢½«Êý¾Ýµ¼Èë´ÓÊý¾Ý¿â
(1)Ö±½Ó¸´ÖƵ½Êý¾ÝĿ¼
cpÃüÁî(È·±£Êý¾ÝÎļþĿ¼µÄȨÏÞ)
(2)ÃüÁîµ¼Èë
mysql -u<user> -p<pwd> -h<host> db < master.sql
 
ËÄ¡¢ÅäÖÃÊý¾Ý¿âÅäÖÃÎļþ
£¨1£©Ö÷Êý¾Ý¿â
[mysqld]
log-bin=mysql-bin
server-id=1
(2)´ÓÊý¾Ý¿â
[mysqld]
server-id=2
master-host=<master ip>
master-user=<user>
master-password=<pwd>
master-port=3306
master-connect-retry=60
replicate-do-db=backup_db    #Òª¸´ÖƵÄÊý¾Ý¿â
log-slave-updates  #¿ÉÒÔ×÷Ϊmaster,»òÕßÊÇÔÚ´ÓÊý¾Ý¿âÆô¶¯ÃüÁîʱ¼ÓÈë²ÎÊý--logs-slave-updates£¬¿ÉÒÔÅäÖÓÖ÷-->´Ó-->´Ó”µÄÁ´Ê½½á¹¹
read-only=1
Îå¡¢Æô¶¯´ÓÊý¾Ý¿â
1.ÓÃ--skip-slave-startÑ¡


Ïà¹ØÎĵµ£º

MySQLºÍOracleµÄһЩ²Ù×÷Çø±ð

 ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ ......

MySQL Êý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´

 
mysql,mysqldump,µ¼³ö,µ¼³ö±í,ѹËõµ¼³ömysql,mysqlhotcopy,mysql»¹Ô­±í
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM
ºÍ Innodb
£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ŀǰ MySQL Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy
£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACK ......

Ò»¸ö¼òµ¥µÄMysqlµÄÁªºÏ²éѯÁÐ×Ó

 
Ò»¸ömysqlµÄÁªºÏ²éѯÁÐ×Ó£¬ºÜ»ù±¾µÄ£¬²»¹ýºÜʵÓá£
ÏÈ¿´Êý¾Ý±í¡£Êý¾Ý±íclass£º
------------------------------- 
id   cname
-------------------------------
1    ÄÐ×°
2    ŮƤ¿ã
3    Å®²ÊÃÞ
-------------------------------
class±í´æ·ÅµÄÊDzúÆ·µÄ´óÀàà ......

¼òµ¥MysqlÃüÁî

MySql »ù±¾²Ù×÷
Ò»¡¢»ù´¡
1£º µÇ½£ºmysql –u  username –p <»Ø³µ¡· È»ºóÊäÈëÃÜÂë
2£º²é¿´Êý¾Ý¿â£ºshow databases£»
3£ºÊ¹ÓÃÊý¾Ý¿âuse databasename;
4:  ³£¿´Êý¾Ý¿â±í show tables£» µ«ÊÇǰÌáÊÇÄãÒѾ­Ê¹ÓÃÁËuse ÃüÁÈç¹ûûÓÐ µÄ»°¿ÉÒÔʹÓà show tables from databasename £»
5£º ²é¿´Êý ......

²é¿´mysqlµ±Ç°Á¬½ÓÊý

 1¡¢²é¿´µ±Ç°ËùÓÐÁ¬½ÓµÄÏêϸ×ÊÁÏ:
mysqladmin -uroot -proot processlist
D:\MySQL\bin>mysqladmin -uroot -proot processlist
+-----+------+----------------+---------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+---------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ