﻿<!--
//v1.7
// Flash Player Version Detection
// Detect Client Browser type
// Copyright 2005-2008 Adobe Systems Incorporated.  All rights reserved.
var isIE  = (navigator.appVersion.indexOf("MSIE") != -1) ? true : false;
var isWin = (navigator.appVersion.toLowerCase().indexOf("win") != -1) ? true : false;
var isOpera = (navigator.userAgent.indexOf("Opera") != -1) ? true : false;
function ControlVersion()
{
	var version;
	var axo;
	var e;
	// NOTE : new ActiveXObject(strFoo) throws an exception if strFoo isn't in the registry
	try {
		// version will be set for 7.X or greater players
		axo = new ActiveXObject("ShockwaveFlash.ShockwaveFlash.7");
		version = axo.GetVariable("$version");
	} catch (e) {
	}
	if (!version)
	{
		try {
			// version will be set for 6.X players only
			axo = new ActiveXObject("ShockwaveFlash.ShockwaveFlash.6");
			
			// installed player is some revision of 6.0
			// GetVariable("$version") crashes for versions 6.0.22 through 6.0.29,
			// so we have to be careful. 
			
			// default to the first public version
			version = "WIN 6,0,21,0";
			// throws if AllowScripAccess does not exist (introduced in 6.0r47)		
			axo.AllowScriptAccess = "always";
			// safe to call for 6.0r47 or greater
			version = axo.GetVariable("$version");
		} catch (e) {
		}
	}
	if (!version)
	{
		try {
			// version will be set for 4.X or 5.X player
			axo = new ActiveXObject("ShockwaveFlash.ShockwaveFlash.3");
			version = axo.GetVariable("$version");
		} catch (e) {
		}
	}
	if (!version)
	{
		try {
			// version will be set for 3.X player
			axo = new ActiveXObject("ShockwaveFlash.ShockwaveFlash.3");
			version = "WIN 3,0,18,0";
		} catch (e) {
		}
	}
	if (!version)
	{
		try {
			// version will be set for 2.X player
			axo = new ActiveXObject("ShockwaveFlash.ShockwaveFlash");
			version = "WIN 2,0,0,11";
		} catch (e) {
			version = -1;
		}
	}
	
	return version;
}
// JavaScript helper required to detect Flash Player PlugIn version information
function GetSwfVer(){
	// NS/Opera version >= 3 check for Flash plugin in plugin array
	var flashVer = -1;
	
	if (navigator.plugins != null && navigator.plugins.length > 0) {
		if (navigator.plugins["Shockwave Flash 2.0"] || navigator.plugins["Shockwave Flash"]) {
			var swVer2 = navigator.plugins["Shockwave Flash 2.0"] ? " 2.0" : "";
			var flashDescription = navigator.plugins["Shockwave Flash" + swVer2].description;
			var descArray = flashDescription.split(" ");
			var tempArrayMajor = descArray[2].split(".");			
			var versionMajor = tempArrayMajor[0];
			var versionMinor = tempArrayMajor[1];
			var versionRevision = descArray[3];
			if (versionRevision == "") {
				versionRevision = descArray[4];
			}
			if (versionRevision[0] == "d") {
				versionRevision = versionRevision.substring(1);
			} else if (versionRevision[0] == "r") {
				versionRevision = versionRevision.substring(1);
				if (versionRevision.indexOf("d") > 0) {
					versionRevision = versionRevision.substring(0, versionRevision.indexOf("d"));
				}
			}
			var flashVer = versionMajor + "." + versionMinor + "." + versionRevision;
		}
	}
	// MSN/WebTV 2.6 supports Flash 4
	else if (navigator.userAgent.toLowerCase().indexOf("webtv/2.6") != -1) flashVer = 4;
	// WebTV 2.5 supports Flash 3
	else if (navigator.userAgent.toLowerCase().indexOf("webtv/2.5") != -1) flashVer = 3;
	// older WebTV supports Flash 2
	else if (navigator.userAgent.toLowerCase().indexOf("webtv") != -1) flashVer = 2;
	else if ( isIE && isWin && !isOpera ) {
		flashVer = ControlVersion();
	}	
	return flashVer;
}
// When called with reqMajorVer, reqMinorVer, reqRevision returns true if that version or greater is available
function DetectFlashVer(reqMajorVer, reqMinorVer, reqRevision)
{
	versionStr = GetSwfVer();
	if (versionStr == -1 ) {
		return false;
	} else if (versionStr != 0) {
		if(isIE && isWin && !isOpera) {
			// Given "WIN 2,0,0,11"
			tempArray         = versionStr.split(" "); 	// ["WIN", "2,0,0,11"]
			tempString        = tempArray[1];			// "2,0,0,11"
			versionArray      = tempString.split(",");	// ['2', '0', '0', '11']
		} else {
			versionArray      = versionStr.split(".");
		}
		var versionMajor      = versionArray[0];
		var versionMinor      = versionArray[1];
		var versionRevision   = versionArray[2];
        	// is the major.revision >= requested major.revision AND the minor version >= requested minor
		if (versionMajor > parseFloat(reqMajorVer)) {
			return true;
		} else if (versionMajor == parseFloat(reqMajorVer)) {
			if (versionMinor > parseFloat(reqMinorVer))
				return true;
			else if (versionMinor == parseFloat(reqMinorVer)) {
				if (versionRevision >= parseFloat(reqRevision))
					return true;
			}
		}
		return false;
	}
}
function AC_AddExtension(src, ext)
{
  if (src.indexOf('?') != -1)
    return src.replace(/\?/, ext+'?'); 
  else
    return src + ext;
}
function AC_Generateobj(objAttrs, params, embedAttrs) 
{ 
  var str = '';
  if (isIE && isWin && !isOpera)
  {
    str += '<object ';
    for (var i in objAttrs)
    {
      str += i + '="' + objAttrs[i] + '" ';
    }
    str += '>';
    for (var i in params)
    {
      str += '<param name="' + i + '" value="' + params[i] + '" /> ';
    }
    str += '</object>';
  }
  else
  {
    str += '<embed ';
    for (var i in embedAttrs)
    {
      str += i + '="' + embedAttrs[i] + '" ';
    }
    str += '> </embed>';
  }
  document.write(str);
}
function AC_FL_RunContent(){
  var ret = 
    AC_GetArgs
    (  arguments, ".swf", "movie", "clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"
     , "application/x-shockwave-flash"
    );
  AC_Generateobj(ret.objAttrs, ret.params, ret.embedAttrs);
}
function AC_SW_RunContent(){
  var ret = 
    AC_GetArgs
    (  arguments, ".dcr", "src", "clsid:166B1BCA-3F9C-11CF-8075-444553540000"
     , null
    );
  AC_Generateobj(ret.objAttrs, ret.params, ret.embedAttrs);
}
function AC_GetArgs(args, ext, srcParamName, classid, mimeType){
  var ret = new Object();
  ret.embedAttrs = new Object();
  ret.params = new Object();
  ret.objAttrs = new Object();
  for (var i=0; i < args.length; i=i+2){
    var currArg = args[i].toLowerCase();    
    switch (currArg){	
      case "classid":
        break;
      case "pluginspage":
        ret.embedAttrs[args[i]] = args[i+1];
        break;
      case "src":
      case "movie":	
        args[i+1] = AC_AddExtension(args[i+1], ext);
        ret.embedAttrs["src"] = args[i+1];
        ret.params[srcParamName] = args[i+1];
        break;
      case "onafterupdate":
      case "onbeforeupdate":
      case "onblur":
      case "oncellchange":
      case "onclick":
      case "ondblclick":
      case "ondrag":
      case "ondragend":
      case "ondragenter":
      case "ondragleave":
      case "ondragover":
      case "ondrop":
      case "onfinish":
      case "onfocus":
      case "onhelp":
      case "onmousedown":
      case "onmouseup":
      case "onmouseover":
      case "onmousemove":
      case "onmouseout":
      case "onkeypress":
      case "onkeydown":
      case "onkeyup":
      case "onload":
      case "onlosecapture":
      case "onpropertychange":
      case "onreadystatechange":
      case "onrowsdelete":
      case "onrowenter":
      case "onrowexit":
      case "onrowsinserted":
      case "onstart":
      case "onscroll":
      case "onbeforeeditfocus":
      case "onactivate":
      case "onbeforedeactivate":
      case "ondeactivate":
      case "type":
      case "codebase":
      case "id":
        ret.objAttrs[args[i]] = args[i+1];
        break;
      case "width":
      case "height":
      case "align":
      case "vspace": 
      case "hspace":
      case "class":
      case "title":
      case "accesskey":
      case "name":
      case "tabindex":
        ret.embedAttrs[args[i]] = ret.objAttrs[args[i]] = args[i+1];
        break;
      default:
        ret.embedAttrs[args[i]] = ret.params[args[i]] = args[i+1];
    }
  }
  ret.objAttrs["classid"] = classid;
  if (mimeType) ret.embedAttrs["type"] = mimeType;
  return ret;
}
--><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>

	<title>MYSQL Bin Log - sql_log_bin log_bin deaktivieren</title>

	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<meta name="description" content="Beschreibung zur Deaktivierung von Bin Logs in MYSQL.">
	<meta name="keywords" content="Binär Logs, MYSQL, log_bin, sql_log_bin, Binär Logging">
	
	<!-- TradeDoubler site verification 1581567 --> 
		<script type="text/javascript" src="/includes/flaming.js"></script>
	<link rel="stylesheet" href="/css/style.css" type="text/css" />

	<link rel="shortcut icon" href="/images/n/favicon.ico" type="image/x-icon"> 
	<link rel="icon" href="/images/favicon.ico" type="image/x-icon">

</head>
<body>


<center>
<div>

<div style="position:absolute; top:130px; left:45%;">
  
  <form action="/search.html" method="GET" enctype="text/plain">
	  Büchersuche: <input type="text" name="keyword" value="" size="20"/>
	  <input type="submit" value="Suchen"/>
</form>  
</div>

<img src="/images/header_top.jpg" id="top_logo" border="0" usemap="#map_for_startlink" />
<map name="map_for_startlink" id="map_for_startlink">
	<area shape="poly" coords="81,105,215,71,383,53,507,51,653,61,807,83,847,97,831,120,627,93,495,93,427,103,309,107,123,149" href="/" alt="buch-billig-kaufen.de - Hier gibts Bücher zu günstigen / billigen Preisen" />
</map>

<div id="main">
	<div id="navigation">
		<ul>
			<li><a href="/rubriken/romane-belletristik.html">Romane</a></li>
			<li><a href="/rubriken/krimis-thriller.html">Krimi & Thriller</a></li>
			<li><a href="/rubriken/kinder-und-jugendbuecher.html">Kinder & Jugend</a></li>
			<li><a href="/rubriken/laender-reise-abenteuer-staedtereisen.html">Länder & Reisen</a></li>
			<li><a href="/rubriken/fachbuecher.html">Fachliteratur</a></li>
			<li><a href="/rubriken/sport-ballsport-fitness-joga.html">Sport & Freizeit</a></li>
			<li><a href="/rubriken/ratgeber.html">Ratgeber</a></li>
			<li><a href="/rubriken/wirtschaft-buisness-karriere.html">Recht & Wirtschaft</a></li>			
		</ul>
	</div> <!-- Ende Navigation -->
	 
	<div id="navigation_left">
		<img src="/images/navigation_left.gif" width="160" height="339" border="0" usemap="#map_for_navigation" />
<map name="map_for_navigation" id="map_for_navigation">
	<area shape="poly" coords="66,79,142,36,151,47,150,58,77,100" href="/rubriken/romane-belletristik.html" alt="Romane" title="Hier finden Sie Angebote von Romanen"/>
	<area shape="poly" coords="73,110,149,66,156,75,154,89,78,134" href="/rubriken/krimis-thriller.html" alt="Krimi Thriller" title="Hier finden Sie Bücher aus der Kategorie Krimi und Thriller"/>
	<area shape="poly" coords="74,146,152,101,156,109,155,120,77,164" href="/rubriken/kinder-und-jugendbuecher.html" alt="Kinder Jugend" title="Hier finden alles an Kinder und Jugend Bücher"/>
	<area shape="poly" coords="72,179,151,133,156,147,154,154,78,196" href="/rubriken/laender-reise-abenteuer-staedtereisen.html" alt="Länder Reisen" title="Hier finden Bücher zum Thema Länder und Reisen"/>
	<area shape="poly" coords="71,211,146,167,152,184,79,227" href="/rubriken/fachbuecher.html" alt="Fachliteratur" title="Hier finden Sie Fachliteratur"/>
	<area shape="poly" coords="71,241,149,198,157,208,153,219,76,262" href="/rubriken/sport-ballsport-fitness-joga.html" alt="Sport Freizeit" title="Hier finden Sie Bücher zu Sport und Freizeit"/>
	<area shape="poly" coords="71,272,149,229,155,251,76,298" href="/rubriken/ratgeber.html" alt="Ratgeber" title="Hier finden alles Sachbücher und Ratgeber"/>
	<area shape="poly" coords="71,306,149,261,154,286,78,330" href="/rubriken/wirtschaft-buisness-karriere.html" alt="Recht Wirtschaft" title="Hier finden Bücher zu Recht und Wirtschaft"/>
</map>

<br />
<br />
<div id="blog_navi"><a href="http://blog.buch-billig-kaufen.de" class="blog_navi_header"><img src="/images/blank.gif" width="138px" height="104px" style="border:0px none;"/></a></div>
<br />
	
<div id="subnavi">
	<div class="left_navi">
		
					<div class="left_navi_header">
				Schnäppchen
			</div>
			<div class="left_navi_content subnavi_middle">
																						<p>
								<a href='/buch/3423212624/erbarmen_der_erste_fall_fuer_carl_m%C3%B8rck_sonderdezernat_q.html' class="left_navi_title">
									Erbarmen: Der erste Fall für Carl Mørck, Sonderdezernat Q
								</a>							
							</p>
							<div class="left_navi_price">
								<a href='/buch/3423212624/erbarmen_der_erste_fall_fuer_carl_m%C3%B8rck_sonderdezernat_q.html'>
									<img width="52px" src="http://ecx.images-amazon.com/images/I/510ychRd6vL._SL75_.jpg" alt="Erbarmen: Der erste Fall für Carl Mørck, Sonderdezernat Q"/>
								</a>
																	EUR 8,50 
															</div>						
											
						 
																						<p>
								<a href='/buch/3548608868/mordsfreunde_der_zweite_fall_fuer_bodenstein_und_kirchhoff.html' class="left_navi_title">
									Mordsfreunde: Der zweite Fall für Bodenstein und Kirchhoff
								</a>							
							</p>
							<div class="left_navi_price">
								<a href='/buch/3548608868/mordsfreunde_der_zweite_fall_fuer_bodenstein_und_kirchhoff.html'>
									<img width="52px" src="http://ecx.images-amazon.com/images/I/517GWtttJOL._SL75_.jpg" alt="Mordsfreunde: Der zweite Fall für Bodenstein und Kirchhoff"/>
								</a>
																	EUR 9,99 
															</div>						
											
						 
																						<p>
								<a href='/buch/3833815981/ich_coach_dich_schlank_gu_reihe_einzeltitel.html' class="left_navi_title">
									Ich coach dich schlank (GU Reihe Einzeltitel)
								</a>							
							</p>
							<div class="left_navi_price">
								<a href='/buch/3833815981/ich_coach_dich_schlank_gu_reihe_einzeltitel.html'>
									<img width="52px" src="http://ecx.images-amazon.com/images/I/514uuPhpA9L._SL75_.jpg" alt="Ich coach dich schlank (GU Reihe Einzeltitel)"/>
								</a>
																	EUR 4,67 
															</div>						
											
						 
																						<p>
								<a href='/buch/3190097313/komplettkurs_franzoesisch_anfaengerkurs__aufbaukurs.html' class="left_navi_title">
									Komplettkurs Französisch: Anfängerkurs & Aufbaukurs
								</a>							
							</p>
							<div class="left_navi_price">
								<a href='/buch/3190097313/komplettkurs_franzoesisch_anfaengerkurs__aufbaukurs.html'>
									<img width="52px" src="http://ecx.images-amazon.com/images/I/51VcLKcudOL._SL75_.jpg" alt="Komplettkurs Französisch: Anfängerkurs & Aufbaukurs"/>
								</a>
																	EUR 14,95 
															</div>						
											
						 
																						<p>
								<a href='/buch/3190097305/komplettkurs_englisch_anfaengerkurs__aufbaukurs.html' class="left_navi_title">
									Komplettkurs Englisch: Anfängerkurs & Aufbaukurs
								</a>							
							</p>
							<div class="left_navi_price">
								<a href='/buch/3190097305/komplettkurs_englisch_anfaengerkurs__aufbaukurs.html'>
									<img width="52px" src="http://ecx.images-amazon.com/images/I/51fLAs4PCoL._SL75_.jpg" alt="Komplettkurs Englisch: Anfängerkurs & Aufbaukurs"/>
								</a>
																	EUR 14,95 
															</div>						
											
						 
							</div>
			<div class="subnavi_end">
			</div>
				
				<br/>
			</div>
</div>


<br class="clear"/>	</div>
	
	<div id="main_content">
		<div id="whereiam">
			<a style="color:red" href="http://www.buch-billig-kaufen.de" title="Zur Startseite">Home</a> -> <a style='color: red;' href='/skripte/php-uebersicht.html'>PHP Skripte und Infos</a> -> MYSQL Bin Log
		</div>
		
		<div id="content">
<!-- Haupt content bereich -->

<h1>MYSQL Binär Logging deaktivieren</h1>

<p>Zum Thema MYSQL Binär Logging deaktivieren gibt es diverse Einträge im Web, allerdings sind nicht viele mit nützlichem Inhalt bestückt. Deshalb gibts hier die Lösung die mir geholfen hat das Binär Logging abzuschalten. </p>
<p>!! Bitte Beachten: Zum Deaktivieren der Bin-Logs müssen Sie root Rechte auf Ihrem Server besitzen. Bin-Logging verbraucht laut dem MYSQL Referenz Handbuch nur ca. 1% der Server Kapazität. Sollte der Server also stabil laufen und keine Performance Probleme haben, sollten Sie die Binär Logs nicht abschalten. Die Binär Logs dienen der automatisierten Datenwiederherstellung nach einem Absturz des Servers.</p>
<p>In der my.conf müssen Sie mindestens folgende Parameter auskommentieren: <br />
<br />
<pre style="background: #F6F6FD none repeat scroll 0 0; border: 1px solid #000000; font-family:monospace; padding: 5px; ">
....
#log-bin = ....
....
#expire_log_days = ....
....
</pre>
<p>Nachdem diese Parameter auskommentiert wurde, können Sie den Mysql Server restarten ohne das der Mysql Server Fehler auswirft. </p>
<p>Ich hoffe damit einigen verzweifelten Serveradministratoren geholfen zu haben.</p>
<br/>
		</div> <!-- End content -->
	</div> <!-- End main_content -->
	<div id="navigation_right">
		<div class="navi_right_title">Buch-Blog Newsfeed</div>
<ul style='margin:0px 10px; list-style:none; text-align:left; padding:0px;'><li style='padding:5px 0px'><a href='http://blog.buch-billig-kaufen.de/2010/09/17/daniela-katzenberger-werbe-spot-118000/'>Daniela Katzenberger gibt Gas und landet im Fernsehen mit einem sehr lustigen Werbe-Spot für die 118000</a></li><li style='padding:5px 0px'><a href='http://blog.buch-billig-kaufen.de/2010/09/09/es-wird-gelesen-im-september-2010/'>Es wird gelesen im September 2010!</a></li><li style='padding:5px 0px'><a href='http://blog.buch-billig-kaufen.de/2010/03/09/taufe-msc-magnifica-hamburg/'>Taufe der MSC Magnifica im Hamburger Hafen</a></li><li style='padding:5px 0px'><a href='http://blog.buch-billig-kaufen.de/2009/10/19/dan-brown_the-solomon-key-das-verlorene-symbol/'>Dan Brown - The Solomon Key - Das verlorene Symbol</a></li><li style='padding:5px 0px'><a href='http://blog.buch-billig-kaufen.de/2009/05/13/hamburgs-hafengeburtstag-2009/'>Hamburgs Hafengeburtstag 2009</a></li></ul>
<br />
<br />
<div class="navi_right_title">Anzeige</div>
<div id="banner">
	<script type="text/javascript"><!--
google_ad_client = "pub-7218513935561436";
/* navigation_rechts 120x600 */
google_ad_slot = "7564312607";
google_ad_width = 120;
google_ad_height = 600;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></div>
<br />
<br />	</div>
	<br class="clear" />
	
</div> <!-- End main -->


<!-- Footer -->
<div id="footer">
<a href="/" title="Ab zur billigen Bücher Startseite">Startseite</a> | 
<a href="/weblinks.html" title="Interessante Weblinks">Weblinks</a> | 
<a href="/kassetten.html" title="Informationen zu Kassetten">Kassetten</a> | 
<a href="/partner.html">Partner</a> | 
<a href="/intern.html">Intern</a> | 
<a href="/impressum.html">Impressum</a> |
<a href="/skripte/php-uebersicht.html">PHP Skripte</a>
<br />
<p>
	<a href="http://www.amazon.de/gp/redirect.html?ie=UTF8&location=http%3A%2F%2Fwww.amazon.de%2F&site-redirect=de&tag=buchbilligkau-21&linkCode=ur2&camp=1638&creative=19454"><img style="border:0px none;" src="/images/links/amazon.gif" /></a><img src="https://www.assoc-amazon.de/e/ir?t=buchbilligkau-21&l=ur2&o=3" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" />
	<a href="http://delicious.com/"><img style="border:0px none;" src="/images/links/delicious.png" /></a> 
	<a href="http://www.mister-wong.de"><img style="border:0px none;" src="/images/links/mister-wong.gif" /></a>	

</p>
</div>


</center>


<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-5484571-1");
pageTracker._setDomainName(".buch-billig-kaufen.de");
pageTracker._trackPageview();
</script>


</BODY>
</HTML>