mysql login ol
SET GLOBAL log_output = “FILE”;
SET GLOBAL general_log = ‘ON’;
böylelikle loglanma başlar
ilgili dosya /var/lib/mysql/ altında bulunur.
loglanmanın durdurulması için
SET GLOBAL general_log = ‘OFF’;
çalıştırılması yeterlidir.
böylelikle tüm veritabanlarındaki SQL ler loglanır.
**********
Eğer tabloya kaydetmek istiyorsanız;
SET GLOBAL log_output = ‘TABLE’;
iconv(mb_detect_encoding($text, mb_detect_order(), true), "UTF-8", $text);dizindeki dosya adedi
ls -1 targetdir | wc -l
boş dosyaları silme (silinmesini istediğin dizine git)
rm -f $(find . -empty)
1) Sanal POS sayısı 64895 adet 2) Sanal İşyeri Sayısı 55141 adet
kaynak payu ülke müdürü
max_input_vars = 3000
suhosin varsa
suhosin.post.max_vars = 3000
suhosin.request.max_vars = 3000
bir de MB cinsinden gelen giden veriyi büyütelim
post_max_size = 8M
upload_max_filesize = 8M
http://www.amplio.ch/blog/web-development/codeigniter-active-record-class-and-insert-ignore/
duplicate checkten bıkanlara..
Delivered-To: osman@geo-nni.com
Received: by 10.229.97.141 with SMTP id l13csp21144qcn;
Wed, 6 Jun 2012 01:41:09 -0700 (PDT)
Received: by 10.68.226.73 with SMTP id rq9mr55935384pbc.145.1338972068695;
Wed, 06 Jun 2012 01:41:08 -0700 (PDT)
Return-Path: <bounce-osman=geo-nni.com-h5P7vcAxMWBLp1pw@xxxxx.com>
Received: from s12-m10.xxxxx.com (s12-m10.xxxxx.com. [xx.xx.xx.xx])
by mx.google.com with ESMTP id rg2si1724212pbc.141.2012.06.06.01.41.08;
Wed, 06 Jun 2012 01:41:08 -0700 (PDT)
Received-SPF: pass (google.com: domain of bounce-osman=geo-nni.com-h5P7vcAxMWBLp1pw@xxxxx.com designates xx.xx.xx.xx as permitted sender) client-ip=xx.xx.xx.xx;
Authentication-Results: mx.google.com; spf=pass (google.com: domain of bounce-osman=geo-nni.com-h5P7vcAxMWBLp1pw@xxxxx.com designates xx.xx.xx.xx as permitted sender) smtp.mail=bounce-osman=geo-nni.com-h5P7vcAxMWBLp1pw@xxxxx.com; dkim=pass header.i=@a.xxxxx.com
Date: Wed, 06 Jun 2012 01:41:08 -0700 (PDT)
Message-Id: <4fcf17a4.02e1440a.71fb.ffffecefSMTPIN_ADDED@mx.google.com>
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=a.xxxxx.com;
i=@a.xxxxx.com; q=dns/txt; s=default; t=1338972095; h=To : Subject :
From : content-id : cc : List-Unsubscribe : Thread-Topic : References :
In-Reply-To; bh=Qlmh8jYQvWVJPtfYb5owSyfAaCMwXxOnPC6mGH/OyfM=; b=rAErZsT9bo2yisSv91WPieIua1r8oQt5aG7jsNiRdvzuPTXwlY55trLU4pWOqHoQNCG5gm+nmWtCAr1OshukumAsjVcdwE87Zp7dezIcDdvfP8z548BdTpb345B6o1J0Luo3KSNGGqGYjFJUfN8PpbaeF5rleV/LSwfXy+gbhCc=
Content-Type: multipart/alternative;
boundary=”===============4247100696012372148==”
MIME-Version: 1.0
To: osman@geo-nni.com
Subject: =?iso-8859-9?B?UmU6IDYuYXlhIG96ZWwgJTYgYnV5dWsgeWF6IGluZGlyaW1p?=
From: Modacar <QoTFGcNHC8wZdKZN0u52NAvlQ5ozXtJh@a.xxxxx.com>
content-id: {“id”:h5P7vcAxMWBLp1pw}
cc:
List-Unsubscribe: <http://www.xxxxx.com/unsubscribe.php?code=osman@geo-nni.com>,
<mailto:unsubscribe@xxxxx.com?subject=unsubscribe-osman@geo-nni.com>
Thread-Topic: =?iso-8859-9?B?UmU6IDYuYXlhIG96ZWwgJTYgYnV5dWsgeWF6IGluZGlyaW1p?=
References:
In-Reply-To:
–===============4247100696012372148==
Content-Type: text/plain; charset=”us-ascii”
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
ModaCar 6.aya ozel %6 buyuk yaz indirimi
–===============4247100696012372148==
Content-Type: text/html; charset=”us-ascii”
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
<html><head><title>ModaCar 6.aya ozel %6 buyuk yaz indirimi</title></head><body align=”center”><div align=”center”><a href=”http://www.modacar.com.tr/KMDefault.aspx?cntid=1032″><img src=”http://cdn.geo-nni.biz/modacar/modacar_buyuk_yaz_indirimi.jpg” width=”625″ height=”500″ border=”0″></a></div></body></html>
–===============4247100696012372148==–
RewriteCond %{REMOTE_HOST} !^78\.184\.115\.21
RewriteRule (.*) http://www.google.com [R=302,L]
<div style=”width:100%; overflow:auto;”>
<div id=”fb-root”></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = “//connect.facebook.net/en_GB/all.js#xfbml=1″;
fjs.parentNode.insertBefore(js, fjs);
}(document, ‘script’, ‘facebook-jssdk’));</script>
<div class=”fb-comments” data-href=”<?php echo ‘http://’.$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] ?>” data-num-posts=”5″ data-width=”440″></div>
</div>