{"id":10280,"date":"2024-08-27T15:27:12","date_gmt":"2024-08-27T12:27:12","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=10280"},"modified":"2024-08-27T15:27:12","modified_gmt":"2024-08-27T12:27:12","slug":"mysql-veritabani-onarimi-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-veritabani-onarimi-nasil-yapilir\/","title":{"rendered":"MySQL Veritaban\u0131 Onar\u0131m\u0131 Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"

\u00c7ok say\u0131da ve b\u00fcy\u00fck boyutlu olan MySQL veritabanlar\u0131nda phpMyAdmin \u00fczerinden database onarma i\u015flemi hem yetersiz kal\u0131r hemde zaman a\u00e7\u0131s\u0131ndan sizi kayba u\u011frat\u0131r. Bu gibi durumlarda sunucunuz \u00fczerinden onar\u0131m yapmak hem daha g\u00fcvenlidir hemde size zaman kazand\u0131r\u0131r. Sizlerde sunucunuz \u00fczerinden database onarma i\u015flemi i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin.<\/p>\n

Linux Sunucuda MySQL Veritaban\u0131 Onar\u0131m\u0131 Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n

Linux sunucunuza root olarak SSH ba\u011flant\u0131s\u0131 yapt\u0131ktan sonra a\u015fa\u011f\u0131daki komutlar\u0131 ihtiyac\u0131n\u0131za g\u00f6re kullanarak onar\u0131m\u0131 tamamlay\u0131n.<\/p>\n

Tek Bir Veritaban\u0131n\u0131 Onarma<\/h3>\n

Linux sunucunuzda bulunan bir veritaban\u0131n\u0131 onarmak i\u00e7in a\u015fa\u011f\u0131daki komutu uygulay\u0131n.<\/p>\n

mysqlcheck -r veritabani_adi<\/code><\/p>\n

T\u00fcm Veritabanlar\u0131n\u0131 Onarma<\/h3>\n

Linux sunucunuzdaki b\u00fct\u00fcn veritabanlar\u0131n\u0131 onarma i\u015flemi i\u00e7in ise a\u015fa\u011f\u0131daki komutu uygulay\u0131n.<\/p>\n

mysqlcheck -r --all-databases<\/code><\/p>\n

Windows Sunucuda MySQL Veritaban\u0131 Onar\u0131m\u0131 Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n

Sunucunuzda arama k\u0131sm\u0131na cmd<\/strong> yazarak Komut \u0130stemini<\/strong> a\u00e7\u0131n.<\/p>\n

Tek Bir Veritaban\u0131n\u0131 Onarma<\/h3>\n

Windows sunucunuzda bulunan bir veritaban\u0131n\u0131 onarmak i\u00e7in a\u015fa\u011f\u0131daki komutu uygulay\u0131n.<\/p>\n

mysqlcheck -r veritabani_adi<\/code><\/p>\n

T\u00fcm Veritabanlar\u0131n\u0131 Onarma<\/h3>\n

Windows sunucunuzdaki b\u00fct\u00fcn veritabanlar\u0131n\u0131 onarma i\u015flemi i\u00e7in ise a\u015fa\u011f\u0131daki komutu uygulay\u0131n.<\/p>\n

mysqlcheck -r --all-databases<\/code><\/p>\n

PHPMyAdmin ile Veritaban\u0131 Onarma \u0130\u015flemi<\/h2>\n

PHPMyAdmin \u00fczerinden database onarma i\u015flemi biraz zaman\u0131n\u0131z\u0131 alabilir \u00e7\u00fcnk\u00fc veritaban\u0131 i\u00e7erisinde tablolar\u0131 tek tek onarman\u0131z gerekir benim yeterli zaman\u0131m var diyorsan\u0131z a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz. \ud83d\ude42<\/p>\n

PHPMyAdmin e giri\u015f yap\u0131n ard\u0131ndan i\u015flem yapmak istedi\u011finiz veritaban\u0131nda bulunan tabloyu se\u00e7in. A\u00e7\u0131lan sayfada \u0130\u015flemler<\/strong> sekmesinde bulunan Tabloyu onar<\/strong> se\u00e7ene\u011fiyle MySQL repair i\u015flemini tamamlay\u0131n.<\/p>\n

\"MySQL<\/p>\n

NOT: <\/strong>Veritaban\u0131 onarma i\u015flemi yapmadan \u00f6nce her ihtimale kar\u015f\u0131 veritaban\u0131n\u0131z\u0131n yede\u011fini alman\u0131z\u0131 \u00f6neririz.<\/p>\n

Ayl\u0131k sadece 5$’a VDS Sunucu<\/a> kampanyam\u0131zdan yararlan\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00c7ok say\u0131da ve b\u00fcy\u00fck boyutlu olan MySQL veritabanlar\u0131nda phpMyAdmin \u00fczerinden database onarma i\u015flemi hem yetersiz kal\u0131r hemde zaman a\u00e7\u0131s\u0131ndan sizi kayba u\u011frat\u0131r. Bu gibi durumlarda sunucunuz \u00fczerinden onar\u0131m yapmak hem daha g\u00fcvenlidir hemde size zaman...<\/p>\n","protected":false},"author":2,"featured_media":10295,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,54,48],"tags":[],"class_list":["post-10280","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-mysqlserver","category-win-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=10280"}],"version-history":[{"count":14,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10280\/revisions"}],"predecessor-version":[{"id":10297,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10280\/revisions\/10297"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/10295"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=10280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=10280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=10280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}