{"id":16498,"date":"2020-08-12T22:28:59","date_gmt":"2020-08-12T15:28:59","guid":{"rendered":"https:\/\/speed.family\/?p=16498"},"modified":"2020-08-12T22:28:59","modified_gmt":"2020-08-12T15:28:59","slug":"xuat-database-bang-ssh","status":"publish","type":"post","link":"https:\/\/kiencang.net\/xuat-database-bang-ssh\/","title":{"rendered":"Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH"},"content":{"rendered":"\n<p>Trong b\u00e0i tr\u01b0\u1edbc t\u00f4i \u0111\u00e3 n\u00f3i v\u1ec1 <a href=\"https:\/\/kiencang.net\/nen-toan-bo-website\/\" target=\"_blank\" rel=\"noreferrer noopener\">c\u00e1ch t\u1ea1o file n\u00e9n zip cho to\u00e0n b\u1ed9 website<\/a> (b\u1eb1ng c\u1ea3 SSH &amp; control panel), nh\u01b0ng nh\u01b0 v\u1eady v\u1eabn ch\u01b0a ho\u00e0n ch\u1ec9nh, v\u00ec d\u00f9 n\u00f3 n\u00e9n to\u00e0n b\u1ed9 file tr\u00ean website nh\u01b0ng v\u1eabn ch\u01b0a c\u00f3 database b\u00ean trong, \u0111\u1ec3 ho\u00e0n ch\u1ec9nh cho m\u1ee5c \u0111\u00edch backup ho\u1eb7c <a href=\"https:\/\/kiencang.net\/combo-chuyen-host-nhanh\/\" target=\"_blank\" rel=\"noreferrer noopener\">chuy\u1ec3n host<\/a> b\u1ea1n ph\u1ea3i l\u00e0m th\u00eam nhi\u1ec7m v\u1ee5 xu\u1ea5t database n\u1eefa.<\/p>\n\n\n<p>\u0110\u1ec3 t\u1ea1o file backup cho c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL, b\u1ea1n <a href=\"https:\/\/kiencang.net\/cau-lenh-ssh-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SSH<\/a> \u0111\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o th\u01b0 m\u1ee5c g\u1ed1c c\u1ee7a website r\u1ed3i g\u00f5 l\u1ec7nh sau:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>mysqldump --add-drop-table -h localhost -u <strong>user_cua_database<\/strong> -p <strong>ten_database<\/strong> &gt; site.bak.sql<\/code><\/pre>\n\n\n<ul><li><em>localhost<\/em> b\u1ea1n <strong>gi\u1eef nguy\u00ean<\/strong>;<\/li><li><em>user_cua_database<\/em> l\u00e0 <strong>user c\u1ee7a database website<\/strong> c\u1ee7a b\u1ea1n;<\/li><li><em>ten_database<\/em> l\u00e0 <strong>t\u00ean c\u1ee7a database website<\/strong> c\u1ee7a b\u1ea1n;<\/li><\/ul>\n\n\n<p>G\u00f5 xong, nh\u1ea5n Enter n\u00f3 s\u1ebd h\u1ecfi pass c\u1ee7a database, b\u1ea1n g\u00f5 v\u00e0o, \u0111\u0103ng nh\u1eadp th\u00e0nh c\u00f4ng, n\u00f3 s\u1ebd t\u1ea1o file sql cho b\u1ea1n. L\u01b0u \u00fd l\u00e0 pass n\u00e0y \u0111\u1ed9c l\u1eadp v\u1edbi pass \u0111\u0103ng nh\u1eadp web c\u0169ng nh\u01b0 pass c\u1ee7a VPS. T\u00f4i s\u1ebd ch\u1ec9 lu\u00f4n c\u00e1ch t\u00ecm th\u00f4ng tin n\u00e0y.<\/p>\n\n\n<p>\u0110\u1ec3 bi\u1ebft 3 th\u00f4ng tin quan tr\u1ecdng l\u00e0 user, t\u00ean database, v\u00e0 pass, b\u1ea1n truy c\u1eadp file <em>wp_config.php<\/em> (v\u00ed d\u1ee5 th\u00f4ng qua FTP ho\u1eb7c File Manager c\u1ee7a control panel) t\u1ea1i th\u01b0 m\u1ee5c ch\u1ee9a file n\u00e0y (trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a t\u00f4i l\u00e0 <em>public_html<\/em>) v\u00e0 t\u00ecm \u0111\u1ebfn c\u00e1c d\u00f2ng sau:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>define( 'DB_NAME', 'dbn123456789lH' );\n\/** MySQL database username *\/\ndefine( 'DB_USER', 'usr123456789lH' );\n\/** MySQL database password *\/\ndefine( 'DB_PASSWORD', 'pa123456789F' );<\/code><\/pre>\n\n\n<p>Trong v\u00ed d\u1ee5 tr\u00ean:<\/p>\n\n\n<ul><li><strong>DB_NAME<\/strong>: ch\u00ednh l\u00e0 t\u00ean b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0: <code>dbn123456789lH<\/code><\/li><li><strong>DB_USER<\/strong>: ch\u00ednh l\u00e0 user c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0: <code>usr123456789lH<\/code><\/li><li><strong>DB_PASSWORD<\/strong>: ch\u00ednh l\u00e0 pass c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0: <code>pa123456789F<\/code><\/li><\/ul>\n\n\n<p>Do v\u1eady c\u00e2u l\u1ec7nh t\u01b0\u01a1ng \u1ee9ng trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a t\u00f4i s\u1ebd nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>mysqldump --add-drop-table -h localhost -u usr123456789lH -p dbn123456789lH &gt; chimcat.bak.sql<\/code><\/pre>\n\n\n<p>Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n l\u1ec7nh, r\u1ed3i nh\u1eadp pass: <code>pa123456789F<\/code><\/p>\n\n\n<p>N\u1ebfu theo t\u00e1c \u0111\u00fang, b\u1ea1n s\u1ebd th\u1ea5y file <code>chimcat.bak.sql<\/code> \u1edf th\u01b0 m\u1ee5c g\u1ed1c c\u1ee7a website. Ch\u1ec9 \u0111u\u00f4i <strong>.sql<\/strong> l\u00e0 quan tr\u1ecdng, c\u00f2n <code>chimcat.bak<\/code> b\u1ea1n c\u00f3 th\u1ec3 thay b\u1eb1ng b\u1ea5t c\u1ee9 t\u00ean n\u00e0o b\u1ea1n mu\u1ed1n. Sau \u0111\u00f3 b\u1ea1n c\u0169ng d\u00f9ng SSH \u0111\u1ec3 <a href=\"https:\/\/kiencang.net\/chuyen-file-hai-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">chuy\u1ec3n file database t\u1eeb host c\u0169 sang host m\u1edbi (c\u00e2u l\u1ec7nh scp)<\/a>.<\/p>\n\n\n<p>B\u00e0i sau ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch <a href=\"https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/\" target=\"_blank\" rel=\"noreferrer noopener\">nh\u1eadp file database n\u00e0y tr\u00ean hosting m\u1edbi<\/a>.<\/p>\n\n\n<p>Xu\u1ea5t database l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng khi b\u1ea1n mu\u1ed1n <a href=\"https:\/\/kiencang.net\/chuyen-host-wordpress-bang-ssh\/\" target=\"_blank\" rel=\"noreferrer noopener\">chuy\u1ec3n host b\u1eb1ng SSH<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong b\u00e0i tr\u01b0\u1edbc t\u00f4i \u0111\u00e3 n\u00f3i v\u1ec1 c\u00e1ch t\u1ea1o file n\u00e9n zip cho to\u00e0n b\u1ed9 website (b\u1eb1ng c\u1ea3 SSH &amp; control panel), nh\u01b0ng nh\u01b0 v\u1eady v\u1eabn ch\u01b0a ho\u00e0n ch\u1ec9nh, v\u00ec d\u00f9 n\u00f3 n\u00e9n to\u00e0n b\u1ed9 file tr\u00ean website nh\u01b0ng v\u1eabn ch\u01b0a c\u00f3 database b\u00ean trong, \u0111\u1ec3 ho\u00e0n ch\u1ec9nh cho m\u1ee5c \u0111\u00edch backup ho\u1eb7c chuy\u1ec3n host &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[263,288],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH &#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\/xuat-database-bang-ssh\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i tr\u01b0\u1edbc t\u00f4i \u0111\u00e3 n\u00f3i v\u1ec1 c\u00e1ch t\u1ea1o file n\u00e9n zip cho to\u00e0n b\u1ed9 website (b\u1eb1ng c\u1ea3 SSH &amp; control panel), nh\u01b0ng nh\u01b0 v\u1eady v\u1eabn ch\u01b0a ho\u00e0n ch\u1ec9nh, v\u00ec d\u00f9 n\u00f3 n\u00e9n to\u00e0n b\u1ed9 file tr\u00ean website nh\u01b0ng v\u1eabn ch\u01b0a c\u00f3 database b\u00ean trong, \u0111\u1ec3 ho\u00e0n ch\u1ec9nh cho m\u1ee5c \u0111\u00edch backup ho\u1eb7c chuy\u1ec3n host &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/xuat-database-bang-ssh\/\" \/>\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=\"2020-08-12T15:28:59+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=\"2 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH &#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\/xuat-database-bang-ssh\/","og_locale":"vi_VN","og_type":"article","og_title":"Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH &#8226; Ki\u1ebfn c\u00e0ng","og_description":"Trong b\u00e0i tr\u01b0\u1edbc t\u00f4i \u0111\u00e3 n\u00f3i v\u1ec1 c\u00e1ch t\u1ea1o file n\u00e9n zip cho to\u00e0n b\u1ed9 website (b\u1eb1ng c\u1ea3 SSH &amp; control panel), nh\u01b0ng nh\u01b0 v\u1eady v\u1eabn ch\u01b0a ho\u00e0n ch\u1ec9nh, v\u00ec d\u00f9 n\u00f3 n\u00e9n to\u00e0n b\u1ed9 file tr\u00ean website nh\u01b0ng v\u1eabn ch\u01b0a c\u00f3 database b\u00ean trong, \u0111\u1ec3 ho\u00e0n ch\u1ec9nh cho m\u1ee5c \u0111\u00edch backup ho\u1eb7c chuy\u1ec3n host &hellip;","og_url":"https:\/\/kiencang.net\/xuat-database-bang-ssh\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2020-08-12T15:28:59+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":"2 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/xuat-database-bang-ssh\/","url":"https:\/\/kiencang.net\/xuat-database-bang-ssh\/","name":"Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2020-08-12T15:28:59+00:00","dateModified":"2020-08-12T15:28:59+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/xuat-database-bang-ssh\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/xuat-database-bang-ssh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/xuat-database-bang-ssh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"Xu\u1ea5t database\/c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1eb1ng SSH"}]},{"@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\/16498"}],"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=16498"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/16498\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=16498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=16498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=16498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}