Her geli\u015ftiricinin s\u0131k s\u0131k ve d\u00fczenli olarak ger\u00e7ekle\u015ftirmesi gereken \u00f6nemli i\u015flerden biri belki veritaban\u0131 yede\u011fi almak. Ama \u00e7o\u011fu zaman umursam\u0131yoruz, dikkat etmiyoruz. Bu umursamazl\u0131k sonucunda kimi zaman veri kay\u0131plar\u0131 ya\u015f\u0131yoruz, kimi zaman sunucu firmas\u0131 ile papaz oluyoruz. Asl\u0131nda bu i\u015flem bana g\u00f6re her g\u00fcn en az bir kez ger\u00e7ekle\u015ftirilmeli. Ba\u015fka bir senaryoda ise, database eri\u015fiminiz yok, c-panel eri\u015fiminiz yok. Ama database export alman\u0131z gerekiyor. Bunu nas\u0131l yapaca\u011f\u0131m diye kara kara d\u00fc\u015f\u00fcn\u00fcyorsunuz. Fazla d\u00fc\u015f\u00fcnmeyin, yaz\u0131n\u0131n devam\u0131nda payla\u015faca\u011f\u0131m kod dizisi ile herhangi bir aray\u00fcze gerek duymadan database export alabileceksiniz.
\nNas\u0131l m\u0131?<\/p>\n
Ge\u00e7ti\u011fimiz g\u00fcnlerde ikinci senaryoyu bizzat ya\u015fad\u0131m. Aray\u00fcz ile export almak olanaks\u0131z. Bu durum i\u00e7in istedi\u011finiz s\u00fcrede cron’lara ba\u011flayabilece\u011finiz ve kolayca backup alabilece\u011finiz fonksiyonel bir kod dizisi olu\u015fturdum.<\/p>\n
\u00d6nemli
\nFonksiyon sonucunda olu\u015fan .sql uzant\u0131l\u0131 backup dosyan\u0131z\u0131 fonksiyonu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131z dosyan\u0131n hemen yan\u0131nda ayn\u0131 dizin i\u00e7erisinde bulabileceksiniz.
\n\u00d6rnek dosya ismi: db-backup-1420632693-a449d74aa6e87d861d160b25a4221118.sql<\/p>\n
<?php\r\nbackup_tables('localhost','username','password','dbname');\r\n\/* backup the db OR just a table *\/\r\nfunction backup_tables($host,$user,$pass,$name,$tables = '*') {\r\n$link = mysql_connect($host,$user,$pass); mysql_select_db($name,$link); \/\/get all of the tables \r\nif($tables == '*') { \r\n\t$tables = array(); \r\n\t$result = mysql_query('SHOW TABLES'); \r\n\twhile($row = mysql_fetch_row($result)) { \r\n\t\t$tables[] = $row[0]; \r\n\t} \r\n} \r\nelse { $tables = is_array($tables) ? $tables : explode(',',$tables); } \/\/cycle through \r\nforeach($tables as $table) { \r\n\t$result = mysql_query('SELECT * FROM '.$table); \r\n\t$num_fields = mysql_num_fields($result); \r\n\t$return.= '\/*DROP TABLE '.$table.';*\/'; \r\n\t$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); \r\n\t$return.= \"nn\".$row2[1].\";nn\"; \r\n\tfor ($i = 0; $i < $num_fields; $i++) { \r\n\t\twhile($row = mysql_fetch_row($result)) { \r\n\t\t\t$return.= 'INSERT INTO '.$table.' VALUES('; \r\n\t\t\t\tfor($j=0; $j<$num_fields; $j++) { \r\n\t\t\t\t\t$row[$j] = addslashes($row[$j]); \r\n\t\t\t\t\t$row[$j] = ereg_replace(\"n\",\"n\",$row[$j]); \r\n\t\t\t\t\tif (isset($row[$j])) { \r\n\t\t\t\t\t\t$return.= '\"'.$row[$j].'\"' ; \r\n\t\t\t\t\t} \r\n\t\t\t\t\telse { \r\n\t\t\t\t\t\t$return.= '\"\"'; \r\n\t\t\t\t\t} \r\n\t\t\t\t\tif ($j<($num_fields-1)) { \r\n\t\t\t\t\t\t$return.= ','; \r\n\t\t\t\t\t} \r\n\t\t\t\t} \r\n\t\t\t\t\t$return.= \");n\"; \r\n} \r\n} \r\n$return.=\"nnn\"; \r\n} \/\/save file \r\n$handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+'); \r\nfwrite($handle,$return); fclose($handle); \r\n} \r\n?><\/pre>\n","protected":false},"excerpt":{"rendered":"Her geli\u015ftiricinin s\u0131k s\u0131k ve d\u00fczenli olarak ger\u00e7ekle\u015ftirmesi gereken \u00f6nemli i\u015flerden biri belki veritaban\u0131 yede\u011fi almak. Ama \u00e7o\u011fu…","protected":false},"author":1,"featured_media":37,"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,121,10],"tags":[4,11],"class_list":{"0":"post-26","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"category-sql","9":"category-yazilim","10":"tag-fatih-soysal","11":"tag-php-mysql-database-export-backup","12":"cs-entry","13":"cs-video-wrap"},"yoast_head":"\nPHP MySql Database Export - Backup - 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-mysql-database-export-backup\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP MySql Database Export - Backup\" \/>\n<meta property=\"og:description\" content=\"Her geli\u015ftiricinin s\u0131k s\u0131k ve d\u00fczenli olarak ger\u00e7ekle\u015ftirmesi gereken \u00f6nemli i\u015flerden biri belki veritaban\u0131 yede\u011fi almak. Ama \u00e7o\u011fu…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-07T20:26:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-09T19:47:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"6016\" \/>\n\t<meta property=\"og:image:height\" content=\"4016\" \/>\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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PHP MySql Database Export – Backup\",\"datePublished\":\"2015-01-07T20:26:11+00:00\",\"dateModified\":\"2018-02-09T19:47:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/\"},\"wordCount\":211,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg\",\"keywords\":[\"fatih soysal\",\"PHP MySql Database Export - Backup\"],\"articleSection\":[\"MySQL\",\"SQL\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#respond\"]}],\"copyrightYear\":\"2015\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/\",\"name\":\"PHP MySql Database Export - Backup - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg\",\"datePublished\":\"2015-01-07T20:26:11+00:00\",\"dateModified\":\"2018-02-09T19:47:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg\",\"width\":6016,\"height\":4016},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySql Database Export – Backup\"}]},{\"@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 MySql Database Export - Backup - 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-mysql-database-export-backup\/","og_locale":"tr_TR","og_type":"article","og_title":"PHP MySql Database Export - Backup","og_description":"Her geli\u015ftiricinin s\u0131k s\u0131k ve d\u00fczenli olarak ger\u00e7ekle\u015ftirmesi gereken \u00f6nemli i\u015flerden biri belki veritaban\u0131 yede\u011fi almak. Ama \u00e7o\u011fu…","og_url":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2015-01-07T20:26:11+00:00","article_modified_time":"2018-02-09T19:47:48+00:00","og_image":[{"width":6016,"height":4016,"url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg","type":"image\/jpeg"}],"author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PHP MySql Database Export – Backup","datePublished":"2015-01-07T20:26:11+00:00","dateModified":"2018-02-09T19:47:48+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/"},"wordCount":211,"commentCount":1,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg","keywords":["fatih soysal","PHP MySql Database Export - Backup"],"articleSection":["MySQL","SQL","Yaz\u0131l\u0131m"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#respond"]}],"copyrightYear":"2015","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/","url":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/","name":"PHP MySql Database Export - Backup - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg","datePublished":"2015-01-07T20:26:11+00:00","dateModified":"2018-02-09T19:47:48+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#primaryimage","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2015\/06\/shutterstockimage_of_hand_typing.jpg","width":6016,"height":4016},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/php-mysql-database-export-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PHP MySql Database Export – Backup"}]},{"@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\/26","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=26"}],"version-history":[{"count":20,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":348,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26\/revisions\/348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media\/37"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}