{"id":64,"date":"2012-09-23T12:04:35","date_gmt":"2012-09-23T09:04:35","guid":{"rendered":"http:\/\/www.sahinsolmaz.com\/blog\/?p=64"},"modified":"2012-10-22T17:17:45","modified_gmt":"2012-10-22T14:17:45","slug":"bigdump-nedir-ne-ise-yarar-nasil-kullanilir-bigdump-php-big-sql-import","status":"publish","type":"post","link":"https:\/\/sahinsolmaz.com\/blog\/bigdump-nedir-ne-ise-yarar-nasil-kullanilir-bigdump-php-big-sql-import\/","title":{"rendered":"BigDump Nedir, Ne \u0130\u015fe Yarar, Nas\u0131l Kullan\u0131l\u0131r ? BigDump.php Big SQL Import"},"content":{"rendered":"<h1>BigDump Nedir, Ne \u0130\u015fe Yarar, Nas\u0131l Kullan\u0131l\u0131r ? BigDump.php Big SQL Import<\/h1>\n<p><strong>BigDump<\/strong> Nedir ?<\/p>\n<p>BigDump, T\u00fcrk\u00e7e kelime kar\u015f\u0131l\u0131\u011f\u0131 &#8220;b\u00fcy\u00fck d\u00f6k\u00fcm&#8221; anlam\u0131na denk gelmektedir. BigDump &#8216;n amac\u0131, buradan da anla\u015f\u0131laca\u011f\u0131 gibi, b\u00fcy\u00fck boyuttaki dosyalar\u0131 sunucuya g\u00f6ndermektir.<\/p>\n<blockquote><p>\u00a0* Peki bunu farkl\u0131 y\u00f6ntemlerle de yapamaz m\u0131y\u0131z?<\/p><\/blockquote>\n<p>Evet farkl\u0131 y\u00f6ntemlerle de yap\u0131labilir, \u00f6rne\u011fin sunucu panellerideki veritaban\u0131n\u0131 i\u00e7e aktarma \u00f6zelli\u011fi kullan\u0131labilir, mesala linux sunucular\u0131ndaki plesk panel ya da cPanel sunucular\u0131nda da phpMyadmin kullan\u0131lmaktad\u0131r ve program sayesinde sitenizin veritaban\u0131na diledi\u011finiz gibi m\u00fcdahale edebiliyorsunuz, dolay\u0131s\u0131 ile\u00a0 <strong>sql<\/strong> dosyan\u0131z\u0131 da buradan import edebilirsiniz ama g\u00fcvenlik nedeni ile t\u00fcm sunucularda bir s\u0131n\u0131r vard\u0131r, genelde bu s\u0131n\u0131r <strong>2 MB<\/strong> &#8216;d\u0131r.<\/p>\n<p><strong>BigDump Ne i\u015fe yarar?<\/strong><\/p>\n<p>Bazen veritaban\u0131 dosyalar\u0131m\u0131z\u0131n boyutlar\u0131 sunucular\u0131n bize verdi\u011fi s\u0131n\u0131rdan \u00e7ok daha b\u00fcy\u00fck olabiliyor mesela d\u00fcn gece sunucuya y\u00fcklemem gereken bir veritaban\u0131n\u0131n boyutu <strong>350 MB<\/strong> idi s\u0131k\u0131\u015ft\u0131rarak k\u00fc\u00e7\u00fcltmeme ra\u011fmen <strong>50 MB<\/strong> &#8216;tan a\u015fa\u011f\u0131 inmedi, burada ise devreye <strong>BigDump<\/strong> giriyor :) Yani \u00f6zetle; <strong>BigDump sayesinde b\u00fcy\u00fck boyuttaki veritaban\u0131 yedeklerimizi kolayl\u0131kla sunucuya import edebiliriz.<\/strong><\/p>\n<p><strong>BigDump Nas\u0131l Kullan\u0131l\u0131r ?<\/strong><\/p>\n<p><a title=\"BigDump\" href=\"http:\/\/www.ozerov.de\/bigdump\/\" target=\"_blank\">Buradan<\/a> <strong>bigDump.php<\/strong> orjinal dosyas\u0131n\u0131 indirebilirsiniz ya da <span style=\"color: #ff0000;\"><a title=\"BigDump php dosyas\u0131 indir - free bidDump download Nedir, Ne \u0130\u015fe Yarar, Nas\u0131l Kullan\u0131l\u0131r ? BigDump.php Big SQL Import\" href=\"http:\/\/www.sahinsolmaz.com\/down\/bigdump.zip\"><span style=\"color: #ff0000;\"><span style=\"text-decoration: underline;\"><strong>buradan<\/strong><\/span> \u00a0<\/span><\/a><\/span>benim d\u00fczenlemi\u015f oldu\u011fum halini indirebilirsiniz (tavsiye etti\u011fim)\u00a0 ve a\u015fa\u011f\u0131daki alanlar\u0131 d\u00fczenleyiniz.<\/p>\n<p>[php]<\/p>\n<p>$db_server\u00a0\u00a0 = &#8216;localhost&#8217;;  \/\/E\u011fer farkl\u0131 bir sunucu \u00fczerinden yapacaksan\u0131z bu i\u015flemi sitenizin ip adresini yazman\u0131z gerekir.<br \/>\n$db_name\u00a0\u00a0\u00a0\u00a0 = &#8216;okul&#8217;;       \/\/veritaban\u0131 ad\u0131<br \/>\n$db_username = &#8216;sinif&#8217;;      \/\/veritaban\u0131 kullan\u0131c\u0131 ad\u0131<br \/>\n$db_password = &#8216;sifre1&#8217;;     \/\/veritaban\u0131 \u015fifresi&lt;\/pre&gt;<br \/>\n&amp;nbsp;<br \/>\n[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>BigDump Nedir, Ne \u0130\u015fe Yarar, Nas\u0131l Kullan\u0131l\u0131r ? BigDump.php Big SQL Import BigDump Nedir ? BigDump, T\u00fcrk\u00e7e kelime kar\u015f\u0131l\u0131\u011f\u0131 &#8220;b\u00fcy\u00fck d\u00f6k\u00fcm&#8221; anlam\u0131na denk gelmektedir. BigDump &#8216;n amac\u0131, buradan da anla\u015f\u0131laca\u011f\u0131 gibi, b\u00fcy\u00fck boyuttaki dosyalar\u0131 sunucuya g\u00f6ndermektir. \u00a0* Peki bunu farkl\u0131 y\u00f6ntemlerle de yapamaz m\u0131y\u0131z? Evet farkl\u0131 y\u00f6ntemlerle de yap\u0131labilir, \u00f6rne\u011fin sunucu panellerideki veritaban\u0131n\u0131 i\u00e7e aktarma [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[],"tags":[],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4sbm9-12","jetpack-related-posts":[{"id":50,"url":"https:\/\/sahinsolmaz.com\/blog\/hosting-nedir-ne-ise-yarar\/","url_meta":{"origin":64,"position":0},"title":"Hosting Nedir ? Ne i\u015fe Yarar ?","author":"SahinSOLMAZ","date":"27 Mart 2012","format":false,"excerpt":"\u00a0 Hosting Nedir ? Ne i\u015fe Yarar ? Teknik olarak Hosting; internet sitesi i\u00e7in haz\u0131rlanm\u0131\u015f, i\u00e7erik dosyalar\u0131na t\u00fcm internet baglant\u0131l\u0131 bilgisayarlar \u00fczerinden ula\u015f\u0131labilmesi i\u00e7in bu sayfalar\u0131n y\u00fcksek kapasiteli , h\u0131zl\u0131 ve s\u00fcrekli internet ba\u011flant\u0131s\u0131na sahip sunucularda tutulmas\u0131\u00a0 gerekmektedir. Bu i\u00e7erik bar\u0131nd\u0131rma hizmetine hosting ad\u0131 verilmektedir. Farkl\u0131 bir \u015fekilde \u00f6zetleyecek olursak;\u2026","rel":"","context":"Benzer yaz\u0131","block_context":{"text":"Benzer yaz\u0131","link":""},"img":{"alt_text":"Hosting Nedir ? Ne i\u015fe Yarar ?","src":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2012\/03\/hosting-nedir.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1395,"url":"https:\/\/sahinsolmaz.com\/blog\/syn-saldirisi-syn-ack-paketi-kullanilan-araclar-nelerdir-nasil-tespit-edilir-engellenir\/","url_meta":{"origin":64,"position":1},"title":"SYN Sald\u0131r\u0131s\u0131 &#8211; SYN, ACK Paketi, Kullan\u0131lan Ara\u00e7lar Nelerdir? Nas\u0131l Tespit Edilir, Engellenir ?","author":"SahinSOLMAZ","date":"5 Ocak 2017","format":false,"excerpt":"Merhabalar, \u015eu aralar aktif olarak g\u00fcvenlikle ilgililenmeye ba\u015flad\u0131m ve d\u00fczensiz olarak (:)) sizlerle g\u00fcvenlik kategorisi alt\u0131nda baz\u0131 makaleler payla\u015faca\u011f\u0131m. Bug\u00fcn SYN, SYN sald\u0131r\u0131s\u0131 nedir, SYN ve ACK paketi nedir, SYN sald\u0131r\u0131s\u0131 nas\u0131l tespit edilir, bu sald\u0131r\u0131da kullan\u0131lan ara\u00e7lar nelerdir, SYN sald\u0131r\u0131s\u0131 nas\u0131l engellenir? \u00a0ba\u015fl\u0131klar\u0131yla ba\u015flayal\u0131m. (K\u0131sa ve \u00f6z bir makale\u2026","rel":"","context":"&quot;CYBER SECURITY&quot; i\u00e7inde","block_context":{"text":"CYBER SECURITY","link":"https:\/\/sahinsolmaz.com\/blog\/category\/cyber-security\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2017\/01\/syn_attack_saldirisi_nedir_nasil_engellenir_tespit_edilir_kullanilan_araclar_syn_ack_paketi.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2017\/01\/syn_attack_saldirisi_nedir_nasil_engellenir_tespit_edilir_kullanilan_araclar_syn_ack_paketi.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2017\/01\/syn_attack_saldirisi_nedir_nasil_engellenir_tespit_edilir_kullanilan_araclar_syn_ack_paketi.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2017\/01\/syn_attack_saldirisi_nedir_nasil_engellenir_tespit_edilir_kullanilan_araclar_syn_ack_paketi.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1486,"url":"https:\/\/sahinsolmaz.com\/blog\/biraz-esperanto\/","url_meta":{"origin":64,"position":2},"title":"Biraz #Esperanto ? :)","author":"SahinSOLMAZ","date":"11 Mart 2017","format":false,"excerpt":"Merhabalar! Biraz Esperanto al\u0131r m\u0131s\u0131n\u0131z? :) \"Esperanto\" denilince ilk defa duyan kimilerine sanki bir yer ad\u0131 gibi geliyor, (bende de b\u00f6yle olmu\u015ftu:) kimilerine ise Italian bir kelime gibi gelirken, bir k\u0131sm\u0131na da Spanish bir kelime gibi gelen bu isim, asl\u0131nda yapay ve global bir dilin ad\u0131d\u0131r. 1887 y\u0131l\u0131nda, Ludwik Lejzer\u2026","rel":"","context":"&quot;Genel&quot; i\u00e7inde","block_context":{"text":"Genel","link":"https:\/\/sahinsolmaz.com\/blog\/category\/genel\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2017\/03\/Esperanto_dil_bayragi_flag_of_esperanto_Lingvo_Internacia.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":435,"url":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-mysql-dosyasini-iceri-aktarmak-importing-mysql-databases-via-ssh\/","url_meta":{"origin":64,"position":3},"title":"SSH ile MySQL Dosyas\u0131n\u0131 \u0130\u00e7eri Aktarmak-Importing MySQL Databases via SSH","author":"SahinSOLMAZ","date":"20 Mart 2014","format":false,"excerpt":"Sunucunuzda y\u00f6netim paneli (cPanel, Plesk panel vb.) kullanm\u0131yor olabilirsiniz dolay\u0131s\u0131 ile phpMyAdmin\u00a0eri\u015fimiz de olmayacakt\u0131r\u00a0ya da y\u00fcklemek istedi\u011finiz .sql\u00a0veritaban\u0131\u00a0dosyan\u0131z\u0131n boyutu b\u00fcy\u00fck oldu\u011fu i\u00e7in time-out, bir tak\u0131m problemler ya\u015fayabilirsiniz bu ve benzeri durumlarda ssh\u00a0\u00fczerinden veritaban\u0131 dosyan\u0131z\u0131 kolayl\u0131kla import edebilirsiniz. Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel)\u2026","rel":"","context":"&quot;SSH&quot; i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":294,"url":"https:\/\/sahinsolmaz.com\/blog\/java-scanner-sinifi-kullanimi\/","url_meta":{"origin":64,"position":4},"title":"Java Scanner S\u0131n\u0131f\u0131 Kullan\u0131m\u0131","author":"SahinSOLMAZ","date":"7 Nisan 2013","format":false,"excerpt":"Java\u2019da k\u00fct\u00fcphaneler paket olarak adland\u0131r\u0131l\u0131r.Paketler sistematik olarak s\u0131n\u0131fland\u0131r\u0131lm\u0131\u015flard\u0131r ve bu s\u0131n\u0131flara ula\u015f\u0131m kolayl\u0131\u011f\u0131 sa\u011flanm\u0131\u015ft\u0131r.Javada herhangi bir s\u0131n\u0131f\u0131 kullanabilmek i\u00e7in ilk \u00f6nce import etmek gerekir.Import \u015fu \u015fekilde yap\u0131l\u0131r. import java.util.Scanner; \/\/ sadece Scanner s\u0131n\u0131f\u0131n\u0131 import eder import java.util.*; \/\/ java.util paketindeki b\u00fct\u00fcn s\u0131n\u0131flar\u0131 import eder Scanner nesnesi farkl\u0131 kurucu metodlarlada kullan\u0131l\u0131r.\u2026","rel":"","context":"&quot;JAVA&quot; i\u00e7inde","block_context":{"text":"JAVA","link":"https:\/\/sahinsolmaz.com\/blog\/category\/yazilim\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":778,"url":"https:\/\/sahinsolmaz.com\/blog\/hangi-programlama-dili-nerede-kullanilir-yeni-baslayanlara-tavsiyeler-nelerdir\/","url_meta":{"origin":64,"position":5},"title":"Hangi programlama dili nerede kullan\u0131l\u0131r? Yeni ba\u015flayanlara tavsiyeler nelerdir?","author":"SahinSOLMAZ","date":"13 Ekim 2014","format":false,"excerpt":"Merhabalar, Uzun s\u00fcredir yazmak istedi\u011fim bir makale vard\u0131 ama .. bir t\u00fcrl\u00fc f\u0131rsat olmam\u0131\u015ft\u0131. Yak\u0131n zamanlarda bir arkada\u015f\u0131m i\u00e7in ara\u015ft\u0131r\u0131rken buldu\u011fum ve be\u011fenerek okudu\u011fum bir makaleyi sizlerle de payla\u015fmak istedim. \"Bu makalenin i\u00e7eri\u011finde neler var?\" Derseniz, pop\u00fcler olan neredeyse t\u00fcm programlama dillerinin genel itibari ile kullan\u0131m alanlar\u0131, ama\u00e7lar\u0131 ve olumlu\u2026","rel":"","context":"&quot;YAZILIMA G\u0130R\u0130\u015e&quot; i\u00e7inde","block_context":{"text":"YAZILIMA G\u0130R\u0130\u015e","link":"https:\/\/sahinsolmaz.com\/blog\/category\/yazilima-giris\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/10\/Hangi-programlama-dili-nerede-kullan%C4%B1l%C4%B1r-Yeni-ba%C5%9Flayanlara-tavsiyeler-nelerdir-Merak-edebilece%C4%9Finiz-bir-%C3%A7ok-sorunun-cevab%C4%B1-bu-yaz%C4%B1l%C4%B1ma-giri%C5%9F-makalesinde-mevcut..jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":0,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"wp:attachment":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}