{"id":132797,"date":"2024-10-04T14:24:34","date_gmt":"2024-10-04T11:24:34","guid":{"rendered":"https:\/\/www.zoner.fi\/tuki\/?page_id=132797"},"modified":"2025-11-12T15:47:00","modified_gmt":"2025-11-12T13:47:00","slug":"mysql-tietokannan-taulun-korjaaminen","status":"publish","type":"page","link":"https:\/\/www.zoner.fi\/tuki\/webhotellit\/cpanel-webhotelli-fi\/mysql-tietokannan-taulun-korjaaminen\/","title":{"rendered":"MySQL-tietokannan taulun korjaaminen"},"content":{"rendered":"\n<p>MySQL-tietokannan taulujen korjauksen voi tehd\u00e4 cPanel-hallintapaneelin kautta sielt\u00e4 l\u00f6ytyv\u00e4\u00e4 phpMyAdmin-ty\u00f6kalua k\u00e4ytt\u00e4en.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kirjaudu cPaneliin Zoner Homen kautta. <strong>Ohje<\/strong>: <a href=\"https:\/\/www.zoner.fi\/tuki\/webhotellit\/cpanel-webhotelli-fi\/cpanel-palvelunhallintaan-siirtyminen\/\">cPanel-palvelunhallintaan siirtyminen<\/a>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"143\" src=\"https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-1-1024x143.png\" alt=\"\" class=\"wp-image-133833\" srcset=\"https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-1-1024x143.png 1024w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-1-300x42.png 300w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-1-768x107.png 768w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-1.png 1358w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Valitse phpMyAdminin vasemmalta reunalta korjattava tietokanta painamalla sen nime\u00e4<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"882\" height=\"420\" src=\"https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-2.png\" alt=\"\" class=\"wp-image-133834\" srcset=\"https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-2.png 882w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-2-300x143.png 300w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-2-768x366.png 768w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ruudun oikealle puolelle aukeaa lista tietokannan tauluista, rullaa sivun alareunaan<\/li>\n\n\n\n<li>Sivun alareunassa valitse kaikki listan taulut &#8221;Check All&#8221;-valinnalla. Voit my\u00f6s halutessasi valita vain yhden tai useamman taulun listasta.<\/li>\n\n\n\n<li>T\u00e4m\u00e4n j\u00e4lkeen valitse ruksin oikealta puolelta &#8221;With selected:&#8221; -pudotusvalikon listasta &#8221;Repair table&#8221;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"460\" src=\"https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-3-1024x460.png\" alt=\"\" class=\"wp-image-133835\" srcset=\"https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-3-1024x460.png 1024w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-3-300x135.png 300w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-3-768x345.png 768w, https:\/\/www.zoner.fi\/tuki\/wp-content\/uploads\/2024\/10\/MySQL-tietokannan-taulun-korjaaminen-3.png 1046w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kun toimenpide on valmis tulee sivun yl\u00e4reunaan teksti &#8221;Your SQL query has been executed successfully&#8221;. Toimenpiteen kesto riippuu tietokannan koosta.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>MySQL-tietokannan taulujen korjauksen voi tehd\u00e4 cPanel-hallintapaneelin kautta sielt\u00e4 l\u00f6ytyv\u00e4\u00e4 phpMyAdmin-ty\u00f6kalua k\u00e4ytt\u00e4en.<\/p>\n","protected":false},"author":40,"featured_media":0,"parent":137349,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"132278,130865,130657,130779,130899,132080","_relevanssi_noindex_reason":"","footnotes":""},"categories":[218],"tags":[99],"wf_page_folders":[],"class_list":{"0":"post-132797","1":"page","2":"type-page","3":"status-publish","5":"category-cpanel-webhotelli-fi-webhotellit","6":"tag-tietokannat"},"_links":{"self":[{"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/pages\/132797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/comments?post=132797"}],"version-history":[{"count":4,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/pages\/132797\/revisions"}],"predecessor-version":[{"id":138078,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/pages\/132797\/revisions\/138078"}],"up":[{"embeddable":true,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/pages\/137349"}],"wp:attachment":[{"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/media?parent=132797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/categories?post=132797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/tags?post=132797"},{"taxonomy":"wf_page_folders","embeddable":true,"href":"https:\/\/www.zoner.fi\/tuki\/wp-json\/wp\/v2\/wf_page_folders?post=132797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}