{"id":4040,"date":"2020-02-12T14:18:00","date_gmt":"2020-02-12T07:18:00","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=4040"},"modified":"2020-02-12T14:25:02","modified_gmt":"2020-02-12T07:25:02","slug":"backup-va-restore-database-tren-mariadb","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/backup-va-restore-database-tren-mariadb\/","title":{"rendered":"Backup v\u00e0 Restore database tr\u00ean MariaDB"},"content":{"rendered":"<p>Trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi \u0111\u1ebfn c\u00e1c b\u1ea1n Backuptool c\u1ee7a MariaDB l\u00e0 msqldump: mysqldump th\u1ef1c hi\u1ec7n sao l\u01b0u logic. \u0110\u00f3 l\u00e0 c\u00e1ch linh ho\u1ea1t nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n sao l\u01b0u v\u00e0 kh\u00f4i ph\u1ee5c, v\u00e0 l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1ed1t khi k\u00edch th\u01b0\u1edbc d\u1eef li\u1ec7u t\u01b0\u01a1ng \u0111\u1ed1i nh\u1ecf.<\/p>\n<p><span style=\"font-size: 18pt;\">Backup<\/span><\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n backup 1 database\u00a0 mong mu\u1ed1n, b\u1ea1n th\u1ef1c hi\u1ec7n l\u1ec7nh sau<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mysqldump -u database_user -p database_name &gt; database.sql<\/pre>\n<p>Th\u1ef1c hi\u1ec7n backup to\u00e0n b\u1ed9 database \u0111ang c\u00f3 tr\u00ean MariaDB<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mysqldump -u root -p -\u2013all-databases &gt; alldb.sql<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 18pt;\">Restore<\/span><\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n restore b\u1ea1n ch\u1ea1y l\u1ec7nh sau<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mysql -u database_user -p &lt; backup_file.sql<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi \u0111\u1ebfn c\u00e1c b\u1ea1n Backuptool c\u1ee7a MariaDB l\u00e0 msqldump: mysqldump th\u1ef1c hi\u1ec7n sao l\u01b0u logic. \u0110\u00f3 l\u00e0 c\u00e1ch linh ho\u1ea1t nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n sao l\u01b0u v\u00e0 kh\u00f4i ph\u1ee5c, v\u00e0 l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1ed1t khi k\u00edch th\u01b0\u1edbc d\u1eef li\u1ec7u t\u01b0\u01a1ng \u0111\u1ed1i nh\u1ecf. Backup \u0110\u1ec3 th\u1ef1c hi\u1ec7n backup 1 database\u00a0 [&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-4040","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\/4040","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=4040"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4040\/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=4040"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4040"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}