{"id":4064,"date":"2020-02-13T10:31:12","date_gmt":"2020-02-13T03:31:12","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=4064"},"modified":"2020-02-13T10:31:12","modified_gmt":"2020-02-13T03:31:12","slug":"di-chuyen-mysql-sang-mariadb","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/di-chuyen-mysql-sang-mariadb\/","title":{"rendered":"Di chuy\u1ec3n MySql sang MariaDB"},"content":{"rendered":"<div class=\"ddict_div\">\n<p class=\"ddict_sentence\">B\u1ea1n \u0111\u00e3 quy\u1ebft \u0111\u1ecbnh chuy\u1ec3n t\u1eeb MySQL sang MariaDB, nh\u01b0ng b\u1ea1n h\u01a1i lo l\u1eafng. \u0110i\u1ec1u b\u0103n kho\u0103n nh\u1ea5t l\u00e0 vi\u1ec7c upgrade l\u00ean MariaDB c\u00f3 l\u00e0m h\u1ecfng database hay kh\u00f4ng? \u0110\u1eebng lo l\u1eafng, v\u00ec MariaDB \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 thay th\u1ebf cho MySQL. B\u1ea1n s\u1ebd c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t MariaDB tr\u00ean m\u00e1y ch\u1ee7 MySQL c\u1ee7a b\u1ea1n v\u00e0 sau \u0111\u00f3 MariaDB s\u1ebd ho\u1ea1t \u0111\u1ed9ng m\u00e0 kh\u00f4ng g\u1eb7p ph\u1ea3i s\u1ee3 c\u1ed1 n\u00e0o.<\/p>\n<p>Tuy nhi\u00ean an to\u00e0n v\u1eabn l\u00e0 tr\u00ean h\u1ebft, ch\u00fang ta n\u00ean backup l\u1ea1i to\u00e0n b\u1ed9 database\u00a0 \u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p x\u1ea5u c\u00f3 th\u1ec3 x\u1ea3y ra. \u0110\u1ec3 backup to\u00e0n b\u1ed9 database MySql b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng l\u1ec7nh sau:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mysqldump -u root -p -\u2013all-databases &gt; alldb.sql<\/pre>\n<p>Sau khi \u0111\u00e3 t\u1ea1o file backup to\u00e0n b\u1ed9 database tr\u00ean\u00a0 MySql b\u1ea1n\u00a0 th\u1ef1c hi\u1ec7n ti\u1ebfp c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 th\u1ef1c hi\u1ec7n upgrade sang MariaDB<\/p>\n<ol>\n<li>\u00a0C\u00e0i \u0111\u1eb7t repo<br \/>\nCh\u1ea1y l\u1ec7nh sau \u0111\u1ec3 thi\u1ebft l\u1eadp repo cho MariaDB, ch\u00fa \u00fd thay \u0111\u1ed5i phi\u00ean b\u1ea3n MariaDB mong mu\u1ed1n<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">curl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup |\r\n    sudo bash -s -- --mariadb-server-version=\"mariadb-10.3\"<\/pre>\n<p>&nbsp;<\/li>\n<li>Update package\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\"># \u0110\u1ed1i v\u1edbi CentOS, redhat, fedora\r\nyum update -y\r\n\r\n# \u0110\u1ed1i v\u1edbi d\u00f9ng debian, ubuntu\r\nsudo apt-get update<\/pre>\n<p>&nbsp;<\/li>\n<li>Stop MySql\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">service mysql stop\r\nho\u1eb7c\r\nsystemctl stop mysql<\/pre>\n<p>&nbsp;<\/li>\n<li>C\u00e0i \u0111\u1eb7t MariaDB\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\"># \u0110\u1ed1i v\u1edbi CentOS, redhat, fedora \r\nyum install MariaDB-server MariaDB-client -y\r\n\r\n# \u0110\u1ed1i v\u1edbi d\u00f2ng debian, ubuntu\r\nsudo apt install mariadb-server -y<\/pre>\n<\/li>\n<li>Ki\u1ec3m tra ho\u1ea1t \u0111\u1ed9ng sau khi c\u00e0i \u0111\u1eb7t k\u1ebft th\u00fac\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mysql_upgrade<\/pre>\n<p>Sau khi th\u1ef1c hi\u1ec7n ki\u1ec3m tra c\u00e0i \u0111\u1eb7t b\u1eb1ng l\u1ec7nh tr\u00ean, n\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i g\u00ec x\u1ea3y ra b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh kh\u1edfi \u0111\u1ed9ng MariaDB \u0111\u1ec3 s\u1eed d\u1ee5ng.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">systemctl start mariadb\r\n\r\nho\u1eb7c \r\n\r\nservice mariadb start\r\n<\/pre>\n<p>&nbsp;<\/li>\n<\/ol>\n<p>Ch\u00fac b\u1ea1n may m\u1eafn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111\u00e3 quy\u1ebft \u0111\u1ecbnh chuy\u1ec3n t\u1eeb MySQL sang MariaDB, nh\u01b0ng b\u1ea1n h\u01a1i lo l\u1eafng. \u0110i\u1ec1u b\u0103n kho\u0103n nh\u1ea5t l\u00e0 vi\u1ec7c upgrade l\u00ean MariaDB c\u00f3 l\u00e0m h\u1ecfng database hay kh\u00f4ng? \u0110\u1eebng lo l\u1eafng, v\u00ec MariaDB \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 thay th\u1ebf cho MySQL. B\u1ea1n s\u1ebd c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t MariaDB tr\u00ean m\u00e1y ch\u1ee7 MySQL c\u1ee7a b\u1ea1n [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":16424,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[5156],"class_list":["post-4064","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-mariadb"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4064","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=4064"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4064\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/16424"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=4064"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4064"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}