{"id":35805,"date":"2025-12-04T01:40:47","date_gmt":"2025-12-03T22:40:47","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=35805"},"modified":"2025-12-04T01:40:47","modified_gmt":"2025-12-03T22:40:47","slug":"mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/","title":{"rendered":"MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber"},"content":{"rendered":"<p><body><\/p>\n<h2>MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber<\/h2>\n<p>Veritaban\u0131 y\u00f6netimi, modern yaz\u0131l\u0131m geli\u015ftirmenin ve sistem operasyonlar\u0131n\u0131n temel ta\u015flar\u0131ndan biridir. MySQL ve MariaDB, d\u00fcnya genelinde en yayg\u0131n kullan\u0131lan a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemleridir (RDBMS). Bu sistemlerde veritaban\u0131 yedekleme, ta\u015f\u0131ma, geli\u015ftirme ortamlar\u0131 aras\u0131nda senkronizasyon veya felaket kurtarma gibi \u00e7e\u015fitli senaryolarda veritaban\u0131 ithalat\u0131 (import) ve ihracat\u0131 (export) i\u015flemleri hayati \u00f6nem ta\u015f\u0131r. Bu makale, MySQL ve MariaDB veritabanlar\u0131n\u0131 farkl\u0131 y\u00f6ntemlerle nas\u0131l ba\u015far\u0131l\u0131 bir \u015fekilde d\u0131\u015fa aktaraca\u011f\u0131n\u0131z\u0131 ve i\u00e7e aktaraca\u011f\u0131n\u0131z\u0131 ayr\u0131nt\u0131l\u0131 olarak ele alacakt\u0131r.<\/p>\n<p>Veritaban\u0131 i\u015flemlerinde veri g\u00fcvenli\u011fi ve b\u00fct\u00fcnl\u00fc\u011f\u00fc her zaman \u00f6nceliklidir. \u0130hracat ve ithalat s\u00fcre\u00e7leri, verilerinizin g\u00fcvenli\u011fini sa\u011flamak ve olas\u0131 veri kay\u0131plar\u0131n\u0131 \u00f6nlemek i\u00e7in dikkatle y\u00fcr\u00fct\u00fclmelidir. \u0130ster k\u00fc\u00e7\u00fck bir ki\u015fisel proje, ister b\u00fcy\u00fck \u00f6l\u00e7ekli bir kurumsal uygulama y\u00f6netiyor olun, bu i\u015flemlerin inceliklerini bilmek size zaman kazand\u0131racak ve kritik durumlarda veri kayb\u0131n\u0131 \u00f6nleyecektir.<\/p>\n<p>Bu rehberde, komut sat\u0131r\u0131 ara\u00e7lar\u0131 (mysqldump ve mysql), pop\u00fcler web tabanl\u0131 aray\u00fcz phpMyAdmin ve g\u00fc\u00e7l\u00fc masa\u00fcst\u00fc uygulamas\u0131 MySQL Workbench gibi farkl\u0131 ara\u00e7lar\u0131 kullanarak veritaban\u0131 i\u015flemlerini ger\u00e7ekle\u015ftirmeyi \u00f6\u011freneceksiniz. Her y\u00f6ntemin kendine \u00f6zg\u00fc avantajlar\u0131 ve kullan\u0131m senaryolar\u0131 bulunmaktad\u0131r.<\/p>\n<h3>Veritaban\u0131 \u0130hracat\u0131n\u0131n (Export) Temelleri<\/h3>\n<p>Veritaban\u0131 ihracat\u0131, bir veritaban\u0131n\u0131n veya belirli tablolar\u0131n\u0131n yap\u0131s\u0131n\u0131 (schema) ve\/veya verilerini bir dosyaya kaydetme i\u015flemidir. Bu dosya genellikle SQL format\u0131nda olur ve veritaban\u0131n\u0131 yeniden olu\u015fturmak i\u00e7in gerekli t\u00fcm SQL komutlar\u0131n\u0131 i\u00e7erir.<\/p>\n<h4>Neden Veritaban\u0131 \u0130hracat\u0131 Yap\u0131l\u0131r?<\/h4>\n<p>*   <strong>Yedekleme:<\/strong> Veri kayb\u0131 durumunda geri y\u00fcklemek i\u00e7in d\u00fczenli yedekler almak.<br \/>\n*   <strong>Ta\u015f\u0131ma (Migration):<\/strong> Veritaban\u0131n\u0131 bir sunucudan ba\u015fka bir sunucuya ta\u015f\u0131mak.<br \/>\n*   <strong>Geli\u015ftirme Ortamlar\u0131:<\/strong> Canl\u0131 veritaban\u0131n\u0131 yerel geli\u015ftirme ortam\u0131na kopyalamak.<br \/>\n*   <strong>Replikasyon:<\/strong> Birincil veritaban\u0131ndan ikincil veritabanlar\u0131na veri aktarmak.<br \/>\n*   <strong>Analiz:<\/strong> Verileri ba\u015fka bir araca veya sisteme aktarmak i\u00e7in d\u0131\u015fa aktarmak.<\/p>\n<h3>Komut Sat\u0131r\u0131 Kullanarak Veritaban\u0131 \u0130hracat\u0131: mysqldump<\/h3>\n<p><code>mysqldump<\/code>, MySQL ve MariaDB veritabanlar\u0131n\u0131 yedeklemek i\u00e7in kullan\u0131lan en g\u00fc\u00e7l\u00fc ve esnek komut sat\u0131r\u0131 arac\u0131d\u0131r. B\u00fcy\u00fck veritabanlar\u0131 i\u00e7in idealdir ve betikler (script) arac\u0131l\u0131\u011f\u0131yla otomatize edilebilir.<\/p>\n<h4>mysqldump&#8217;\u0131n Genel S\u00f6zdizimi<\/h4>\n<pre><code class=\"language-bash\">mysqldump -u [kullan\u0131c\u0131_ad\u0131] -p[parola] [veritaban\u0131_ad\u0131] > [yedekleme_dosyas\u0131.sql]<\/code><\/pre>\n<p>*   <code>-u [kullan\u0131c\u0131_ad\u0131]<\/code>: Veritaban\u0131na ba\u011flanmak i\u00e7in kullan\u0131lacak kullan\u0131c\u0131 ad\u0131.<br \/>\n*   <code>-p[parola]<\/code>: Kullan\u0131c\u0131n\u0131n parolas\u0131. Parola ile <code>-p<\/code> aras\u0131nda bo\u015fluk b\u0131rak\u0131lmaz. E\u011fer parola belirtilmezse, komut sizden parolay\u0131 isteyecektir. G\u00fcvenlik i\u00e7in genellikle bo\u015f b\u0131rak\u0131p komutun parolay\u0131 sormas\u0131 beklenir.<br \/>\n*   <code>[veritaban\u0131_ad\u0131]<\/code>: D\u0131\u015fa aktar\u0131lacak veritaban\u0131n\u0131n ad\u0131.<br \/>\n*   <code>><\/code>: \u00c7\u0131kt\u0131y\u0131 belirtilen dosyaya y\u00f6nlendirme operat\u00f6r\u00fc.<br \/>\n*   <code>[yedekleme_dosyas\u0131.sql]<\/code>: Yedekleme verilerinin kaydedilece\u011fi dosya ad\u0131.<\/p>\n<h4>\u00d6rnekler ve \u00d6nemli Parametreler<\/h4>\n<p>1.  <strong>Tek Bir Veritaban\u0131n\u0131 D\u0131\u015fa Aktarma:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p mydatabase > mydatabase_backup.sql<\/code><\/pre>\n<p>    Bu komut, <code>root<\/code> kullan\u0131c\u0131s\u0131 ile <code>mydatabase<\/code> adl\u0131 veritaban\u0131n\u0131n t\u00fcm yap\u0131s\u0131n\u0131 ve verilerini <code>mydatabase_backup.sql<\/code> dosyas\u0131na yedekler.<\/p>\n<p>2.  <strong>T\u00fcm Veritabanlar\u0131n\u0131 D\u0131\u015fa Aktarma:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p --all-databases > all_databases_backup.sql<\/code><\/pre>\n<p>    <code>--all-databases<\/code> parametresi, sunucudaki t\u00fcm veritabanlar\u0131n\u0131 (sistem veritabanlar\u0131 dahil) yedekler.<\/p>\n<p>3.  <strong>Belirli Tablolar\u0131 D\u0131\u015fa Aktarma:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p mydatabase table1 table2 > mydatabase_tables_backup.sql<\/code><\/pre>\n<p>    <code>mydatabase<\/code> i\u00e7indeki sadece <code>table1<\/code> ve <code>table2<\/code> tablolar\u0131n\u0131 yedekler.<\/p>\n<p>4.  <strong>Sadece Veritaban\u0131 Yap\u0131s\u0131n\u0131 (Schema) D\u0131\u015fa Aktarma:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p --no-data mydatabase > mydatabase_structure.sql<\/code><\/pre>\n<p>    <code>--no-data<\/code> parametresi, sadece tablolar\u0131n, g\u00f6r\u00fcn\u00fcmlerin, prosed\u00fcrlerin vb. yap\u0131s\u0131n\u0131 yedekler, veri i\u00e7ermez.<\/p>\n<p>5.  <strong>Sadece Veriyi D\u0131\u015fa Aktarma (Yap\u0131 Olmadan):<\/strong><\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p --no-create-info mydatabase > mydatabase_data.sql<\/code><\/pre>\n<p>    <code>--no-create-info<\/code> parametresi, <code>CREATE TABLE<\/code> ifadelerini i\u00e7ermez, sadece <code>INSERT<\/code> ifadelerini yedekler. Genellikle mevcut bir veritaban\u0131 yap\u0131s\u0131na veri eklemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p>6.  <strong>S\u0131k\u0131\u015ft\u0131rma ile D\u0131\u015fa Aktarma (gzip kullanarak):<\/strong><br \/>\n    B\u00fcy\u00fck veritabanlar\u0131 i\u00e7in s\u0131k\u0131\u015ft\u0131rma, disk alan\u0131ndan tasarruf sa\u011flar ve transfer s\u00fcresini k\u0131salt\u0131r.<\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p mydatabase | gzip > mydatabase_backup.sql.gz<\/code><\/pre>\n<p>    Bu komut, <code>mysqldump<\/code> \u00e7\u0131kt\u0131s\u0131n\u0131 <code>gzip<\/code> komutuna pipe eder ve s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir <code>.gz<\/code> dosyas\u0131 olu\u015fturur.<\/p>\n<p>7.  <strong>Uzak Sunucudan Veritaban\u0131 D\u0131\u015fa Aktarma:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysqldump -h [uzak_sunucu_ip] -P [port] -u root -p mydatabase > mydatabase_remote_backup.sql<\/code><\/pre>\n<p>    *   <code>-h [uzak_sunucu_ip]<\/code>: Uzak sunucunun IP adresi veya hostname.<br \/>\n    *   <code>-P [port]<\/code>: MySQL\/MariaDB sunucusunun dinledi\u011fi port numaras\u0131 (varsay\u0131lan 3306).<\/p>\n<p>8.  <strong>InnoDB Tablolar\u0131 \u0130\u00e7in Tutarl\u0131 Yedekleme:<\/strong><br \/>\n    InnoDB tablolar\u0131 i\u00e7in veritaban\u0131 tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flamak amac\u0131yla <code>--single-transaction<\/code> parametresi \u00f6nerilir. Bu, yedekleme s\u0131ras\u0131nda veritaban\u0131 \u00fczerinde kilitlenmeyi en aza indirir.<\/p>\n<pre><code class=\"language-bash\">mysqldump -u root -p --single-transaction mydatabase > mydatabase_innodb_backup.sql<\/code><\/pre>\n<p>    <strong>\u00d6nemli:<\/strong> Bu parametre sadece InnoDB tablolar\u0131 i\u00e7in etkilidir. MyISAM tablolar\u0131 i\u00e7in <code>--lock-tables<\/code> kullan\u0131labilir ancak bu, yedekleme s\u00fcresince tablolara yazma i\u015flemlerini engeller.<\/p>\n<p>9.  <strong>Geli\u015fmi\u015f Parametreler:<\/strong><br \/>\n    *   <code>--add-drop-table<\/code>: Her <code>CREATE TABLE<\/code> ifadesinin \u00f6n\u00fcne <code>DROP TABLE IF EXISTS<\/code> ifadesini ekler. Bu, i\u00e7e aktarma s\u0131ras\u0131nda eski tablolar\u0131n \u00fczerine yaz\u0131lmas\u0131n\u0131 sa\u011flar. (Varsay\u0131lan olarak a\u00e7\u0131kt\u0131r.)<br \/>\n    *   <code>--routines<\/code>, <code>--triggers<\/code>, <code>--events<\/code>: Sakl\u0131 yordamlar\u0131, tetikleyicileri ve olaylar\u0131 yedeklemeye dahil eder. Bu parametreler \u00f6nemlidir, \u00e7\u00fcnk\u00fc varsay\u0131lan olarak yedeklenmezler.<br \/>\n    *   <code>--set-gtid-purged=OFF<\/code>: MySQL 5.6 ve \u00fczeri s\u00fcr\u00fcmlerde GTID (Global Transaction Identifiers) kullan\u0131l\u0131yorsa, replikasyon sorunlar\u0131n\u0131 \u00f6nlemek i\u00e7in bu parametre kullan\u0131labilir. Genellikle yedekleme\/geri y\u00fckleme i\u00e7in <code>OFF<\/code> olarak ayarlan\u0131r.<br \/>\n    *   <code>--master-data[=1|2]<\/code>: Yedekleme s\u0131ras\u0131nda ikili g\u00fcnl\u00fck (binary log) konumunu yedekleme dosyas\u0131na ekler. Bu, replikasyon kurulumlar\u0131 i\u00e7in kritik \u00f6neme sahiptir. <code>1<\/code> de\u011feri SQL komutu olarak ekler, <code>2<\/code> de\u011feri yorum sat\u0131r\u0131 olarak ekler.<br \/>\n    *   <code>--compact<\/code>: Daha az yorum ve bo\u015fluk i\u00e7eren daha k\u00fc\u00e7\u00fck bir \u00e7\u0131kt\u0131 dosyas\u0131 olu\u015fturur.<\/p>\n<h4>En \u0130yi Uygulamalar<\/h4>\n<p>*   <strong>G\u00fcvenlik:<\/strong> <code>root<\/code> kullan\u0131c\u0131s\u0131 yerine, sadece yedekleme i\u00e7in gerekli izinlere sahip ayr\u0131 bir kullan\u0131c\u0131 olu\u015fturun.<br \/>\n*   <strong>D\u00fczenli Yedekleme:<\/strong> Cron i\u015fleri veya zamanlanm\u0131\u015f g\u00f6revler kullanarak d\u00fczenli yedeklemeleri otomatikle\u015ftirmeyi d\u00fc\u015f\u00fcn\u00fcn.<br \/>\n*   <strong>Farkl\u0131 Lokasyonlara Depolama:<\/strong> Yedekleme dosyalar\u0131n\u0131 ana sunucudan farkl\u0131 bir fiziksel konuma veya bulut depolama alan\u0131na ta\u015f\u0131y\u0131n.<br \/>\n*   <strong>Yedekleri Test Etme:<\/strong> Yedekleme dosyalar\u0131n\u0131n ge\u00e7erlili\u011fini ve geri y\u00fcklenebilirli\u011fini periyodik olarak test edin.<\/p>\n<h3>Komut Sat\u0131r\u0131 Kullanarak Veritaban\u0131 \u0130thalat\u0131: mysql<\/h3>\n<p><code>mysql<\/code> komutu, <code>mysqldump<\/code> ile olu\u015fturulmu\u015f SQL dosyalar\u0131n\u0131 bir MySQL veya MariaDB sunucusuna i\u00e7e aktarmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n<h4>mysql&#8217;in Genel S\u00f6zdizimi<\/h4>\n<pre><code class=\"language-bash\">mysql -u [kullan\u0131c\u0131_ad\u0131] -p[parola] [hedef_veritaban\u0131_ad\u0131] < [yedekleme_dosyas\u0131.sql]<\/code><\/pre>\n<p>*   <code>-u [kullan\u0131c\u0131_ad\u0131]<\/code>: Veritaban\u0131na ba\u011flanmak i\u00e7in kullan\u0131lacak kullan\u0131c\u0131 ad\u0131.<br \/>\n*   <code>-p[parola]<\/code>: Kullan\u0131c\u0131n\u0131n parolas\u0131.<br \/>\n*   <code>[hedef_veritaban\u0131_ad\u0131]<\/code>: Verilerin i\u00e7e aktar\u0131laca\u011f\u0131 veritaban\u0131n\u0131n ad\u0131. Bu veritaban\u0131 \u00f6nceden var olmal\u0131d\u0131r.<br \/>\n*   <code><<\/code>: Giri\u015fi belirtilen dosyadan alma operat\u00f6r\u00fc.<br \/>\n*   <code>[yedekleme_dosyas\u0131.sql]<\/code>: \u0130\u00e7e aktar\u0131lacak SQL dosyas\u0131n\u0131n ad\u0131.<\/p>\n<h4>\u00d6rnekler<\/h4>\n<p>1.  <strong>Mevcut Bir Veritaban\u0131na Aktarma:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysql -u root -p mydatabase < mydatabase_backup.sql<\/code><\/pre>\n<p>    Bu komut, <code>mydatabase_backup.sql<\/code> dosyas\u0131ndaki SQL komutlar\u0131n\u0131 <code>mydatabase<\/code> adl\u0131 veritaban\u0131na uygular. E\u011fer <code>mydatabase<\/code> zaten varsa ve yedekleme dosyas\u0131nda <code>DROP TABLE IF EXISTS<\/code> ifadeleri varsa, mevcut tablolar silinip yeniden olu\u015fturulacakt\u0131r.<\/p>\n<p>2.  <strong>Yeni Bir Veritaban\u0131 Olu\u015fturup Aktarma:<\/strong><br \/>\n    E\u011fer hedef veritaban\u0131 yoksa, \u00f6nce olu\u015fturman\u0131z gerekir:<\/p>\n<pre><code class=\"language-bash\">mysql -u root -p -e \"CREATE DATABASE new_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\"\n    mysql -u root -p new_database_name < mydatabase_backup.sql<\/code><\/pre>\n<p>    \u0130lk komut <code>new_database_name<\/code> ad\u0131nda yeni bir veritaban\u0131 olu\u015fturur (karakter seti ve harmanlama ayarlar\u0131yla birlikte). \u0130kinci komut yedekleme dosyas\u0131n\u0131 bu yeni veritaban\u0131na aktar\u0131r.<\/p>\n<p>3.  <strong>S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f Dosyay\u0131 Aktarma (gunzip kullanarak):<\/strong><br \/>\n    Daha \u00f6nce <code>gzip<\/code> ile s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir yedekleme dosyas\u0131n\u0131 i\u00e7e aktarmak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">gunzip < mydatabase_backup.sql.gz | mysql -u root -p mydatabase<\/code><\/pre>\n<p>    Bu komut, s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyay\u0131 a\u00e7ar ve \u00e7\u0131kt\u0131s\u0131n\u0131 do\u011frudan <code>mysql<\/code> komutuna pipe eder.<\/p>\n<h4>\u00d6nemli Notlar<\/h4>\n<p>*   <strong>Hedef Veritaban\u0131n\u0131n Varl\u0131\u011f\u0131:<\/strong> \u0130\u00e7e aktarma yapmadan \u00f6nce hedef veritaban\u0131n\u0131n var oldu\u011fundan emin olun veya yukar\u0131daki \u00f6rnekteki gibi olu\u015fturun.<br \/>\n*   <strong>Karakter Setleri:<\/strong> Veritaban\u0131 ve yedekleme dosyas\u0131n\u0131n karakter setlerinin uyumlu oldu\u011fundan emin olun. Aksi takdirde, T\u00fcrk\u00e7e karakterler veya \u00f6zel karakterlerde bozulmalar ya\u015fanabilir. Genellikle <code>utf8mb4<\/code> ve <code>utf8mb4_unicode_ci<\/code> tercih edilir.<br \/>\n*   <strong>B\u00fcy\u00fck Dosyalar \u0130\u00e7in:<\/strong> \u00c7ok b\u00fcy\u00fck SQL dosyalar\u0131n\u0131 i\u00e7e aktar\u0131rken, komut sat\u0131r\u0131 genellikle en g\u00fcvenilir y\u00f6ntemdir. phpMyAdmin gibi web tabanl\u0131 ara\u00e7larda PHP zaman a\u015f\u0131m\u0131 veya bellek s\u0131n\u0131rlar\u0131 nedeniyle sorunlar ya\u015fanabilir.<br \/>\n*   <strong>Hata Ay\u0131klama:<\/strong> \u0130\u00e7e aktarma s\u0131ras\u0131nda bir hata olu\u015fursa, <code>mysql<\/code> komutu genellikle hatay\u0131 ve sat\u0131r numaras\u0131n\u0131 bildirir. Bu, sorunu tespit etmek i\u00e7in faydal\u0131d\u0131r.<br \/>\n*   <strong><code>FOREIGN KEY<\/code> K\u0131s\u0131tlamalar\u0131:<\/strong> E\u011fer yedekleme dosyas\u0131nda <code>FOREIGN KEY<\/code> k\u0131s\u0131tlamalar\u0131 varsa ve tablolar do\u011fru s\u0131rayla olu\u015fturulmam\u0131\u015fsa, i\u00e7e aktarma ba\u015far\u0131s\u0131z olabilir. Bu durumda, ge\u00e7ici olarak yabanc\u0131 anahtar kontrollerini devre d\u0131\u015f\u0131 b\u0131rakmak faydal\u0131 olabilir:<\/p>\n<pre><code class=\"language-sql\">SET FOREIGN_KEY_CHECKS=0;\n    -- SQL i\u00e7eri\u011finiz buraya gelecek\n    SET FOREIGN_KEY_CHECKS=1;<\/code><\/pre>\n<p>    Bu komutlar\u0131 SQL dosyas\u0131n\u0131n ba\u015f\u0131na ve sonuna ekleyebilirsiniz.<\/p>\n<h3>phpMyAdmin Kullanarak Veritaban\u0131 \u0130hracat\u0131 ve \u0130thalat\u0131<\/h3>\n<p>phpMyAdmin, MySQL ve MariaDB veritabanlar\u0131n\u0131 web tabanl\u0131 bir aray\u00fcz \u00fczerinden y\u00f6netmek i\u00e7in yayg\u0131n olarak kullan\u0131lan \u00fccretsiz bir ara\u00e7t\u0131r. \u00d6zellikle grafik aray\u00fcz\u00fc tercih edenler ve k\u00fc\u00e7\u00fck\/orta \u00f6l\u00e7ekli veritabanlar\u0131 i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n<h4>phpMyAdmin ile \u0130hracat (Export)<\/h4>\n<p>1.  <strong>phpMyAdmin'e Giri\u015f:<\/strong> Web taray\u0131c\u0131n\u0131zdan phpMyAdmin'e eri\u015fin ve kullan\u0131c\u0131 ad\u0131\/parolan\u0131zla giri\u015f yap\u0131n.<br \/>\n2.  <strong>Veritaban\u0131 Se\u00e7imi:<\/strong> Sol panelden d\u0131\u015fa aktarmak istedi\u011finiz veritaban\u0131n\u0131 se\u00e7in.<br \/>\n3.  <strong>\"Export\" Sekmesine T\u0131klay\u0131n:<\/strong> \u00dcst men\u00fcden \"Export\" sekmesine t\u0131klay\u0131n.<br \/>\n4.  <strong>D\u0131\u015fa Aktarma Y\u00f6ntemini Se\u00e7in:<\/strong><br \/>\n    *   <strong>Quick (H\u0131zl\u0131):<\/strong> \u00c7o\u011fu durumda yeterlidir. Varsay\u0131lan ayarlarla (SQL format\u0131, s\u0131k\u0131\u015ft\u0131rma yok) t\u00fcm veritaban\u0131n\u0131 d\u0131\u015fa aktar\u0131r.<br \/>\n    *   <strong>Custom (\u00d6zel):<\/strong> Daha fazla kontrol sa\u011flar.<br \/>\n        *   <strong>Tables:<\/strong> Belirli tablolar\u0131 se\u00e7ebilirsiniz.<br \/>\n        *   <strong>Output:<\/strong> Format (SQL, CSV, XML vb.), s\u0131k\u0131\u015ft\u0131rma (None, zipped, gzipped) ve dosya ad\u0131.<br \/>\n        *   <strong>Format-specific options (SQL):<\/strong> <code>DROP TABLE<\/code> ekleme, <code>AUTO_INCREMENT<\/code> de\u011ferlerini s\u0131f\u0131rlama, <code>FOREIGN KEY<\/code> kontrollerini devre d\u0131\u015f\u0131 b\u0131rakma gibi se\u00e7enekler.<br \/>\n        *   <strong>Data dump options:<\/strong> Veri ekleme (<code>INSERT<\/code>) veya g\u00fcncelleme (<code>UPDATE<\/code>) format\u0131.<\/p>\n<p>5.  <strong>\"Go\" Butonuna T\u0131klay\u0131n:<\/strong> Se\u00e7eneklerinizi belirledikten sonra \"Go\" butonuna t\u0131klay\u0131n. phpMyAdmin, yedekleme dosyas\u0131n\u0131 otomatik olarak bilgisayar\u0131n\u0131za indirecektir.<\/p>\n<h4>phpMyAdmin ile \u0130thalat (Import)<\/h4>\n<p>1.  <strong>phpMyAdmin'e Giri\u015f:<\/strong> phpMyAdmin'e giri\u015f yap\u0131n.<br \/>\n2.  <strong>Hedef Veritaban\u0131n\u0131 Se\u00e7in:<\/strong> Sol panelden verileri i\u00e7e aktarmak istedi\u011finiz veritaban\u0131n\u0131 se\u00e7in. E\u011fer yeni bir veritaban\u0131na aktaracaksan\u0131z, \u00f6nce \"Databases\" sekmesinden yeni bir veritaban\u0131 olu\u015fturun ve sonra onu se\u00e7in.<br \/>\n3.  <strong>\"Import\" Sekmesine T\u0131klay\u0131n:<\/strong> \u00dcst men\u00fcden \"Import\" sekmesine t\u0131klay\u0131n.<br \/>\n4.  <strong>Dosya Se\u00e7imi:<\/strong> \"Choose File\" veya \"Dosya Se\u00e7\" butonuna t\u0131klayarak bilgisayar\u0131n\u0131zdaki <code>.sql<\/code> veya <code>.sql.gz<\/code> dosyas\u0131n\u0131 se\u00e7in.<br \/>\n5.  <strong>Karakter Seti ve Format:<\/strong> Dosyan\u0131n karakter setinin do\u011fru oldu\u011fundan emin olun (genellikle <code>utf8mb4<\/code>). Format\u0131n \"SQL\" olarak se\u00e7ili oldu\u011fundan emin olun.<br \/>\n6.  <strong>\"Go\" Butonuna T\u0131klay\u0131n:<\/strong> \"Go\" butonuna t\u0131klad\u0131\u011f\u0131n\u0131zda phpMyAdmin, SQL dosyas\u0131n\u0131 veritaban\u0131na i\u00e7e aktarmaya ba\u015flayacakt\u0131r. \u0130\u015flem tamamland\u0131\u011f\u0131nda bir ba\u015far\u0131 mesaj\u0131 alacaks\u0131n\u0131z.<\/p>\n<h4>phpMyAdmin S\u0131n\u0131rlamalar\u0131<\/h4>\n<p>*   <strong>Dosya Boyutu S\u0131n\u0131r\u0131:<\/strong> phpMyAdmin, PHP'nin <code>upload_max_filesize<\/code> ve <code>post_max_size<\/code> ayarlar\u0131yla s\u0131n\u0131rl\u0131d\u0131r. B\u00fcy\u00fck dosyalar\u0131 (genellikle 2MB-50MB aras\u0131) do\u011frudan phpMyAdmin \u00fczerinden i\u00e7e aktarmakta sorun ya\u015fayabilirsiniz. Bu durumda, PHP ayarlar\u0131n\u0131 y\u00fckseltmeniz veya komut sat\u0131r\u0131 y\u00f6ntemini kullanman\u0131z gerekir.<br \/>\n*   <strong>Zaman A\u015f\u0131m\u0131:<\/strong> B\u00fcy\u00fck dosyalar\u0131n i\u015flenmesi uzun s\u00fcrebilir ve PHP <code>max_execution_time<\/code> ayar\u0131 nedeniyle zaman a\u015f\u0131m\u0131 hatas\u0131 alabilirsiniz.<\/p>\n<h3>MySQL Workbench Kullanarak Veritaban\u0131 \u0130hracat\u0131 ve \u0130thalat\u0131<\/h3>\n<p>MySQL Workbench, MySQL ve MariaDB veritaban\u0131 geli\u015ftiricileri ve y\u00f6neticileri i\u00e7in tasarlanm\u0131\u015f kapsaml\u0131 bir grafiksel ara\u00e7t\u0131r. Veritaban\u0131 tasar\u0131m\u0131, geli\u015ftirme, y\u00f6netim ve yedekleme\/geri y\u00fckleme gibi bir\u00e7ok \u00f6zelli\u011fi tek bir aray\u00fczde sunar.<\/p>\n<h4>MySQL Workbench ile \u0130hracat (Data Export)<\/h4>\n<p>1.  <strong>MySQL Workbench'i A\u00e7\u0131n:<\/strong> MySQL Workbench'i ba\u015flat\u0131n ve veritaban\u0131 sunucunuza bir ba\u011flant\u0131 kurun.<br \/>\n2.  <strong>\"Server\" Men\u00fcs\u00fc:<\/strong> \u00dcst men\u00fcden \"Server\" -> \"Data Export\" se\u00e7ene\u011fini t\u0131klay\u0131n.<br \/>\n3.  <strong>Veritaban\u0131 ve Tablo Se\u00e7imi:<\/strong><br \/>\n    *   Sol panelde d\u0131\u015fa aktarmak istedi\u011finiz \u015femalar\u0131 (veritabanlar\u0131n\u0131) ve tablolar\u0131 se\u00e7in. T\u00fcm \u015femay\u0131 se\u00e7mek i\u00e7in \u015fema ad\u0131n\u0131 t\u0131klayabilirsiniz.<br \/>\n    *   Sa\u011f panelde, se\u00e7ilen \u015feman\u0131n tablolar\u0131n\u0131 g\u00f6receksiniz. Belirli tablolar\u0131 d\u0131\u015fa aktarmak i\u00e7in bunlar\u0131 se\u00e7ebilirsiniz.<br \/>\n4.  <strong>Export Options (D\u0131\u015fa Aktarma Se\u00e7enekleri):<\/strong><br \/>\n    *   <strong>Dump Structure Only:<\/strong> Sadece veritaban\u0131 yap\u0131s\u0131n\u0131 d\u0131\u015fa aktar\u0131r.<br \/>\n    *   <strong>Dump Data Only:<\/strong> Sadece verileri d\u0131\u015fa aktar\u0131r.<br \/>\n    *   <strong>Dump Structure and Data:<\/strong> Hem yap\u0131y\u0131 hem de verileri d\u0131\u015fa aktar\u0131r (varsay\u0131lan).<br \/>\n    *   <strong>Include Stored Procedures, Functions, Events, Triggers:<\/strong> Sakl\u0131 yordamlar\u0131, fonksiyonlar\u0131, olaylar\u0131 ve tetikleyicileri dahil etmek i\u00e7in bu kutucuklar\u0131 i\u015faretleyin.<br \/>\n5.  <strong>Output Options (\u00c7\u0131kt\u0131 Se\u00e7enekleri):<\/strong><br \/>\n    *   <strong>Export to Self-Contained File:<\/strong> T\u00fcm yedeklemeyi tek bir <code>.sql<\/code> dosyas\u0131na kaydeder (\u00f6nerilen).<br \/>\n    *   <strong>Export to Separate Files:<\/strong> Her tabloyu ayr\u0131 bir <code>.sql<\/code> dosyas\u0131na kaydeder.<br \/>\n    *   <strong>Create Dump in a Single Transaction:<\/strong> InnoDB i\u00e7in tutarl\u0131 bir yedekleme sa\u011flar (mysqldump'taki <code>--single-transaction<\/code> gibi).<br \/>\n    *   <strong>Include Create Schema:<\/strong> Yedekleme dosyas\u0131na <code>CREATE SCHEMA<\/code> ifadesini ekler.<br \/>\n    *   <strong>Compression:<\/strong> Yedekleme dosyas\u0131n\u0131 s\u0131k\u0131\u015ft\u0131rma se\u00e7ene\u011fi sunar.<br \/>\n    *   <strong>Target Directory:<\/strong> Yedekleme dosyas\u0131n\u0131n kaydedilece\u011fi klas\u00f6r\u00fc se\u00e7in.<br \/>\n6.  <strong>\"Start Export\" Butonuna T\u0131klay\u0131n:<\/strong> \u0130\u015flem tamamland\u0131\u011f\u0131nda bir ba\u015far\u0131 mesaj\u0131 alacaks\u0131n\u0131z ve yedekleme dosyas\u0131 belirtilen dizine kaydedilecektir.<\/p>\n<h4>MySQL Workbench ile \u0130thalat (Data Import\/Restore)<\/h4>\n<p>1.  <strong>MySQL Workbench'i A\u00e7\u0131n:<\/strong> MySQL Workbench'i ba\u015flat\u0131n ve veritaban\u0131 sunucunuza bir ba\u011flant\u0131 kurun.<br \/>\n2.  <strong>\"Server\" Men\u00fcs\u00fc:<\/strong> \u00dcst men\u00fcden \"Server\" -> \"Data Import\" se\u00e7ene\u011fini t\u0131klay\u0131n.<br \/>\n3.  <strong>\u0130\u00e7e Aktarma Y\u00f6ntemini Se\u00e7in:<\/strong><br \/>\n    *   <strong>Import from Self-Contained File:<\/strong> Tek bir <code>.sql<\/code> dosyas\u0131ndan i\u00e7e aktarmak i\u00e7in bu se\u00e7ene\u011fi kullan\u0131n.<br \/>\n        *   \"...\" butonuna t\u0131klayarak yedekleme dosyan\u0131z\u0131 se\u00e7in.<br \/>\n    *   <strong>Import from Dump Project Folder:<\/strong> Birden fazla dosyadan olu\u015fan bir yedekleme projesi klas\u00f6r\u00fcnden i\u00e7e aktarmak i\u00e7in bu se\u00e7ene\u011fi kullan\u0131n.<br \/>\n4.  <strong>Hedef \u015eema (Schema):<\/strong><br \/>\n    *   <strong>Default Target Schema:<\/strong> Yedekleme dosyas\u0131nda belirtilen \u015fema ad\u0131n\u0131 kullan\u0131r.<br \/>\n    *   <strong>New:<\/strong> Yeni bir \u015fema olu\u015fturup ona aktarmak i\u00e7in bir isim girin.<br \/>\n    *   <strong>Existing:<\/strong> Mevcut bir \u015femaya aktarmak i\u00e7in listeden se\u00e7in.<br \/>\n5.  <strong>\"Start Import\" Butonuna T\u0131klay\u0131n:<\/strong> \u0130\u015flem tamamland\u0131\u011f\u0131nda bir ba\u015far\u0131 mesaj\u0131 alacaks\u0131n\u0131z.<\/p>\n<h3>S\u0131k Kar\u015f\u0131la\u015f\u0131lan Sorunlar ve \u00c7\u00f6z\u00fcmleri<\/h3>\n<p>Veritaban\u0131 ithalat\u0131 ve ihracat\u0131 s\u0131ras\u0131nda \u00e7e\u015fitli sorunlarla kar\u015f\u0131la\u015fmak m\u00fcmk\u00fcnd\u00fcr. \u0130\u015fte baz\u0131 yayg\u0131n sorunlar ve \u00e7\u00f6z\u00fcmleri:<\/p>\n<p>1.  <strong>Karakter Seti Uyu\u015fmazl\u0131klar\u0131:<\/strong><br \/>\n    *   <strong>Sorun:<\/strong> \u0130\u00e7e aktar\u0131lan verilerde T\u00fcrk\u00e7e karakterler (\u00e7, \u011f, \u0131, \u00f6, \u015f, \u00fc) veya \u00f6zel karakterler bozuk g\u00f6r\u00fcn\u00fcyor (\u00f6rne\u011fin <code>?<\/code> veya garip semboller).<br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong><br \/>\n        *   Hem d\u0131\u015fa aktar\u0131lan veritaban\u0131n\u0131n hem de i\u00e7e aktar\u0131lan hedef veritaban\u0131n\u0131n ve yedekleme dosyas\u0131n\u0131n karakter setlerinin (\u00f6rne\u011fin <code>utf8mb4<\/code>) ve harmanlamalar\u0131n\u0131n (<code>utf8mb4_unicode_ci<\/code>) ayn\u0131 oldu\u011fundan emin olun.<br \/>\n        *   <code>mysqldump<\/code> yaparken <code>--default-character-set=utf8mb4<\/code> gibi parametreler kullan\u0131n.<br \/>\n        *   <code>mysql<\/code> ile i\u00e7e aktar\u0131rken de ayn\u0131 karakter setini belirtin veya hedef veritaban\u0131n\u0131 do\u011fru karakter setiyle olu\u015fturun.<br \/>\n        *   SQL dosyas\u0131n\u0131n ba\u015f\u0131nda <code>SET NAMES 'utf8mb4';<\/code> veya <code>SET character_set_client = utf8mb4;<\/code> gibi ifadeler eklenmesi yard\u0131mc\u0131 olabilir.<\/p>\n<p>2.  <strong>B\u00fcy\u00fck Dosya Boyutlar\u0131 ve Zaman A\u015f\u0131m\u0131:<\/strong><br \/>\n    *   <strong>Sorun:<\/strong> phpMyAdmin veya di\u011fer web tabanl\u0131 ara\u00e7lar \u00fczerinden b\u00fcy\u00fck SQL dosyalar\u0131n\u0131 i\u00e7e aktar\u0131rken hata al\u0131n\u0131yor (HTTP 500 hatas\u0131, zaman a\u015f\u0131m\u0131, bellek yetersizli\u011fi).<br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong><br \/>\n        *   <strong>Komut Sat\u0131r\u0131 Kullan\u0131n:<\/strong> En g\u00fcvenilir y\u00f6ntem <code>mysql<\/code> komut sat\u0131r\u0131 arac\u0131d\u0131r.<br \/>\n        *   <strong>PHP Ayarlar\u0131n\u0131 Y\u00fckseltin:<\/strong> php.ini dosyas\u0131nda <code>upload_max_filesize<\/code>, <code>post_max_size<\/code> ve <code>max_execution_time<\/code> de\u011ferlerini y\u00fckseltin (\u00f6rne\u011fin, 256M ve 3600 saniye). Ancak bu sadece ge\u00e7ici bir \u00e7\u00f6z\u00fcm olmal\u0131, kal\u0131c\u0131 olarak komut sat\u0131r\u0131 tercih edilmelidir.<br \/>\n        *   <strong>Dosyay\u0131 B\u00f6lme:<\/strong> \u00c7ok b\u00fcy\u00fck SQL dosyalar\u0131n\u0131 daha k\u00fc\u00e7\u00fck par\u00e7alara b\u00f6lerek i\u00e7e aktarabilirsiniz.<\/p>\n<p>3.  <strong>Eri\u015fim \u0130zinleri:<\/strong><br \/>\n    *   <strong>Sorun:<\/strong> Veritaban\u0131na ba\u011flan\u0131lam\u0131yor veya belirli i\u015flemleri ger\u00e7ekle\u015ftirmek i\u00e7in yetki hatas\u0131 al\u0131n\u0131yor.<br \/>\n    <em>   <strong>\u00c7\u00f6z\u00fcm:<\/strong> Kullan\u0131lan veritaban\u0131 kullan\u0131c\u0131s\u0131n\u0131n (\u00f6rne\u011fin <code>root<\/code> veya \u00f6zel bir kullan\u0131c\u0131) <code>SELECT<\/code>, <code>INSERT<\/code>, <code>UPDATE<\/code>, <code>DELETE<\/code>, <code>CREATE<\/code>, <code>DROP<\/code>, <code>ALTER<\/code> gibi gerekli t\u00fcm izinlere sahip oldu\u011fundan emin olun. <code>GRANT ALL PRIVILEGES ON database_name.<\/em> TO 'username'@'localhost';<\/code> gibi komutlarla izinleri g\u00fcncelleyebilirsiniz.<\/p>\n<p>4.  <strong><code>DEFINER<\/code> Hatalar\u0131:<\/strong><br \/>\n    *   <strong>Sorun:<\/strong> Sakl\u0131 yordamlar (stored procedures), fonksiyonlar veya tetikleyiciler i\u00e7e aktar\u0131l\u0131rken <code>DEFINER<\/code> hatas\u0131 al\u0131n\u0131yor. Bu, yedekleme dosyas\u0131ndaki bir kullan\u0131c\u0131n\u0131n hedef sunucuda bulunmamas\u0131ndan kaynaklan\u0131r.<br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong><br \/>\n        *   Yedekleme dosyas\u0131ndaki <code>DEFINER<\/code> ifadelerini hedef sunucudaki mevcut bir kullan\u0131c\u0131yla (\u00f6rne\u011fin <code>root@localhost<\/code>) de\u011fi\u015ftirmek i\u00e7in bir metin d\u00fczenleyici kullan\u0131n.<br \/>\n        *   Veya <code>mysqldump<\/code> komutuna <code>--set-gtid-purged=OFF<\/code> ve <code>--skip-definer<\/code> (MySQL 8.0.21'den itibaren) gibi parametreler ekleyerek <code>DEFINER<\/code> bilgilerinin d\u0131\u015fa aktar\u0131lmas\u0131n\u0131 engelleyebilirsiniz.<\/p>\n<p>5.  <strong><code>FOREIGN KEY<\/code> K\u0131s\u0131tlamalar\u0131:<\/strong><br \/>\n    *   <strong>Sorun:<\/strong> \u0130\u00e7e aktarma s\u0131ras\u0131nda <code>FOREIGN KEY<\/code> k\u0131s\u0131tlamalar\u0131 nedeniyle tablolar olu\u015fturulam\u0131yor veya veri eklenemiyor.<br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> \u0130\u00e7e aktarma i\u015fleminden \u00f6nce <code>SET FOREIGN_KEY_CHECKS=0;<\/code> komutunu \u00e7al\u0131\u015ft\u0131rarak yabanc\u0131 anahtar kontrollerini ge\u00e7ici olarak devre d\u0131\u015f\u0131 b\u0131rak\u0131n ve i\u015flem bittikten sonra <code>SET FOREIGN_KEY_CHECKS=1;<\/code> ile tekrar etkinle\u015ftirin. Bu komutlar\u0131 yedekleme SQL dosyas\u0131n\u0131n i\u00e7ine ekleyebilirsiniz.<\/p>\n<h3>En \u0130yi Uygulamalar ve G\u00fcvenlik \u0130pu\u00e7lar\u0131<\/h3>\n<p>*   <strong>D\u00fczenli ve Otomatik Yedekleme:<\/strong> Veri kayb\u0131n\u0131 \u00f6nlemek i\u00e7in d\u00fczenli yedeklemeleri otomatikle\u015ftirmek kritik \u00f6neme sahiptir. Cron i\u015fleri veya i\u015fletim sistemi zamanlay\u0131c\u0131lar\u0131 kullanarak <code>mysqldump<\/code> komutunu belirli aral\u0131klarla \u00e7al\u0131\u015ft\u0131r\u0131n.<br \/>\n*   <strong>Yedekleri Do\u011frulay\u0131n:<\/strong> Yedekleme dosyalar\u0131n\u0131n bozuk olmad\u0131\u011f\u0131ndan ve ba\u015far\u0131yla geri y\u00fcklenebildi\u011finden emin olmak i\u00e7in periyodik olarak test edin. Bozuk bir yedekleme, hi\u00e7 yedekleme yapmamaktan daha k\u00f6t\u00fc olabilir.<br \/>\n*   <strong>Yedekleme Dosyalar\u0131n\u0131 G\u00fcvenli Bir \u015eekilde Saklay\u0131n:<\/strong> Yedekleme dosyalar\u0131n\u0131 ana sunucudan ayr\u0131 bir yerde (\u00f6rne\u011fin, bulut depolama, harici disk, ba\u015fka bir sunucu) ve \u015fifreli olarak saklay\u0131n. Bu, ana sunucunun \u00e7\u00f6kmesi durumunda verilerinizi korur.<br \/>\n*   <strong>Kullan\u0131c\u0131 \u0130zinlerini K\u0131s\u0131tlay\u0131n:<\/strong> Yedekleme ve geri y\u00fckleme i\u015flemleri i\u00e7in kullan\u0131lan veritaban\u0131 kullan\u0131c\u0131lar\u0131na sadece gerekli minimum izinleri verin. <code>root<\/code> kullan\u0131c\u0131s\u0131n\u0131 gereksiz yere kullanmaktan ka\u00e7\u0131n\u0131n.<br \/>\n*   <strong>S\u0131k\u0131\u015ft\u0131rma Kullan\u0131n:<\/strong> B\u00fcy\u00fck veritabanlar\u0131 i\u00e7in <code>gzip<\/code> veya <code>bzip2<\/code> gibi ara\u00e7larla yedekleme dosyalar\u0131n\u0131 s\u0131k\u0131\u015ft\u0131rmak, disk alan\u0131ndan tasarruf sa\u011flar ve a\u011f transfer s\u00fcresini azalt\u0131r.<br \/>\n*   <strong>S\u00fcr\u00fcm Uyumlulu\u011fu:<\/strong> Veritaban\u0131n\u0131 farkl\u0131 MySQL\/MariaDB s\u00fcr\u00fcmleri aras\u0131nda ta\u015f\u0131yorsan\u0131z, s\u00fcr\u00fcm uyumlulu\u011funa dikkat edin. \u00d6zellikle b\u00fcy\u00fck s\u00fcr\u00fcm atlamalar\u0131nda (\u00f6rne\u011fin MySQL 5.x'ten 8.x'e), baz\u0131 \u00f6zellikler veya s\u00f6zdizimleri de\u011fi\u015fmi\u015f olabilir. Geriye d\u00f6n\u00fck uyumluluk sorunlar\u0131n\u0131 kontrol edin.<br \/>\n*   <strong>G\u00fcnl\u00fckleme (Logging):<\/strong> Yedekleme ve geri y\u00fckleme i\u015flemlerinin g\u00fcnl\u00fcklerini tutun. Bu, olas\u0131 sorunlar\u0131 te\u015fhis etmeye ve ge\u00e7mi\u015f i\u015flemleri izlemeye yard\u0131mc\u0131 olur.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>MySQL ve MariaDB veritabanlar\u0131n\u0131n ithalat\u0131 ve ihracat\u0131, veritaban\u0131 y\u00f6netimi prati\u011finin temel bir par\u00e7as\u0131d\u0131r. Bu makalede ele ald\u0131\u011f\u0131m\u0131z komut sat\u0131r\u0131 ara\u00e7lar\u0131 (mysqldump, mysql), web tabanl\u0131 aray\u00fcz (phpMyAdmin) ve masa\u00fcst\u00fc uygulamas\u0131 (MySQL Workbench) gibi farkl\u0131 y\u00f6ntemler, \u00e7e\u015fitli senaryolar ve kullan\u0131c\u0131 tercihleri i\u00e7in esneklik sunar.<\/p>\n<p><code>mysqldump<\/code> ve <code>mysql<\/code> komut sat\u0131r\u0131 ara\u00e7lar\u0131, b\u00fcy\u00fck veritabanlar\u0131, otomasyon ve g\u00fcvenlik a\u00e7\u0131s\u0131ndan en g\u00fc\u00e7l\u00fc ve tercih edilen y\u00f6ntemlerdir. phpMyAdmin, h\u0131zl\u0131 ve g\u00f6rsel bir aray\u00fcz arayanlar i\u00e7in k\u00fc\u00e7\u00fck ve orta \u00f6l\u00e7ekli veritabanlar\u0131nda pratik \u00e7\u00f6z\u00fcmler sunar. MySQL Workbench ise kapsaml\u0131 bir GUI deneyimi arayan geli\u015ftiriciler ve DBA'lar i\u00e7in idealdir.<\/p>\n<p>Hangi y\u00f6ntemi se\u00e7erseniz se\u00e7in, veri g\u00fcvenli\u011fi ve b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak i\u00e7in en iyi uygulamalara uymak, yedeklemeleri d\u00fczenli olarak test etmek ve olas\u0131 sorunlara kar\u015f\u0131 haz\u0131rl\u0131kl\u0131 olmak hayati \u00f6nem ta\u015f\u0131r. Bu rehberdeki bilgilerle, MySQL ve MariaDB veritabanlar\u0131n\u0131z\u0131 g\u00fcvenle y\u00f6netebilir ve herhangi bir veri y\u00f6netimi senaryosunda ba\u015far\u0131l\u0131 olabilirsiniz.<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber\nVeritaban\u0131 y\u00f6netimi, modern yaz\u0131l\u0131m geli\u015ftirmenin ve sistem opera","protected":false},"author":1,"featured_media":0,"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],"tags":[],"class_list":{"0":"post-35805","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"cs-entry","8":"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 ve MariaDB&#039;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber - 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-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL ve MariaDB&#039;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber\" \/>\n<meta property=\"og:description\" content=\"MySQL ve MariaDB&#039;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber Veritaban\u0131 y\u00f6netimi, modern yaz\u0131l\u0131m geli\u015ftirmenin ve sistem opera\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-03T22:40:47+00:00\" \/>\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=\"11 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber\",\"datePublished\":\"2025-12-03T22:40:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\"},\"wordCount\":3136,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\",\"name\":\"MySQL ve MariaDB'de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-12-03T22:40:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber\"}]},{\"@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 ve MariaDB'de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber - 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-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/","og_locale":"tr_TR","og_type":"article","og_title":"MySQL ve MariaDB'de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber","og_description":"MySQL ve MariaDB'de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber Veritaban\u0131 y\u00f6netimi, modern yaz\u0131l\u0131m geli\u015ftirmenin ve sistem opera","og_url":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-12-03T22:40:47+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"11 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber","datePublished":"2025-12-03T22:40:47+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/"},"wordCount":3136,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/","url":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/","name":"MySQL ve MariaDB'de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-12-03T22:40:47+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-ve-mariadbde-veritabani-ithalati-ve-ihracati-kapsamli-bir-rehber\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL ve MariaDB&#8217;de Veritaban\u0131 \u0130thalat\u0131 ve \u0130hracat\u0131: Kapsaml\u0131 Bir Rehber"}]},{"@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\/35805","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=35805"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/35805\/revisions"}],"predecessor-version":[{"id":35806,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/35805\/revisions\/35806"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=35805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=35805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=35805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}