{"id":2584,"date":"2023-01-02T20:35:13","date_gmt":"2023-01-02T20:35:13","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=2584"},"modified":"2023-01-02T20:35:13","modified_gmt":"2023-01-02T20:35:13","slug":"mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/","title":{"rendered":"MySQL Veritaban\u0131n\u0131 Otomatik ve Manuel Olarak Yedeklemenin 10 Yolu"},"content":{"rendered":"<div class=\"featured-snippet-bullet-points\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Makale \u0130\u00e7eri\u011fi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#MySQL_Veritabani_Nasil_Yedeklenir\" >MySQL Veritaban\u0131 Nas\u0131l Yedeklenir<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#1_MySQL_veritabanini_otomatik_olarak_Amazon_S3e_yedekleyin\" >1. MySQL veritaban\u0131n\u0131 otomatik olarak Amazon S3\u2019e yedekleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#2_Linuxta_MySQL_Veritabanini_otomatik_olarak_yedekleyin\" >2. Linux\u2019ta MySQL Veritaban\u0131n\u0131 otomatik olarak yedekleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#3_MySQL_Veritabanini_AutoMySQLBackup_ile_otomatik_olarak_yedekleyin\" >3. MySQL Veritaban\u0131n\u0131 AutoMySQLBackup ile otomatik olarak yedekleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#4_MySQLDump_ile_Yedekleyin\" >4. MySQLDump ile Yedekleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#5_PHP_Kullanarak_Bir_XML_Dosyasina_Yedekleyin\" >5. PHP Kullanarak Bir XML Dosyas\u0131na Yedekleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#6_Yedeklemek_icin_PHP_kullanin\" >6. Yedeklemek i\u00e7in PHP kullan\u0131n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#7_SSH_ile_Yedekleme\" >7. SSH ile Yedekleme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#8_Ubuntu_Linux_Yedekleme_MySQL_Sunucu_Kabugu_Komut_Dosyasi_ile_Yedekleme\" >8. Ubuntu Linux Yedekleme MySQL Sunucu Kabu\u011fu Komut Dosyas\u0131 ile Yedekleme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#9_Backup_MySQL_database_and_web_server_files_to_an_FTP_server_automatically\" >9. Backup MySQL database and web server files to an FTP server automatically<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#10_Backup_MySQL_Database_with_phpMyAdmin\" >10. Backup MySQL Database with phpMyAdmin<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#1_cPanel_gibi_web_barindirma_kontrol_panelinizden_phpMyAdmini_acin\" >1. cPanel gibi web bar\u0131nd\u0131rma kontrol panelinizden phpMyAdmin\u2019i a\u00e7\u0131n.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#2_phpMyAdminin_kenar_cubugu_gezinme_panelinden_veritabanini_secin\" >2. phpMyAdmin\u2019in kenar \u00e7ubu\u011fu gezinme panelinden veritaban\u0131n\u0131 se\u00e7in.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#3_Ust_gezinti_cubugundan_Disa_Aktar_baglantisini_tiklayin\" >3. \u00dcst gezinti \u00e7ubu\u011fundan D\u0131\u015fa Aktar ba\u011flant\u0131s\u0131n\u0131 t\u0131klay\u0131n.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#4_Disa_Aktar_sayfasinda_Ozel_secenegini_belirleyin\" >4. D\u0131\u015fa Aktar sayfas\u0131nda \u00d6zel se\u00e7ene\u011fini belirleyin.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#5_Yedeklemek_istediginiz_tablolari_secin\" >5. Yedeklemek istedi\u011finiz tablolar\u0131 se\u00e7in.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#6_Sikistirma_icin_sikistirilmis_secenegi_secin_ve_gerisini_oldugu_gibi_birakin\" >6. S\u0131k\u0131\u015ft\u0131rma i\u00e7in s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f se\u00e7ene\u011fi se\u00e7in ve gerisini oldu\u011fu gibi b\u0131rak\u0131n.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/sunucucozumleri.com\/blog\/mysql-veritabanini-otomatik-ve-manuel-olarak-yedeklemenin-10-yolu\/#7_Git_dugmesine_tiklayin_ardindan_yedekleme_dosyaniz_otomatik_olarak_indirilecektir\" >7. Git d\u00fc\u011fmesine t\u0131klay\u0131n, ard\u0131ndan yedekleme dosyan\u0131z otomatik olarak indirilecektir.<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"featured-snippet-bullet-points-title\"><span class=\"ez-toc-section\" id=\"MySQL_Veritabani_Nasil_Yedeklenir\"><\/span>MySQL Veritaban\u0131 Nas\u0131l Yedeklenir<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol class=\"featured-snippet-bullet-points-list\">\n<li>cPanel gibi web bar\u0131nd\u0131rma kontrol panelinizden\u00a0<strong>phpMyAdmin\u2019i<\/strong>\u00a0a\u00e7\u0131n .<\/li>\n<li>phpMyAdmin\u2019in kenar \u00e7ubu\u011fu gezinme panelinden veritaban\u0131n\u0131 se\u00e7in.<\/li>\n<li>\u00dcst gezinme \u00e7ubu\u011fundan\u00a0<strong>D\u0131\u015fa Aktar<\/strong>\u00a0ba\u011flant\u0131s\u0131n\u0131 t\u0131klay\u0131n .<\/li>\n<li>D\u0131\u015fa Aktar sayfas\u0131nda\u00a0<strong>\u00d6zel<\/strong>\u00a0se\u00e7ene\u011fini belirleyin.<\/li>\n<li>Yedeklemek istedi\u011finiz tablolar\u0131 se\u00e7in.<\/li>\n<li><strong>S\u0131k\u0131\u015ft\u0131rma<\/strong>\u00a0i\u00e7in s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f se\u00e7ene\u011fi\u00a0se\u00e7in ve\u00a0<strong>gerisini<\/strong>\u00a0oldu\u011fu gibi b\u0131rak\u0131n.<\/li>\n<li><strong>Git<\/strong>\u00a0d\u00fc\u011fmesine t\u0131klay\u0131n,\u00a0ard\u0131ndan yedekleme dosyan\u0131z otomatik olarak indirilecektir.<\/li>\n<\/ol>\n<\/div>\n<p>MySQL, etkile\u015fimli Web Sitelerinin geli\u015ftirilmesi i\u00e7in en pop\u00fcler a\u00e7\u0131k kaynakl\u0131 veritaban\u0131 y\u00f6netim sistemlerinden biridir.<\/p>\n<p>Siteniz hassas verilerini bir MySQL veritaban\u0131nda sakl\u0131yorsa, herhangi bir felaket durumunda geri y\u00fcklenebilmesi i\u00e7in kesinlikle bu bilgileri yedeklemek isteyeceksiniz (hepimiz oradayd\u0131k).<\/p>\n<p>MySQL verilerini yedeklemenin birka\u00e7 yolu vard\u0131r.\u00a0Bu yaz\u0131m\u0131zda veritabanlar\u0131n\u0131z\u0131 farkl\u0131 y\u00f6ntemler kullanarak nas\u0131l yedekleyece\u011finize bakaca\u011f\u0131z, ayr\u0131ca\u00a0s\u00fcreci kolayla\u015ft\u0131rmak i\u00e7in\u00a0<strong>otomatik yedekleme \u00e7\u00f6z\u00fcm\u00fcne nas\u0131l ula\u015faca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenece\u011fiz.\u00a0<\/strong>MySQL ile birlikte gelen mysqldump yard\u0131mc\u0131 program\u0131ndan ba\u015flayarak, veritaban\u0131n\u0131z\u0131n bir dosyaya, ba\u015fka bir sunucuya ve hatta s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir gzip dosyas\u0131na yedeklenmesi dahil olmak \u00fczere mysqldump kullanarak birka\u00e7 \u00f6rne\u011fi inceleyece\u011fiz ve e-postan\u0131za g\u00f6nderece\u011fiz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_MySQL_veritabanini_otomatik_olarak_Amazon_S3e_yedekleyin\"><\/span>1. MySQL veritaban\u0131n\u0131 otomatik olarak Amazon S3\u2019e yedekleyin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00c7o\u011fu kullan\u0131c\u0131, mysql veritabanlar\u0131n\u0131 yedeklemek i\u00e7in Amazon S3\u2019\u00fc kullan\u0131r.\u00a0\u0130\u015fte bir mysql veritaban\u0131n\u0131n yede\u011fini alma ve ard\u0131ndan onu Amazon S3\u2019e ta\u015f\u0131ma g\u00f6revini yerine getiren otomatik bir betik.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Linuxta_MySQL_Veritabanini_otomatik_olarak_yedekleyin\"><\/span>2. Linux\u2019ta MySQL Veritaban\u0131n\u0131 otomatik olarak yedekleyin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre class=\"wp-block-preformatted\">15 2 * * * root mysqldump -u root -pPASSWORD --t\u00fcm veritabanlar\u0131 | gzip &gt; \/mnt\/disk2\/database_`data ' %m-%d-%Y'`.sql.gz \r\n<\/pre>\n<p>Bu g\u00f6nderi, bir linux kullan\u0131c\u0131s\u0131ysan\u0131z, MySQL Veritaban\u0131n\u0131 otomatik olarak nas\u0131l yedekleyece\u011finizi g\u00f6sterecektir.\u00a0MySQL veritaban\u0131n\u0131z\u0131 otomatik olarak yedeklemek i\u00e7in cron\u2019u kullanabilirsiniz.\u201dcron\u201d, Unix\/Linux<br \/>\ni\u015fletim sisteminde zamana dayal\u0131 bir zamanlama yard\u0131mc\u0131 program\u0131d\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_MySQL_Veritabanini_AutoMySQLBackup_ile_otomatik_olarak_yedekleyin\"><\/span>3. MySQL Veritaban\u0131n\u0131 AutoMySQLBackup ile otomatik olarak yedekleyin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>AutoMySQLBackup\u2019\u0131n\u00a0baz\u0131 harika \u00f6zellikleri vard\u0131r: tek bir veritaban\u0131n\u0131, birden \u00e7ok veritaban\u0131n\u0131 veya sunucudaki t\u00fcm veritabanlar\u0131n\u0131 yedekleme;\u00a0her veritaban\u0131, s\u0131k\u0131\u015ft\u0131r\u0131labilen (gzip veya bzip2 ile) ayr\u0131 bir dosyaya kaydedilir;\u00a0yedeklemeleri d\u00f6nd\u00fcrecek ve sabit diskinizi doldurmalar\u0131na engel olacakt\u0131r (g\u00fcnl\u00fck yedeklemede normal olarak yaln\u0131zca son 7 g\u00fcnl\u00fck yedeklemeye sahip olacaks\u0131n\u0131z, etkinle\u015ftirildiyse haftal\u0131k yedekleme her hafta i\u00e7in bir yedeklemeye sahip olacakt\u0131r, vb.).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_MySQLDump_ile_Yedekleyin\"><\/span>4. MySQLDump ile Yedekleyin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre class=\"wp-block-preformatted\">mysqldump ---kullan\u0131c\u0131 [kullan\u0131c\u0131 ad\u0131] ---\u015fifre=[\u015fifre]  \r\n[veritaban\u0131 ad\u0131] &gt; [d\u00f6k\u00fcm dosyas\u0131]\r\n<\/pre>\n<p>Bu yaz\u0131da, MySQL ile birlikte gelen mysqldump yard\u0131mc\u0131 program\u0131n\u0131 kullanarak veritabanlar\u0131m\u0131z\u0131 nas\u0131l yedekleyece\u011fimize bakaca\u011f\u0131z.<br \/>\nVeritaban\u0131n\u0131z\u0131n bir dosyaya, ba\u015fka bir sunucuya ve hatta s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir gzip dosyas\u0131na\u00a0yedeklenmesi dahil, mysqldump kullan\u0131larak birka\u00e7 \u00f6rnek incelenecektir .<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_PHP_Kullanarak_Bir_XML_Dosyasina_Yedekleyin\"><\/span>5. PHP Kullanarak Bir XML Dosyas\u0131na Yedekleyin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>XML, bir tabloyu geri y\u00fcklemek i\u00e7in en kolay bi\u00e7im de\u011fildir, ancak okunmas\u0131 daha kolay olabilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Yedeklemek_icin_PHP_kullanin\"><\/span>6. Yedeklemek i\u00e7in PHP kullan\u0131n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>PHP dosyas\u0131ndan bir veritaban\u0131 yedekleme sorgusu y\u00fcr\u00fct\u00fcn.\u00a0Tablo yede\u011fi olu\u015fturmak i\u00e7in SELECT INTO OUTFILE sorgusunu kullanman\u0131n bir \u00f6rne\u011fi a\u015fa\u011f\u0131dad\u0131r:<\/p>\n<pre class=\"wp-block-preformatted\">&lt;?php\r\n'config.php'yi dahil edin;\r\n'opendb.php'yi dahil edin;\r\n\r\n$tableName = 'evcil hayvan\u0131m';\r\n$backupFile = 'yedekleme\/mypet.sql';\r\n$query = \"$tableName'DEN OUTFILE '$backupFile' \u0130\u00c7\u0130NDE * SE\u00c7\u0130N\";\r\n$ sonu\u00e7 = mysql_query($query);\r\n\r\n'closedb.php'yi dahil edin;\r\n?&gt;\r\n<\/pre>\n<p>Yede\u011fi geri y\u00fcklemek i\u00e7in, LOAD DATA INFILE sorgusunu \u015fu \u015fekilde \u00e7al\u0131\u015ft\u0131rman\u0131z yeterlidir:<\/p>\n<pre class=\"wp-block-preformatted\">&lt;?php\r\n'config.php'yi dahil edin;\r\n'opendb.php'yi dahil edin;\r\n\r\n$tableName = 'evcil hayvan\u0131m';\r\n$backupFile = 'mypet.sql';\r\n$query = \"DATA DATA 'backupFile'\u0131 TABLOYA Y\u00dcKLE $tableName\";\r\n$ sonu\u00e7 = mysql_query($query);\r\n\r\n'closedb.php'yi dahil edin;\r\n?&gt;\r\n<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"7_SSH_ile_Yedekleme\"><\/span>7. SSH ile Yedekleme<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00fcy\u00fck MySQL veritabanlar\u0131n\u0131z\u0131 SSH arac\u0131l\u0131\u011f\u0131yla yedeklemek i\u00e7in basit bir \u00e7\u00f6z\u00fcm.\u00a0SSH arac\u0131l\u0131\u011f\u0131yla sunucunuza giri\u015f yapmak i\u00e7in Plesk kontrol panelinizden kabuk eri\u015fimini etkinle\u015ftirmeniz ve PuTTY gibi bir yard\u0131mc\u0131 program kullanman\u0131z gerekecektir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Ubuntu_Linux_Yedekleme_MySQL_Sunucu_Kabugu_Komut_Dosyasi_ile_Yedekleme\"><\/span>8. Ubuntu Linux Yedekleme MySQL Sunucu Kabu\u011fu Komut Dosyas\u0131 ile Yedekleme<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you have a dedicated <a href=\"https:\/\/sunucucozumleri.com\/blog\/sunucu\/sanal-sunucu\/\">VPS<\/a> server running Ubuntu Linux. Here is how to backup all your mysql server databases to your ftp server<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Backup_MySQL_database_and_web_server_files_to_an_FTP_server_automatically\"><\/span>9. Backup MySQL database and web server files to an FTP server automatically<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is a simple backup solution for people who run their own web server and MySQL server on a dedicated box or VPS. The main advantage of using FTP or <a href=\"https:\/\/sunucucozumleri.com\/blog\/nas-nedir-ne-ise-yarar\/\">NAS<\/a> backup is a protection from data loss.First you will need to backup each database with mysqldump command, Automating tasks of backup with tar, Setup a cron job and generate FTP backup script.<\/p>\n<pre class=\"wp-block-preformatted\">$ mysqldump -u root -h localhost -pmypassword faqs | gzip -9 &gt; faqs-db.sql.gz\r\n<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"10_Backup_MySQL_Database_with_phpMyAdmin\"><\/span>10. Backup MySQL Database with phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You can easily create a dump file(export\/backup) of a database used by your account. In order to do so you should access the phpMyAdmin tool available in your cPanel.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"1_cPanel_gibi_web_barindirma_kontrol_panelinizden_phpMyAdmini_acin\"><\/span><strong>1. cPanel gibi web bar\u0131nd\u0131rma kontrol panelinizden phpMyAdmin\u2019i a\u00e7\u0131n.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"wp-block-image\">\n<h4><span class=\"ez-toc-section\" id=\"2_phpMyAdminin_kenar_cubugu_gezinme_panelinden_veritabanini_secin\"><\/span><strong>2. phpMyAdmin\u2019in kenar \u00e7ubu\u011fu gezinme panelinden veritaban\u0131n\u0131 se\u00e7in.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"wp-block-image\">\n<h4><span class=\"ez-toc-section\" id=\"3_Ust_gezinti_cubugundan_Disa_Aktar_baglantisini_tiklayin\"><\/span><strong>3. \u00dcst gezinti \u00e7ubu\u011fundan D\u0131\u015fa Aktar ba\u011flant\u0131s\u0131n\u0131 t\u0131klay\u0131n.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"wp-block-image\">\n<h4><span class=\"ez-toc-section\" id=\"4_Disa_Aktar_sayfasinda_Ozel_secenegini_belirleyin\"><\/span><strong>4. D\u0131\u015fa Aktar sayfas\u0131nda \u00d6zel se\u00e7ene\u011fini belirleyin.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"wp-block-image\">\n<p>D\u0131\u015fa aktar sayfas\u0131nda iki se\u00e7enek olacak;\u00a0<strong>H\u0131zl\u0131<\/strong>\u00a0ve\u00a0<strong>\u00d6zel<\/strong>\u00a0.\u00a0<strong>Custom<\/strong>\u00a0se\u00e7ene\u011fini\u00a0se\u00e7elim .<\/p>\n<h4><span class=\"ez-toc-section\" id=\"5_Yedeklemek_istediginiz_tablolari_secin\"><\/span><strong>5. Yedeklemek istedi\u011finiz tablolar\u0131 se\u00e7in.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"wp-block-image\">\n<p>Custom se\u00e7ene\u011fini se\u00e7ti\u011finizde sayfa bize yedeklerini almak istedi\u011fimiz tablolar\u0131 se\u00e7me imkan\u0131 verecektir.\u00a0Neyi se\u00e7ece\u011finizden emin de\u011filseniz, oldu\u011fu gibi b\u0131rak\u0131n;\u00a0t\u00fcm tablolar varsay\u0131lan olarak se\u00e7ilidir.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"6_Sikistirma_icin_sikistirilmis_secenegi_secin_ve_gerisini_oldugu_gibi_birakin\"><\/span><strong>6. S\u0131k\u0131\u015ft\u0131rma i\u00e7in s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f se\u00e7ene\u011fi se\u00e7in ve gerisini oldu\u011fu gibi b\u0131rak\u0131n.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"wp-block-image\">\n<p>Bir sonraki ad\u0131m s\u0131k\u0131\u015ft\u0131rmad\u0131r.\u00a0Sayfan\u0131n ortas\u0131nda bize \u00e7ok zaman kazand\u0131racak olan s\u0131k\u0131\u015ft\u0131rma se\u00e7ene\u011fini g\u00f6receksiniz.\u00a0S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f se\u00e7ene\u011fi se\u00e7in ve gerisini oldu\u011fu gibi b\u0131rak\u0131n.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"7_Git_dugmesine_tiklayin_ardindan_yedekleme_dosyaniz_otomatik_olarak_indirilecektir\"><\/span><strong>7. Git d\u00fc\u011fmesine t\u0131klay\u0131n, ard\u0131ndan yedekleme dosyan\u0131z otomatik olarak indirilecektir.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Veritaban\u0131 Nas\u0131l Yedeklenir cPanel gibi web bar\u0131nd\u0131rma kontrol panelinizden\u00a0phpMyAdmin\u2019i\u00a0a\u00e7\u0131n . phpMyAdmin\u2019in kenar \u00e7ubu\u011fu gezinme panelinden veritaban\u0131n\u0131 se\u00e7in. \u00dcst gezinme \u00e7ubu\u011fundan\u00a0D\u0131\u015fa Aktar\u00a0ba\u011flant\u0131s\u0131n\u0131 t\u0131klay\u0131n . D\u0131\u015fa Aktar sayfas\u0131nda\u00a0\u00d6zel\u00a0se\u00e7ene\u011fini belirleyin. Yedeklemek istedi\u011finiz tablolar\u0131 se\u00e7in. S\u0131k\u0131\u015ft\u0131rma\u00a0i\u00e7in s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f se\u00e7ene\u011fi\u00a0se\u00e7in ve\u00a0gerisini\u00a0oldu\u011fu gibi b\u0131rak\u0131n. Git\u00a0d\u00fc\u011fmesine t\u0131klay\u0131n,\u00a0ard\u0131ndan yedekleme dosyan\u0131z otomatik olarak indirilecektir. MySQL, etkile\u015fimli Web Sitelerinin geli\u015ftirilmesi i\u00e7in en pop\u00fcler a\u00e7\u0131k kaynakl\u0131 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":2391,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-2584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/2584","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=2584"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/2584\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/2391"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=2584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=2584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=2584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}