{"id":714,"date":"2014-02-28T20:55:23","date_gmt":"2014-02-28T18:55:23","guid":{"rendered":"http:\/\/www.gencnesil.org\/?p=714"},"modified":"2014-03-20T15:17:13","modified_gmt":"2014-03-20T13:17:13","slug":"buyuk-sql-dosyalarini-wamp-xamp-phpmyadmin-arabiriminden-eklenmesi","status":"publish","type":"post","link":"https:\/\/gncz.net\/index.php\/buyuk-sql-dosyalarini-wamp-xamp-phpmyadmin-arabiriminden-eklenmesi.html","title":{"rendered":"B\u00fcy\u00fck SQL dosyalar\u0131n\u0131 wamp-xamp Phpmyadmin arabiriminden eklenmesi"},"content":{"rendered":"<p>Phpmyadmin arabirimini kullanarak database\u2019lerimizi \u00e7ok rahat Mysql sunucusuna y\u00fckleyip \u00e7\u0131kt\u0131s\u0131n\u0131 alabiliyoruz. Fakat bu panelinde baz\u0131 s\u0131n\u0131rlar\u0131 bulunmakta<!--more-->. \u00d6rne\u011fin (sunucu ayarlar\u0131n\u0131za g\u00f6re de\u011fi\u015fken olsada) y\u00fckleyecebilece\u011finiz (import edebilece\u011finiz) SQL dosya boyutu.<\/p>\n<p>Genel olarak e\u011fer herhangi bir de\u011fi\u015fiklik yap\u0131lmad\u0131ysa y\u00fckleyebilece\u011fiz SQL dosya boyutu maksimum 2 MB\u2019d\u0131r. G\u00fcncel orta \u00f6l\u00e7ekli aktif bir projenin SQL \u00e7\u0131kt\u0131s\u0131 da ne yaz\u0131kki bu limitlerin \u00e7ok \u00fczerinde olmakta.<\/p>\n<p>Bu s\u0131n\u0131rlamay\u0131 kald\u0131rabilmek i\u00e7in yapman\u0131z gerekenleri s\u0131ralayacak olursak;<\/p>\n<p>phpmyadmin\u2019nin bulundu\u011fu dizinde olan config.inc.php dosyas\u0131n\u0131 herhangi bir edit\u00f6r yard\u0131m\u0131yla a\u00e7\u0131n.<\/p>\n<p>H:xamppphpMyAdminuploadconfig.inc.php<\/p>\n<p>Dosya i\u00e7ersindeki $cfg[&#8216;UploadDir&#8217;] sat\u0131r\u0131n\u0131 bulun. A\u015fa\u011f\u0131daki kod blo\u011fu ile de\u011fi\u015ftirin.<\/p>\n<p>$cfg[&#8216;UploadDir&#8217;] = &#8216;upload&#8217;;<\/p>\n<p>Phpmyadmin\u2019nin bulundu\u011fu dizin i\u00e7ersinde upload isimli bir klas\u00f6r olu\u015fturun.<\/p>\n<p>C:wampappsphpmyadmin3.2.0.1upload<\/p>\n<p>Y\u00fcklemek istedi\u011finiz b\u00fcy\u00fck boyuttaki SQL dosyas\u0131n\u0131 bu yeni olu\u015fturdu\u011funuz klas\u00f6r\u00fcn i\u00e7erine kopyalay\u0131n.<br \/>\nSQL verisini eklemek istedi\u011finiz i\u00e7eri aktarma (import) sayfas\u0131n\u0131 a\u00e7\u0131n. Bu sayfada \u201cweb sunucusu g\u00f6nderme dizini\u201d ba\u015fl\u0131\u011f\u0131 alt\u0131nda bir liste kutusu g\u00f6r\u00fcnt\u00fclenecektir. Bu kutudan eklemek istedi\u011finiz SQL dosyas\u0131n\u0131 se\u00e7ip veriyi i\u00e7eri aktarabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Phpmyadmin arabirimini kullanarak database\u2019lerimizi \u00e7ok rahat Mysql sunucusuna y\u00fckleyip \u00e7\u0131kt\u0131s\u0131n\u0131 alabiliyoruz. Fakat bu panelinde baz\u0131 s\u0131n\u0131rlar\u0131 bulunmakta<\/p>\n","protected":false},"author":1,"featured_media":735,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[26],"tags":[75,76,77,78],"_links":{"self":[{"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/posts\/714"}],"collection":[{"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/comments?post=714"}],"version-history":[{"count":3,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/posts\/714\/revisions"}],"predecessor-version":[{"id":783,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/posts\/714\/revisions\/783"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/media\/735"}],"wp:attachment":[{"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/media?parent=714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/categories?post=714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gncz.net\/index.php\/wp-json\/wp\/v2\/tags?post=714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}