{"id":847,"date":"2018-02-15T22:51:30","date_gmt":"2018-02-15T20:51:30","guid":{"rendered":"http:\/\/fatihsoysal.com\/blog\/?p=847"},"modified":"2018-02-15T15:25:38","modified_gmt":"2018-02-15T13:25:38","slug":"mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/","title":{"rendered":"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme"},"content":{"rendered":"<blockquote><p>Merhaba, veritaban\u0131 geri getirme yada import i\u015flemleri bildi\u011finiz \u00fczere genellikle, phpMyAdmin&#8217;in i\u00e7e aktarma b\u00f6l\u00fcm\u00fcnden, yada veritaban\u0131 i\u015flem programlar\u0131n\u0131n restore b\u00f6l\u00fcmlerinden yap\u0131l\u0131r. MySQL veritabanlar\u0131n\u0131n tablolar\u0131n\u0131 ve datalar\u0131n\u0131 geri y\u00fcklemek i\u00e7in \u00e7e\u015fitli se\u00e7enekler mevcuttur. SQL dosyas\u0131n\u0131 veritaban\u0131na aktarmak i\u00e7in bar\u0131nd\u0131rma sunucunuza, aray\u00fcz ara\u00e7lar\u0131na yada phpMyAdmin&#8217;e giri\u015f yapman\u0131z gerekir. Ancak, bu i\u015flem PHP kod betikleri ile de yap\u0131labilir. Bu makalede PHP betikleri yard\u0131m\u0131yla DB restore i\u015flemini \u00f6\u011frenmi\u015f olacaks\u0131n\u0131z.<\/p><\/blockquote>\n<p>PHP dosyas\u0131ndan veritaban\u0131n\u0131 geri y\u00fcklemek, kullan\u0131c\u0131n\u0131n web uygulamas\u0131ndan veritaban\u0131n\u0131 geri y\u00fcklemesine izin vermek istedi\u011finizde \u00e7ok i\u015finize yarayacak bir i\u015flemdir. Tabi bir o kadar da tehlikeli bir i\u015flemdir. MySQL veritaban\u0131 tablolar\u0131n\u0131 i\u00e7e aktarmak i\u00e7in \u00f6nce veritaban\u0131n\u0131n yede\u011finin al\u0131nmas\u0131 gerekir. Bu makalede, PHP&#8217;yi kullanarak SQL dosyas\u0131ndan veritaban\u0131n\u0131 nas\u0131l geri y\u00fckleyece\u011fimizi g\u00f6sterece\u011fim. Basit PHP beti\u011fimiz, MySQL veritaban\u0131n\u0131 SQL dosyas\u0131ndan geri y\u00fcklemeye yard\u0131mc\u0131 olacak.<\/p>\n<h5>PHP kullanarak MySQL Veritaban\u0131 Geri Y\u00fckleme<\/h5>\n<p>Daha i\u015flevsel kullan\u0131labilirlik i\u00e7in t\u00fcm PHP kodlar\u0131n\u0131 restoreDatabaseTables() fonksiyonunda toplad\u0131m. PHP arac\u0131l\u0131\u011f\u0131yla restoreDatabaseTables() fonksiyonunu kullanarak, veritaban\u0131ndaki tablolar\u0131 .sql dosyas\u0131ndan geri y\u00fckleyebilirsiniz. MySQL veritaban\u0131n\u0131 geri y\u00fcklemek i\u00e7in a\u015fa\u011f\u0131daki parametreler gereklidir.<\/p>\n<ul>\n<li><strong><span style=\"color: #ff0000;\">$dbHost<\/span> &#8211;<\/strong> <strong>Zorunlu<\/strong>. Veritaban\u0131n\u0131n ana <strong>sunucusunu<\/strong> belirtir.<\/li>\n<li><span style=\"color: #ff0000;\"><strong>$dbUsername<\/strong><\/span> &#8211; <strong>Zorunlu<\/strong>. Veritaban\u0131 <strong>kullan\u0131c\u0131 ad\u0131n\u0131<\/strong> belirtir.<\/li>\n<li><span style=\"color: #ff0000;\"><strong>$dbPassword<\/strong><\/span> &#8211; <strong>Zorunlu<\/strong>. Veritaban\u0131 <strong>\u015fifresini<\/strong> belirtir.<\/li>\n<li><span style=\"color: #ff0000;\"><strong>$dbName<\/strong><\/span> &#8211; <strong>Zorunlu<\/strong>. Yedeklemek istedi\u011finiz veritaban\u0131 <strong>ad\u0131n\u0131<\/strong> belirtir.<\/li>\n<li><span style=\"color: #ff0000;\"><strong>$filePath<\/strong><\/span>&#8211; <strong>Zorunlu<\/strong>. SQL dosyas\u0131n\u0131n, tablolar\u0131n geri y\u00fcklenece\u011fi <strong>yolu<\/strong> belirtir.<\/li>\n<\/ul>\n<pre class=\"lang:php decode:true\">\/**\r\n * @function    restoreDatabaseTables\r\n * @author      Fatih Soysal\r\n * @link        http:\/\/www.fatihsoysal.com\r\n * @usage       MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme\r\n *\/\r\nfunction restoreDatabaseTables($dbHost, $dbUsername, $dbPassword, $dbName, $filePath){\r\n    \/\/ Veritaban\u0131 ba\u011flant\u0131s\u0131\r\n    $db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName); \r\n\r\n    \/\/ Ge\u00e7ici de\u011fi\u015fken, ge\u00e7erli sorguyu depolamak i\u00e7in kullan\u0131l\u0131r\r\n    $templine = '';\r\n    \r\n    \/\/ T\u00fcm dosyay\u0131 oku\r\n    $lines = file($filePath);\r\n    \r\n    $error = '';\r\n    \r\n    \/\/ Her sat\u0131r i\u00e7in d\u00f6nelim\r\n    foreach ($lines as $line){\r\n        \/\/ Skip it if it's a comment\r\n        if(substr($line, 0, 2) == '--' || $line == ''){\r\n            continue;\r\n        }\r\n        \r\n        \/\/ Bu sat\u0131r\u0131 ge\u00e7erli segmente ekle\r\n        $templine .= $line;\r\n        \r\n        if (substr(trim($line), -1, 1) == ';'){\r\n            \/\/ Perform the query\r\n            if(!$db-&gt;query($templine)){\r\n                $error .= 'Error performing query \"&lt;b&gt;' . $templine . '&lt;\/b&gt;\": ' . $db-&gt;error . '&lt;br \/&gt;&lt;br \/&gt;';\r\n            }\r\n            \r\n            \/\/ Ge\u00e7ici de\u011fi\u015fkeni s\u0131f\u0131rlayal\u0131m\r\n            $templine = '';\r\n        }\r\n    }\r\n    return !empty($error)?$error:true;\r\n}<\/pre>\n<p><strong>Kullan\u0131m\u0131:<\/strong><\/p>\n<p>SQL dosyas\u0131ndan MySQL veritaban\u0131n\u0131 geri y\u00fcklemek i\u00e7in yukar\u0131da yazm\u0131\u015f oldu\u011fumuz restoreDatabaseTables() fonksiyonunu kullanmam\u0131z yeterli.<\/p>\n<pre class=\"lang:php decode:true \">$dbHost     = 'localhost';\r\n$dbUsername = 'root';\r\n$dbPassword = 'ABC132';\r\n$dbName     = 'DB_TEST';\r\n$filePath   = 'YEDEK\/15.02.18.sql';\r\n\r\nrestoreDatabaseTables($dbHost, $dbUsername, $dbPassword, $dbName, $filePath);<\/pre>\n<p>Makalemi okudu\u011funuz i\u00e7in te\u015fekk\u00fcr ederim. Bir sonraki makalede g\u00f6r\u00fc\u015fmek \u00fczere. Soru, g\u00f6r\u00fc\u015f ve \u00f6nerileriniz i\u00e7in alt taraftan yorum b\u00f6l\u00fcm\u00fcn\u00fc kullanabilirsiniz. Sa\u011fl\u0131kla, huzurla kal\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"Merhaba, veritaban\u0131 geri getirme yada import i\u015flemleri bildi\u011finiz \u00fczere genellikle, phpMyAdmin&#8217;in i\u00e7e aktarma b\u00f6l\u00fcm\u00fcnden, yada veritaban\u0131 i\u015flem programlar\u0131n\u0131n&hellip;","protected":false},"author":1,"featured_media":850,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[138,133,121,10],"tags":[299,301,298,300,296,297],"class_list":{"0":"post-847","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"category-php","9":"category-sql","10":"category-yazilim","11":"tag-php-mysql-geri-yukleme","12":"tag-php-mysql-veritabani-import","13":"tag-php-sql-geri-yukleme","14":"tag-php-sql-import","15":"tag-php-sql-restore","16":"tag-php-veritabani-yukleme","17":"cs-entry","18":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme\" \/>\n<meta property=\"og:description\" content=\"Merhaba, veritaban\u0131 geri getirme yada import i\u015flemleri bildi\u011finiz \u00fczere genellikle, phpMyAdmin&#8217;in i\u00e7e aktarma b\u00f6l\u00fcm\u00fcnden, yada veritaban\u0131 i\u015flem programlar\u0131n\u0131n&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-15T20:51:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme\",\"datePublished\":\"2018-02-15T20:51:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\"},\"wordCount\":366,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg\",\"keywords\":[\"php mysql geri y\u00fckleme\",\"php mysql veritaban\u0131 import\",\"php sql geri y\u00fckleme\",\"php sql import\",\"php sql restore\",\"php veritaban\u0131 y\u00fckleme\"],\"articleSection\":[\"MySQL\",\"PHP\",\"SQL\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#respond\"]}],\"copyrightYear\":\"2018\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\",\"name\":\"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg\",\"datePublished\":\"2018-02-15T20:51:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg\",\"width\":800,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/","og_locale":"tr_TR","og_type":"article","og_title":"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme","og_description":"Merhaba, veritaban\u0131 geri getirme yada import i\u015flemleri bildi\u011finiz \u00fczere genellikle, phpMyAdmin&#8217;in i\u00e7e aktarma b\u00f6l\u00fcm\u00fcnden, yada veritaban\u0131 i\u015flem programlar\u0131n\u0131n&hellip;","og_url":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2018-02-15T20:51:30+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg","type":"image\/jpeg"}],"author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme","datePublished":"2018-02-15T20:51:30+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/"},"wordCount":366,"commentCount":1,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg","keywords":["php mysql geri y\u00fckleme","php mysql veritaban\u0131 import","php sql geri y\u00fckleme","php sql import","php sql restore","php veritaban\u0131 y\u00fckleme"],"articleSection":["MySQL","PHP","SQL","Yaz\u0131l\u0131m"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#respond"]}],"copyrightYear":"2018","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/","url":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/","name":"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg","datePublished":"2018-02-15T20:51:30+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#primaryimage","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/php-mysql-restore.jpg","width":800,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-veritabanini-php-kullanarak-sql-dosyasindan-geri-yukleme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Veritaban\u0131n\u0131 PHP Kullanarak SQL Dosyas\u0131ndan Geri Y\u00fckleme"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=847"}],"version-history":[{"count":2,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/847\/revisions"}],"predecessor-version":[{"id":851,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/847\/revisions\/851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media\/850"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}