講述一個(gè)mysql 數(shù)據(jù)庫恢復(fù)的實(shí)例

#詳細(xì)步驟?  ?  #1?記住誤刪除表（或者出錯(cuò)）的時(shí)間?例如?Oct?17?08:30:27?CST?2011?  #2?先?drop?database?zabbix?;??  ???再?create?database?zabbix;(或者跳過直接執(zhí)行第3步)?  #3?導(dǎo)入備份的sql文件??  ???mysql?-uroot?-pdong?zabbix?stop?slave;??  #5?從二進(jìn)制日志文件得到sql語句?  #20111017?  ???mysqlbinlog?--database=zabbix?--stop-datetime="2011-10-17?08:30:00"?mysql-bin.000158?>?test.sql?  #6?恢復(fù)sql?文件?  #20110425?  ???mysql?-root?-pdong?zabbix??reset?slave;?  mysql>?change?master?to?master_host='192.168.6.53',master_user='dongnan',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=1;?  Query?OK,?0?rows?affected?(0.01?sec)?  ?  mysql>?slave?start;?  Query?OK,?0?rows?affected?(0.00?sec)?  ?  mysql>?show?slave?status?G;?  ***************************?1.?row?***************************?  ???????????????Slave_IO_State:?Waiting?for?master?to?send?event?  ??????????????????Master_Host:?192.168.6.53?  ??????????????????Master_User:?dongnan?  ??????????????????Master_Port:?3306?  ????????????????Connect_Retry:?60?  ??????????????Master_Log_File:?mysql-bin.000001?  ??????????Read_Master_Log_Pos:?3249706?  ???????????????Relay_Log_File:?zabbix-slave-relay-bin.000002?  ????????????????Relay_Log_Pos:?3249851?  ????????Relay_Master_Log_File:?mysql-bin.000001?  ?????????????Slave_IO_Running:?Yes?  ????????????Slave_SQL_Running:?Yes?  ?  ?  ?  #mysqlbinlog?其它?  #找到?2011-10-16?17:00:00?到?2011-10-16?17:58:59?這期間的sql語句?  mysqlbinlog?--database=zabbix?--start-datetime="2011-10-16?17:00:00"?--stop-datetime="2011-10-16?17:58:59"?mysql-bin.000157?>?test2.sql?  ?  du?-sh?test2.sql?  16M?test2.sql?  ?  head?test2.sql?  /*!40019?SET?@@session.max_insert_delayed_threads=0*/;?  /*!50003?SET?@OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;?  DELIMITER?/*!*/;?  #?at?4?  #111015?17:59:02?server?id?1??end_log_pos?106???Start:?binlog?v?4,?server?v?5.1.55-log?created?111015?17:59:02?  BINLOG?'?  ZlmZTg8BAAAAZgAAAGoAAAAAAAQANS4xLjU1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA?  AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC?  '/*!*/;?  #?at?259091243?  ?  tail?test2.sql?  /*!*/;?  #?at?270239069?  #111016?17:58:56?server?id?1??end_log_pos?270239321?????Query???thread_id=120???exec_time=0?error_code=0?  SET?timestamp=1318759136/*!*/;?  insert?into?history_uint?(itemid,clock,value)?values?(18532,1318759132,25427968),(18533,1318759133,43491328),(18534,1318759134,4308992),(18504,1318759134,15250739200),(18535,1318759135,0)?  /*!*/;?  DELIMITER?;?  #?End?of?log?file?  ROLLBACK?/*?added?by?mysqlbinlog?*/;?  /*!50003?SET?COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;?  ?  mysql?-uroot?-pdong?zabbix??test.txt?  #head?-n?10?test.txt??  #/usr/local/mysql/bin/mysqlbinlog?--start-datetime="2011-04-20?15:33:51"?mysql-bin.000013?|?/usr/local/mysql/bin/mysql?-uroot?-p