{"id":1713,"date":"2022-10-10T11:31:41","date_gmt":"2022-10-10T11:31:41","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=1713"},"modified":"2022-10-10T11:32:54","modified_gmt":"2022-10-10T11:32:54","slug":"cpanel-mysql-veritabanlarini-ssh-ile-yedekleme-veya-geri-yukleme","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/cpanel-mysql-veritabanlarini-ssh-ile-yedekleme-veya-geri-yukleme\/","title":{"rendered":"cPanel: MySQL Veritabanlar\u0131n\u0131 SSH ile Yedekleme veya Geri Y\u00fckleme"},"content":{"rendered":"<p>Bu makale, <a href=\"https:\/\/sunucucozumleri.com\/sunucu\/sanal-sunucu\/\"><strong>Sanal Sunucu<\/strong><\/a> veya <a href=\"https:\/\/sunucucozumleri.com\/blog\/sunucu\/fiziksel-sunucu\/\">fiziksel sunucu<\/a> hizmeti kullanan bir \u00e7ok m\u00fc\u015fterimizin sormu\u015f oldu\u011fu soru oldu\u011fundan dolay\u0131 bug\u00fcn itibariyle bilgi bankam\u0131za eklenmi\u015ftir.<\/p>\n<p>cPanel\/WHM \u00e7al\u0131\u015ft\u0131ran Linux sunucular\u0131 ve <a href=\"https:\/\/sunucucozumleri.com\/blog\/sunucu\/sanal-sunucu\/\">VPS<\/a> \u00f6rnekleri i\u00e7in ge\u00e7erlidir. cPanel sunucunuzdaki komut sat\u0131r\u0131 (SSH) arac\u0131l\u0131\u011f\u0131yla bir veritaban\u0131n\u0131 yedeklemeniz, bo\u015faltman\u0131z veya geri y\u00fcklemeniz gerekiyorsa okumaya devam edin.<\/p>\n<p><strong>MySQL Veritaban\u0131n\u0131 Geri Y\u00fcklemek <\/strong><\/p>\n<p>Bir MySQL veritaban\u0131n\u0131n mevcut bir .sql yede\u011fini geri y\u00fcklemek i\u00e7in, a\u015fa\u011f\u0131daki mysql komutunu root veya y\u00fckseltilmi\u015f ayr\u0131cal\u0131klara sahip bir kullan\u0131c\u0131 olarak \u00e7al\u0131\u015ft\u0131r\u0131n.<br \/>\n<code><br \/>\nmysql db_name &lt; db_name.sql<br \/>\n<\/code><br \/>\n\u201cdb_name\u201d yerine geri y\u00fcklemek istedi\u011finiz veritaban\u0131n\u0131n ad\u0131n\u0131 yazmal\u0131s\u0131n\u0131z, \u00f6rne\u011fin \u201cwp_myblog\u201d.<br \/>\nBirka\u00e7 veritaban\u0131n\u0131n birle\u015fik bir .sql d\u00f6k\u00fcm\u00fcne sahip olman\u0131z durumunda, s\u00f6zdizimi ile geri y\u00fcklenecek tek veritaban\u0131n\u0131 belirtin:<br \/>\n<code><br \/>\nmysql --one-database db_name &lt; multidbs.sql<br \/>\n<\/code><\/p>\n<h2>MySQL Veritaban\u0131 Yedekleme<\/h2>\n<p>mysqldump komutu , MySQL veritabanlar\u0131n\u0131n metin dosyas\u0131 d\u0131\u015fa aktar\u0131m\u0131n\u0131 olu\u015fturur. Ortaya \u00e7\u0131kan .sql dosyalar\u0131, daha sonra \u00e7o\u011faltma veya geri y\u00fckleme i\u00e7in veritaban\u0131n\u0131n bir g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fc olu\u015fturmak i\u00e7in kullan\u0131labilir. Tek bir veritaban\u0131n\u0131 bo\u015faltmak i\u00e7in, veritaban\u0131n\u0131 bo\u015faltmak \u00fczere a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n ve \u00e7\u0131kt\u0131 metnini bir .sql dosyas\u0131na yaz\u0131n:<br \/>\n<code><br \/>\nmysqldump db_name &gt; db_name.sql<br \/>\n<\/code><br \/>\nAyn\u0131 .sql d\u00f6k\u00fcm\u00fcne birden \u00e7ok veritaban\u0131n\u0131 da aktarabilirsiniz. Bu komutta \u201cdb_name1\u201d ve \u201cdb_name2\u201d birlikte d\u0131\u015fa aktar\u0131lacak bireysel veritabanlar\u0131n\u0131n adlar\u0131d\u0131r.<br \/>\n<code><br \/>\nmysqldump --databases db_name1 db_name2 &gt; databases.sql<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu makale, Sanal Sunucu veya fiziksel sunucu hizmeti kullanan bir \u00e7ok m\u00fc\u015fterimizin sormu\u015f oldu\u011fu soru oldu\u011fundan dolay\u0131 bug\u00fcn itibariyle bilgi bankam\u0131za eklenmi\u015ftir. cPanel\/WHM \u00e7al\u0131\u015ft\u0131ran Linux sunucular\u0131 ve VPS \u00f6rnekleri i\u00e7in ge\u00e7erlidir. cPanel sunucunuzdaki komut sat\u0131r\u0131 (SSH) arac\u0131l\u0131\u011f\u0131yla bir veritaban\u0131n\u0131 yedeklemeniz, bo\u015faltman\u0131z veya geri y\u00fcklemeniz gerekiyorsa okumaya devam edin. MySQL Veritaban\u0131n\u0131 Geri Y\u00fcklemek Bir MySQL veritaban\u0131n\u0131n &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1444,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7,5],"tags":[],"class_list":["post-1713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=1713"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1444"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}