MySQL 5.1 ăƒȘファレンă‚čăƒžăƒ‹ăƒ„ă‚ąăƒ« :: 12 SQL ă‚čăƒ†ăƒŒăƒˆăƒĄăƒłăƒˆæ§‹æ–‡ :: 12.6 è€‡èŁœă‚čăƒ†ăƒŒăƒˆăƒĄăƒłăƒˆ :: 12.6.2 ă‚čăƒŹăƒŒăƒ– ă‚”ăƒŒăƒă‚’ă‚łăƒłăƒˆăƒ­ăƒŒăƒ«ă™ă‚‹ SQL ă‚čăƒ†ăƒŒăƒˆăƒĄăƒłăƒˆ :: 12.6.2.5 RESET SLAVE 構文
« 12.6.2.4 MASTER_POS_WAIT() 構文

12.6.2.6 SET GLOBAL SQL_SLAVE_SKIP_COUNTER 構文 »
Section Navigation      [Toggle]
  • 12.6.2 ă‚čăƒŹăƒŒăƒ– ă‚”ăƒŒăƒă‚’ă‚łăƒłăƒˆăƒ­ăƒŒăƒ«ă™ă‚‹ SQL ă‚čăƒ†ăƒŒăƒˆăƒĄăƒłăƒˆ
  • 12.6.2.1 CHANGE MASTER TO 構文
  • 12.6.2.2 LOAD DATA FROM MASTER 構文
  • 12.6.2.3 LOAD TABLE tbl_name FROM MASTER 構文
  • 12.6.2.4 MASTER_POS_WAIT() 構文
  • 12.6.2.5 RESET SLAVE 構文
  • 12.6.2.6 SET GLOBAL SQL_SLAVE_SKIP_COUNTER 構文
  • 12.6.2.7 SHOW SLAVE STATUS 構文
  • 12.6.2.8 START SLAVE 構文
  • 12.6.2.9 STOP SLAVE 構文

12.6.2.5. RESET SLAVE 構文

RESET SLAVE

RESET SLAVE がă‚čăƒŹăƒŒăƒ–ăŒăƒžă‚čă‚żăźăƒă‚€ăƒŠăƒȘ ăƒ­ă‚°ć†…ăźè€‡èŁœäœçœźă‚’ćż˜ă‚Œă‚‹ă‚ˆă†ćƒăă‹ă‘ăŸă™ă€‚ă“ăźă‚čăƒ†ăƒŒăƒˆăƒĄăƒłăƒˆăŻć†ă‚čă‚żăƒŒăƒˆăźæ™‚ă«ćˆ©ç”šă™ă‚‹ç‚șăźç‰©ă§ă™ă€‚ă“ă‚ŒăŻ master.info ず relay-log.info ăƒ•ă‚Ąă‚€ăƒ«ă€ć…šăŠăźăƒȘăƒŹăƒŒ ăƒ­ă‚°ă‚’ć‰Šé™€ă—ă€ăă—ăŠæ–°ă—ă„ăƒȘăƒŹăƒŒ ログをă‚čă‚żăƒŒăƒˆă—ăŸă™ă€‚

æłšæ„:ă‚čăƒŹăƒŒăƒ– SQL ă‚čăƒŹăƒƒăƒ‰ă«ă‚ˆăŁăŠćźŒć…šă«ćźŸèĄŒă•ă‚ŒăŠă„ăȘくども慹どぼăƒȘăƒŹăƒŒ ăƒ­ă‚°ăŒć‰Šé™€ă•ă‚ŒăŸă™ă€‚(もし STOP SLAVE ă‚čăƒ†ăƒŒăƒˆăƒĄăƒłăƒˆă‚’ç™șèĄŒă—ăŠă„ăŸă‚Šă€ă‚čăƒŹăƒŒăƒ–ăŒé«˜èČ è·ă§ă‚ă‚‹ăšă€è€‡èŁœă‚čăƒŹăƒŒăƒ–äžŠă«ă“ăźçŠ¶æ…‹ăŒć­˜ćœšă—ă‚„ă™ăăȘă‚ŠăŸă™ă€‚)

master.info ăƒ•ă‚Ąă‚€ăƒ«ć†…ă«æ ŒçŽă•ă‚ŒăŸæŽ„ç¶šæƒ…ć ±ăŻă€ćŻŸćżœă™ă‚‹ă‚čă‚żăƒŒăƒˆă‚ąăƒƒăƒ— ă‚Șăƒ—ă‚·ăƒ§ăƒłć†…ă§æŒ‡ćźšă•ă‚ŒăŸć€€ă‚’ćˆ©ç”šă—ăŠé€Ÿă‚„ă‹ă«ăƒȘă‚»ăƒƒăƒˆă•ă‚ŒăŸă™ă€‚ă“ăźæƒ…ć ±ăŻă€ăƒžă‚čタ ホă‚čト、マă‚čタ ăƒăƒŒăƒˆă€ăƒžă‚čタ ăƒŠăƒŒă‚¶ă€ăă—ăŠăƒžă‚čタ パă‚čăƒŻăƒŒăƒ‰ăźă‚ˆă†ăȘć€€ă‚’ć«ăżăŸă™ă€‚ă‚‚ă—ă‚čăƒŹăƒŒăƒ– SQL ă‚čăƒŹăƒƒăƒ‰ăŒćœæ­ąă—ăŸæ™‚ăƒ†ăƒłăƒăƒ©ăƒȘ ăƒ†ăƒŒăƒ–ăƒ«ăźè€‡èŁœăźæœ€äž­ă§ă€ăă—ăŠ RESET SLAVE がç™șèĄŒă•ă‚Œă‚‹ăšă€ă“ă‚Œă‚‰ăźè€‡èŁœăƒ†ăƒłăƒăƒ©ăƒȘ ăƒ†ăƒŒăƒ–ăƒ«ăŻă‚čăƒŹăƒŒăƒ–äžŠă§ć‰Šé™€ă•ă‚ŒăŸă™ă€‚

Copyright © 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Top / Previous / Next / Up / Table of Contents
© 2010, Oracle Corporation and/or its affiliates