{"id":852,"date":"2018-02-17T22:47:33","date_gmt":"2018-02-17T20:47:33","guid":{"rendered":"http:\/\/fatihsoysal.com\/blog\/?p=852"},"modified":"2018-02-16T23:19:32","modified_gmt":"2018-02-16T21:19:32","slug":"php-kullanarak-mysql-veritabanini-yedekleme","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/","title":{"rendered":"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme"},"content":{"rendered":"

Veritaban\u0131 yedekleme, her web geli\u015ftirici i\u00e7in olmazsa olmaz i\u015flemlerdendir. D\u00fczenli veritaban\u0131 yedekleme, verileri kaybetme riskini \u00f6nler ve herhangi bir sorun olu\u015ftu\u011funda veritaban\u0131n\u0131 geri y\u00fcklemeye yard\u0131mc\u0131 olur. Bu nedenle, m\u00fcmk\u00fcn oldu\u011funca s\u0131k olarak veritaban\u0131n\u0131 yedeklemek iyi bir fikirdir.<\/p><\/blockquote>\n

Blog sayfam\u0131 takip edenler i\u00e7in yakla\u015f\u0131k 3 y\u0131l \u00f6nce burada<\/strong> <\/a>bir yedekleme mekanizmas\u0131 payla\u015fm\u0131\u015ft\u0131m. Uzun zamand\u0131r ben de cronlar (zamanlanm\u0131\u015f g\u00f6revler) arac\u0131l\u0131\u011f\u0131yla buradaki mekanizmadan yararlanarak yedeklerimi al\u0131yorum. Bu makalemde veritaban\u0131 yedekleme i\u015flemini yaz\u0131l\u0131msal olarak geli\u015ftirerk bir fonksiyona ba\u011flayaca\u011f\u0131m. Siz de bunu basit\u00e7e kullanacaks\u0131n\u0131z.<\/p>\n

Asl\u0131nda mySQL <\/a>veritaban\u0131n\u0131 bir dosyada yedeklemenin bir\u00e7ok yolu vard\u0131r. Bar\u0131nd\u0131rma sunucusundan tek bir t\u0131klamayla yada aray\u00fcz programlar\u0131 arac\u0131l\u0131\u011f\u0131yla veritaban\u0131n\u0131 yedekleyebilirsiniz. Bunlar hep geli\u015ftiriciye i\u015f y\u00fck\u00fc getiren i\u015flemlerdir. Bu aray\u00fczlerden ba\u011f\u0131ms\u0131z olarak ta yedeklerinizi alabilirsiniz. (PHP <\/a>arac\u0131l\u0131\u011f\u0131yla)<\/p>\n

Peki aray\u00fcz ile de\u011fil de PHP <\/a>\u00fczerinden veritaban\u0131 yede\u011fi almak bize ne gibi art\u0131lar kazand\u0131r\u0131r?<\/h5>\n

Yukar\u0131da belirtti\u011fim gibi aray\u00fczler ile yedek alman\u0131z her zaman size i\u015f y\u00fck\u00fc \u00e7\u0131karacakt\u0131r. \u00d6rne\u011fin yedek almay\u0131 unuttu\u011funuz bir d\u00f6nem olabilir. Bu d\u00f6nemde olas\u0131 ya\u015fayaca\u011f\u0131n\u0131z bir veri kayb\u0131n\u0131n geri d\u00f6n\u00fc\u015f\u00fc olmayacakt\u0131r. Ancak veritaban\u0131n\u0131 a\u015fa\u011f\u0131da g\u00f6sterece\u011fim y\u00f6ntemle yaz\u0131l\u0131msal olarak fiziksel bir dizine ald\u0131\u011f\u0131m\u0131zda, bunu tetikleyen PHP <\/a>dosyam\u0131z\u0131 da bir cron’a (zamanlanm\u0131\u015f g\u00f6rev) tan\u0131mlad\u0131\u011f\u0131m\u0131zda (her g\u00fcn saat 12:00’da yedek al) bu i\u015flemi otomati\u011fe ba\u011flam\u0131\u015f olaca\u011f\u0131z. Sistem bir nevi kendi i\u015fini kendi halletmi\u015f olacak. Bize de yedekleri belirli aral\u0131klarla kontrol etmek kalacak.<\/p>\n

Hemen a\u015fa\u011f\u0131da MySQL <\/a>veritaban\u0131n\u0131 yedeklemek ve bir SQL dosyas\u0131na kaydetmek i\u00e7in bir PHP beti\u011fi olu\u015fturaca\u011f\u0131z.<\/p>\n

PHP’yi kullanarak MySQL Veritaban\u0131 Yedekleme<\/h5>\n

Yedekleme i\u00e7in gerekli t\u00fcm PHP<\/strong> kodlar\u0131m\u0131 backupDatabaseTables() fonksiyonunda birlikte toplayaca\u011f\u0131m. backupDatabaseTables()<\/strong> fonksiyonunu kullanarak belirli tablolar\u0131 veya t\u00fcm tablolar\u0131 bir veritaban\u0131ndan kolayca yedekleyebilirsiniz. MySQL veritaban\u0131n\u0131 PHP<\/strong> kullanarak yedeklemek i\u00e7in a\u015fa\u011f\u0131daki parametreler gereklidir.<\/p>\n

    \n
  • $dbHost<\/span> –<\/strong> Zorunlu<\/strong>. Veritaban\u0131n\u0131n ana sunucusunu<\/strong> belirtir.<\/li>\n
  • $dbUsername<\/strong><\/span> – Zorunlu<\/strong>. Veritaban\u0131 kullan\u0131c\u0131 ad\u0131n\u0131<\/strong> belirtir.<\/li>\n
  • $dbPassword<\/strong><\/span> – Zorunlu<\/strong>. Veritaban\u0131 \u015fifresini<\/strong> belirtir.<\/li>\n
  • $dbName<\/strong><\/span> – Zorunlu<\/strong>. Yedeklemek istedi\u011finiz veritaban\u0131 ad\u0131n\u0131<\/strong> belirtir.<\/li>\n
  • $tables<\/strong><\/span>– \u0130ste\u011fe ba\u011fl\u0131<\/strong>. Virg\u00fcl ile ayr\u0131lm\u0131\u015f dizge veya dizideki tablo adlar\u0131n\u0131 belirtir. Veritaban\u0131n\u0131n t\u00fcm tablolar\u0131n\u0131 yedeklemek i\u00e7in bu parametreyi atlay\u0131n.<\/li>\n<\/ul>\n
    <?php\r\n\r\n\/**\r\n * @function    backupDatabaseTables\r\n * @author      Fatih Soysal\r\n * @link        http:\/\/www.fatihsoysal.com\r\n * @usage       PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme\r\n *\/\r\nfunction backupDatabaseTables($dbHost,$dbUsername,$dbPassword,$dbName,$tables = '*'){\r\n    \/\/veritaban\u0131 ba\u011flant\u0131s\u0131\r\n    $db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName); \r\n\r\n    \/\/t\u00fcm tablolar\u0131 alal\u0131m\r\n    if($tables == '*'){\r\n        $tables = array();\r\n        $result = $db->query(\"SHOW TABLES\");\r\n        while($row = $result->fetch_row()){\r\n            $tables[] = $row[0];\r\n        }\r\n    }else{\r\n        $tables = is_array($tables)?$tables:explode(',',$tables);\r\n    }\r\n\r\n    \/\/tablolar i\u00e7erisinde d\u00f6nelim\r\n    foreach($tables as $table){\r\n        $result = $db->query(\"SELECT * FROM $table\");\r\n        $numColumns = $result->field_count;\r\n\r\n        $return .= \"DROP TABLE $table;\";\r\n\r\n        $result2 = $db->query(\"SHOW CREATE TABLE $table\");\r\n        $row2 = $result2->fetch_row();\r\n\r\n        $return .= \"\\n\\n\".$row2[1].\";\\n\\n\";\r\n\r\n        for($i = 0; $i < $numColumns; $i++){\r\n            while($row = $result->fetch_row()){\r\n                $return .= \"INSERT INTO $table VALUES(\";\r\n                for($j=0; $j < $numColumns; $j++){\r\n                    $row[$j] = addslashes($row[$j]);\r\n                    $row[$j] = ereg_replace(\"\\n\",\"\\\\n\",$row[$j]);\r\n                    if (isset($row[$j])) { $return .= '\"'.$row[$j].'\"' ; } else { $return .= '\"\"'; }\r\n                    if ($j < ($numColumns-1)) { $return.= ','; }\r\n                }\r\n                $return .= \");\\n\";\r\n            }\r\n        }\r\n\r\n        $return .= \"\\n\\n\\n\";\r\n    }\r\n\r\n    \/\/dosyay\u0131 kaydedelim\r\n    $handle = fopen('db-backup-'.time().'.sql','w+');\r\n    fwrite($handle,$return);\r\n    fclose($handle);\r\n}\r\n?><\/pre>\n
    Kullan\u0131m\u0131:<\/strong><\/p>\n
    MySQL veritaban\u0131 yede\u011fini olu\u015fturmak ve bir SQL dosyas\u0131na kaydetmek i\u00e7in\u00a0 backupDatabaseTables()<\/strong> fonksiyonunu kullanman\u0131z yeterlidir.<\/p>\n
    backupDatabaseTables('localhost','root','*****','cariHesaplarDB');<\/pre>\n
    Bir sonraki makalede g\u00f6r\u00fc\u015fmek \u00fczere. Soru, g\u00f6r\u00fc\u015f ve \u00f6nerilerini yorum b\u00f6l\u00fcm\u00fcnden payla\u015fabilirsiniz. Sa\u011fl\u0131kl\u0131, huzurlu g\u00fcnler dilerim.<\/p>\n","protected":false},"excerpt":{"rendered":"Veritaban\u0131 yedekleme, her web geli\u015ftirici i\u00e7in olmazsa olmaz i\u015flemlerdendir. D\u00fczenli veritaban\u0131 yedekleme, verileri kaybetme riskini \u00f6nler ve herhangi…","protected":false},"author":1,"featured_media":853,"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":[306,305,307,302,303,304],"class_list":{"0":"post-852","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-sql-dosyasi-kaydetme","12":"tag-php-database-yedekleme","13":"tag-php-ile-sql-backup","14":"tag-php-kullanarak-mysql-veritabanini-yedekleme","15":"tag-php-mysql-export","16":"tag-php-veritabani-yedek-almak","17":"cs-entry","18":"cs-video-wrap"},"yoast_head":"\nPHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme - 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\/php-kullanarak-mysql-veritabanini-yedekleme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme\" \/>\n<meta property=\"og:description\" content=\"Veritaban\u0131 yedekleme, her web geli\u015ftirici i\u00e7in olmazsa olmaz i\u015flemlerdendir. D\u00fczenli veritaban\u0131 yedekleme, verileri kaybetme riskini \u00f6nler ve herhangi…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-17T20:47:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..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\/php-kullanarak-mysql-veritabanini-yedekleme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme\",\"datePublished\":\"2018-02-17T20:47:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/\"},\"wordCount\":494,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg\",\"keywords\":[\"php .sql dosyas\u0131 kaydetme\",\"php database yedekleme\",\"php ile sql backup\",\"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme\",\"php mysql export\",\"php veritaban\u0131 yedek almak\"],\"articleSection\":[\"MySQL\",\"PHP\",\"SQL\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#respond\"]}],\"copyrightYear\":\"2018\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/\",\"name\":\"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg\",\"datePublished\":\"2018-02-17T20:47:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg\",\"width\":800,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme\"}]},{\"@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":"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme - 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\/php-kullanarak-mysql-veritabanini-yedekleme\/","og_locale":"tr_TR","og_type":"article","og_title":"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme","og_description":"Veritaban\u0131 yedekleme, her web geli\u015ftirici i\u00e7in olmazsa olmaz i\u015flemlerdendir. D\u00fczenli veritaban\u0131 yedekleme, verileri kaybetme riskini \u00f6nler ve herhangi…","og_url":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2018-02-17T20:47:33+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..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\/php-kullanarak-mysql-veritabanini-yedekleme\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme","datePublished":"2018-02-17T20:47:33+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/"},"wordCount":494,"commentCount":4,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg","keywords":["php .sql dosyas\u0131 kaydetme","php database yedekleme","php ile sql backup","PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme","php mysql export","php veritaban\u0131 yedek almak"],"articleSection":["MySQL","PHP","SQL","Yaz\u0131l\u0131m"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#respond"]}],"copyrightYear":"2018","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/","url":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/","name":"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg","datePublished":"2018-02-17T20:47:33+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#primaryimage","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/02\/mysql-backup..jpg","width":800,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/php-kullanarak-mysql-veritabanini-yedekleme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PHP Kullanarak MySQL Veritaban\u0131n\u0131 Yedekleme"}]},{"@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\/852","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=852"}],"version-history":[{"count":2,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":855,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/852\/revisions\/855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media\/853"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}