{"id":13991,"date":"2021-08-19T09:06:34","date_gmt":"2021-08-19T09:06:34","guid":{"rendered":"https:\/\/freehost.page\/?p=13991"},"modified":"2022-09-14T14:44:03","modified_gmt":"2022-09-14T07:44:03","slug":"khac-phuc-error-mysql-shutdown","status":"publish","type":"post","link":"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/","title":{"rendered":"Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP"},"content":{"rendered":"\n<p>\u0110\u00e2y l\u00e0 th\u00f4ng b\u00e1o l\u1ed7i \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a n\u00f3:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method. Press the Logs button to view error logs and check the Windows Event Viewer for more clues. If you need more help, copy and post this entire log window on the forums.<\/p><\/blockquote>\n\n\n\n<p>M\u1ed9t trong c\u00e1c c\u00e1ch ph\u1ed5 bi\u1ebfn t\u00ecm th\u1ea5y tr\u00ean m\u1ea1ng l\u00e0 x\u00f3a file <code>ibdata1<\/code>, nh\u01b0ng \u0111i\u1ec1u n\u00e0y r\u1ea5t may r\u1ee7i, c\u00f3 th\u1ec3 th\u00e0nh c\u00f4ng m\u00e0 c\u0169ng c\u00f3 th\u1ec3 m\u1ea5t h\u1ebft d\u1eef li\u1ec7u.<\/p>\n\n\n\n<p>C\u00e1ch hay h\u01a1n b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\n\n\n\n<ul><li>V\u00e0o th\u01b0 m\u1ee5c XAMPP (th\u01b0\u1eddng n\u1eb1m \u1edf \u1ed5 c\u00e0i \u0111\u1eb7t C)<\/li><li>Backup th\u01b0 m\u1ee5c <code>mysql<\/code> trong \u0111\u00f3 \u0111\u1ec3 d\u1ef1 ph\u00f2ng<\/li><li>\u0110\u1ed5i t\u00ean th\u01b0 m\u1ee5c <code>mysql\/data<\/code> th\u00e0nh <code>mysql\/data_old<\/code> (b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u00ean b\u1ea5t k\u1ef3)<\/li><li>T\u1ea1o th\u01b0 m\u1ee5c m\u1edbi <code>mysql\/data<\/code><\/li><li>Copy to\u00e0n b\u1ed9 n\u1ed9i dung n\u1eb1m trong th\u01b0 m\u1ee5c <code>mysql\/backup<\/code> sang th\u01b0 m\u1ee5c sang th\u01b0 m\u1ee5c <code>mysql\/data<\/code> v\u1eeba m\u1edbi t\u1ea1o<\/li><li>Copy c\u00e1c th\u01b0 m\u1ee5c database c\u1ee7a b\u1ea1n \u1edf <code>mysql\/data_old<\/code> sang <code>mysql\/data<\/code> (b\u1ecf qua c\u00e1c th\u01b0 m\u1ee5c <code>mysql<\/code>,\u00a0<code>performance_schema<\/code>, v\u00e0\u00a0<code>phpmyadmin<\/code>\u00a0n\u1eb1m trong from\u00a0<code>data_old<\/code>)<\/li><li>Cu\u1ed1i c\u00f9ng copy file <code>ibdata1<\/code> t\u1eeb <code>mysql\/data_old<\/code>\u00a0v\u00e0 sang th\u01b0 m\u1ee5c <code>mysql\/data<\/code> \u0111\u1ec3 thay th\u1ebf file c\u00f3 t\u00ean t\u01b0\u01a1ng t\u1ef1<\/li><li>Kh\u1edfi \u0111\u1ed9ng MySQL t\u1eeb XAMPP. V\u1eady l\u00e0 xong r\u1ed3i!<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u00e2y l\u00e0 th\u00f4ng b\u00e1o l\u1ed7i \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a n\u00f3: Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method. Press the Logs button to view error logs and check the Windows Event Viewer for more clues. If you need more help, &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[238],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP &#8226; Ki\u1ebfn c\u00e0ng<\/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:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"\u0110\u00e2y l\u00e0 th\u00f4ng b\u00e1o l\u1ed7i \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a n\u00f3: Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method. Press the Logs button to view error logs and check the Windows Event Viewer for more clues. If you need more help, &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-19T09:06:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-14T07:44:03+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP &#8226; Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/","og_locale":"vi_VN","og_type":"article","og_title":"Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP &#8226; Ki\u1ebfn c\u00e0ng","og_description":"\u0110\u00e2y l\u00e0 th\u00f4ng b\u00e1o l\u1ed7i \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a n\u00f3: Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method. Press the Logs button to view error logs and check the Windows Event Viewer for more clues. If you need more help, &hellip;","og_url":"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2021-08-19T09:06:34+00:00","article_modified_time":"2022-09-14T07:44:03+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"1 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/","url":"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/","name":"Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2021-08-19T09:06:34+00:00","dateModified":"2022-09-14T07:44:03+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/khac-phuc-error-mysql-shutdown\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"Kh\u1eafc ph\u1ee5c l\u1ed7i Error: MySQL shutdown unexpected l\u00e0m b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng \u0111\u01b0\u1ee3c MySQL tr\u00ean XAMPP"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/13991"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=13991"}],"version-history":[{"count":1,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/13991\/revisions"}],"predecessor-version":[{"id":23365,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/13991\/revisions\/23365"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=13991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=13991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=13991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}