{"id":922,"date":"2015-03-27T11:56:51","date_gmt":"2015-03-27T09:56:51","guid":{"rendered":"http:\/\/sahinsolmaz.com\/blog\/?p=922"},"modified":"2015-03-27T11:56:51","modified_gmt":"2015-03-27T09:56:51","slug":"ssh-ile-mysql-yedeklemegeri-yukleme-exportimport","status":"publish","type":"post","link":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-mysql-yedeklemegeri-yukleme-exportimport\/","title":{"rendered":"SSH ile MySQL Yedekleme\/Geri Y\u00fckleme Export\/\u0130mport"},"content":{"rendered":"

Bu sefer daha sade ve k\u0131sa bir payla\u015f\u0131m olacak ba\u015fl\u0131kta g\u00f6rd\u00fc\u011f\u00fcn\u00fcz \u00fczere: SSH ile MySQL Yede\u011fi Nas\u0131l al\u0131n\u0131r?<\/strong> Nas\u0131l geri y\u00fcklenir<\/strong>? K\u0131saca import<\/strong> ve export<\/strong> komutunu taslak olarak kendime not alm\u0131\u015fken, sizler i\u00e7in de payla\u015fay\u0131m isteyim:<\/p>\n

SSH – MySQL Veritaban\u0131 Yede\u011fi Nas\u0131l Al\u0131n\u0131r? \/\/D\u0131\u015fa Aktar<\/h3>\n

How to get MySQL Dadatabase Backup\u00a0 SSH? \/\/Export<\/span><\/h4>\n
    \n
  • \n
    cd \/var\/lib\/mysql\r\n<\/strong><\/span>MySQL klas\u00f6r\u00fcn\u00fc a\u00e7\u0131n \r\n\/\/Open the MySQL folder<\/pre>\n<\/li>\n
  • \n
    mysqldump --opt -Q -u dbUserkullanici -p dbVt > vt_db.<\/span><\/strong>sql<\/span><\/strong>\r\nve veritaban\u0131 \u015fifrenizi girin<\/abbr>\r\n\/\/Enter your db password<\/pre>\n<\/li>\n<\/ul>\n
    SSH – MySQL Veritaban\u0131 Yede\u011fi Nas\u0131l Y\u00fcklenir?\u00a0 \/\/\u0130\u00e7e Aktar<\/h3>\n
    SSH – How to install MySQL Database BackUP? \/\/Import<\/span><\/h4>\n
     <\/p>\n
      \n
    • \n
      cd \/var\/lib\/mysql\r\n<\/strong><\/span>MySQL klas\u00f6r\u00fcn\u00fc a\u00e7\u0131n \r\n\/\/Open the MySQL folder<\/pre>\n<\/li>\n
    • \n
      mysql -u dbUserkullanici -p dbadi < vt_db.<\/strong><\/span>sql<\/strong><\/span>\r\nve veritaban\u0131 \u015fifrenizi girin<\/abbr>\r\n\/\/Enter your db password<\/pre>\n<\/li>\n<\/ul>\n
       <\/p>\n","protected":false},"excerpt":{"rendered":"
      Bu sefer daha sade ve k\u0131sa bir payla\u015f\u0131m olacak ba\u015fl\u0131kta g\u00f6rd\u00fc\u011f\u00fcn\u00fcz \u00fczere: SSH ile MySQL Yede\u011fi Nas\u0131l al\u0131n\u0131r? Nas\u0131l geri y\u00fcklenir? K\u0131saca import ve export komutunu taslak olarak kendime not alm\u0131\u015fken, sizler i\u00e7in de payla\u015fay\u0131m isteyim: SSH – MySQL Veritaban\u0131 Yede\u011fi Nas\u0131l Al\u0131n\u0131r? \/\/D\u0131\u015fa Aktar How to get MySQL Dadatabase Backup\u00a0 SSH? \/\/Export cd \/var\/lib\/mysql […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[137],"tags":[504,502,501,503],"class_list":["post-922","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-how-to-install-mysql-backup","tag-how-to-mysql-backup","tag-ssh-mysql-yedegi-nasil-alinir","tag-ssh-mysql-yedegi-nasil-yuklenir"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4sbm9-eS","jetpack-related-posts":[{"id":435,"url":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-mysql-dosyasini-iceri-aktarmak-importing-mysql-databases-via-ssh\/","url_meta":{"origin":922,"position":0},"title":"SSH ile MySQL Dosyas\u0131n\u0131 \u0130\u00e7eri Aktarmak-Importing MySQL Databases via SSH","author":"SahinSOLMAZ","date":"20 Mart 2014","format":false,"excerpt":"Sunucunuzda y\u00f6netim paneli (cPanel, Plesk panel vb.) kullanm\u0131yor olabilirsiniz dolay\u0131s\u0131 ile phpMyAdmin\u00a0eri\u015fimiz de olmayacakt\u0131r\u00a0ya da y\u00fcklemek istedi\u011finiz .sql\u00a0veritaban\u0131\u00a0dosyan\u0131z\u0131n boyutu b\u00fcy\u00fck oldu\u011fu i\u00e7in time-out, bir tak\u0131m problemler ya\u015fayabilirsiniz bu ve benzeri durumlarda ssh\u00a0\u00fczerinden veritaban\u0131 dosyan\u0131z\u0131 kolayl\u0131kla import edebilirsiniz. Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel)\u2026","rel":"","context":""SSH" i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":860,"url":"https:\/\/sahinsolmaz.com\/blog\/mysql-tuning-veritabani-optimizasyonu-ile-sunucu-performansinizi-yukseltin\/","url_meta":{"origin":922,"position":1},"title":"MySQL Tuning Veritaban\u0131 Optimizasyonu ile Sunucu Performans\u0131n\u0131z\u0131 Y\u00fckseltin!","author":"SahinSOLMAZ","date":"17 Aral\u0131k 2014","format":false,"excerpt":"MySQL Tuning database\/veritaban\u0131 optimizasyonu ile sunucu performans\u0131n\u0131z\u0131 y\u00fckseltebilirsiniz. Bunun i\u00e7in yapman\u0131z gereken en pratik yol\u00a0Mysql Tuning yaz\u0131l\u0131m\u0131n\u0131n kurulumu ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 neticesinde size belirtti\u011fi ayarlar\u0131 my.cnf\u00a0\u00fczerinden\u00a0g\u00fcncellemektir. MySQL Tuning Script'i ile\u00a0veritaban\u0131 performans\u0131n\u0131z\u0131 detayl\u0131 olarak inceleyebilir, rahatl\u0131kla sunucu performans\u0131n\u0131z\u0131 artt\u0131rabilirsiniz. Script Ad\u0131:\u00a0tuning-primer.sh Kaynak:\u00a0 http:\/\/day32.com\/MySQL\/ Direkt\u00a0link: http:\/\/day32.com\/MySQL\/tuning-primer.sh MySQL Tuning -\u00a0tuning-primer.sh\u00a0Nas\u0131l Kurulur? \/\/How to Install\u2026","rel":"","context":""CentOS" i\u00e7inde","block_context":{"text":"CentOS","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/centos\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/12\/MySQL-Tuning-Veritaban%C4%B1-Optimizasyonu-ile-Sunucu-Performans%C4%B1n%C4%B1z%C4%B1-Y%C3%BCkseltin-MySQL-Tuning-tuning-primer_MySQL-Tuning-tuning-primer.sh-Nas%C4%B1l-Kurulur_How-to-Install-MySQL-Tuning.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/12\/MySQL-Tuning-Veritaban%C4%B1-Optimizasyonu-ile-Sunucu-Performans%C4%B1n%C4%B1z%C4%B1-Y%C3%BCkseltin-MySQL-Tuning-tuning-primer_MySQL-Tuning-tuning-primer.sh-Nas%C4%B1l-Kurulur_How-to-Install-MySQL-Tuning.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/12\/MySQL-Tuning-Veritaban%C4%B1-Optimizasyonu-ile-Sunucu-Performans%C4%B1n%C4%B1z%C4%B1-Y%C3%BCkseltin-MySQL-Tuning-tuning-primer_MySQL-Tuning-tuning-primer.sh-Nas%C4%B1l-Kurulur_How-to-Install-MySQL-Tuning.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/12\/MySQL-Tuning-Veritaban%C4%B1-Optimizasyonu-ile-Sunucu-Performans%C4%B1n%C4%B1z%C4%B1-Y%C3%BCkseltin-MySQL-Tuning-tuning-primer_MySQL-Tuning-tuning-primer.sh-Nas%C4%B1l-Kurulur_How-to-Install-MySQL-Tuning.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":432,"url":"https:\/\/sahinsolmaz.com\/blog\/change-mysql-root-password-mysql-root-sifresini-guncellemek\/","url_meta":{"origin":922,"position":2},"title":"Change MySQL Root Password – MySQL Root \u015eifresini G\u00fcncellemek","author":"SahinSOLMAZ","date":"20 Mart 2014","format":false,"excerpt":"Merhabalar, MySQL root \u015fifresini g\u00fcncellemeniz gerekirse, a\u015fa\u011f\u0131daki ssh\u00a0komutlar\u0131n\u0131 kullanman\u0131z yeterli olacakt\u0131r. Login ssh, type mysqladmin. A tip if you can not remember mysql password type \u00a0 mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` mysql> USE mysql; mysql> SELECT * FROM user; mysql> SET PASSWORD FOR 'username'@'hostname' = PASSWORD('password_here'); mysql> FLUSH PRIVILEGES; How to\u2026","rel":"","context":""SSH" i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":381,"url":"https:\/\/sahinsolmaz.com\/blog\/change-mysql-resetupdate-password-root-ssh-kullanici-ve-sifre-islemleri\/","url_meta":{"origin":922,"position":3},"title":"Change MySQL Reset\/Update Password  – Root  SSH –  Kullan\u0131c\u0131 ve \u015eifre \u0130\u015flemleri","author":"SahinSOLMAZ","date":"25 May\u0131s 2014","format":false,"excerpt":"1. Change root password: su - root passwd 2. Mysql root password: --> ERROR 1045 (28000): Access denied for user 'root'@'localhost' service mysqld stop mysqld_safe --skip-grant-tables & mysql -u root mysql> mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD ('yournewpassword') WHERE User='root'; mysql> FLUSH PRIVILEGES; mysql> quit; service\u2026","rel":"","context":""CentOS" i\u00e7inde","block_context":{"text":"CentOS","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/centos\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":403,"url":"https:\/\/sahinsolmaz.com\/blog\/cozuldusolved-mysql-innodb-error-cannot-allocate-3154744384-bytes\/","url_meta":{"origin":922,"position":4},"title":"\u00c7\u00f6z\u00fcld\u00fc\/Solved -MySQL InnoDB: Error Cannot Allocate 3154744384 bytes","author":"SahinSOLMAZ","date":"31 Mart 2014","format":false,"excerpt":"InnoDB: Error: cannot allocate 3145744384 bytes of\u00a0InnoDB: memory with malloc! Total allocated memory \u00c7\u00d6Z\u00dcLD\u00dc \/ SOLVED innodb_buffer_pool_size=2G","rel":"","context":""Genel" i\u00e7inde","block_context":{"text":"Genel","link":"https:\/\/sahinsolmaz.com\/blog\/category\/genel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":987,"url":"https:\/\/sahinsolmaz.com\/blog\/solved-error-1153-08s01-at-line-4147-got-a-packet-bigger-than-max_allowed_packet-bytes\/","url_meta":{"origin":922,"position":5},"title":"SOLVED – ERROR 1153 (08S01) at line 4147: Got a packet bigger than ‘max_allowed_packet’ bytes","author":"SahinSOLMAZ","date":"15 May\u0131s 2015","format":false,"excerpt":"Bir gece yaras\u0131 mysql veritaban\u0131n\u0131 import etmek istedi\u011finizde: ERROR 1153 (08S01) at line 4147: Got a packet bigger than 'max_allowed_packet' bytes hatas\u0131 ile kar\u015f\u0131la\u015f\u0131rsan\u0131z 1.se\u00e7enekteki d\u00f6rt ad\u0131m\u0131 uygulayarak bu s\u0131k\u0131nt\u0131dan kal\u0131c\u0131 olarak kurtulabilirsiniz veyahut 'max_allowed_packet' bytes hatas\u0131n\u0131 anl\u0131k olarak ge\u00e7mek isterseniz 2. se\u00e7enekteki ssh komutunu uygulayabilirsiniz. Ben MySQL dosyas\u0131n\u0131, SSH\u2026","rel":"","context":""MySQL" i\u00e7inde","block_context":{"text":"MySQL","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/comments?post=922"}],"version-history":[{"count":1,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/922\/revisions"}],"predecessor-version":[{"id":958,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/922\/revisions\/958"}],"wp:attachment":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media?parent=922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/categories?post=922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/tags?post=922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}