{"id":16559,"date":"2020-08-18T11:02:06","date_gmt":"2020-08-18T04:02:06","guid":{"rendered":"https:\/\/speed.family\/?p=16559"},"modified":"2020-08-18T11:02:06","modified_gmt":"2020-08-18T04:02:06","slug":"nhap-database-vao-host-ssh","status":"publish","type":"post","link":"https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/","title":{"rendered":"Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi b\u1eb1ng SSH"},"content":{"rendered":"\n<p>T\u00f4i gi\u1ea3 s\u1eed l\u00e0 b\u1ea1n \u0111\u00e3 bi\u1ebft <a href=\"https:\/\/kiencang.net\/xuat-database-bang-ssh\/\" target=\"_blank\" rel=\"noreferrer noopener\">c\u00e1ch xu\u1ea5t database b\u1eb1ng SSH<\/a>, v\u00e0 di chuy\u1ec3n n\u00f3 t\u1eeb hosting c\u0169 v\u1ec1 hosting m\u1edbi.<\/p>\n\n\n<p>V\u00ec c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u01b0\u1eddng kh\u00f4ng l\u1edbn b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 d\u00f9ng FTP \u0111\u1ec3 t\u1ea3i n\u00f3 v\u1ec1 r\u1ed3i sau \u0111\u00f3 up l\u00ean l\u1ea1i m\u00e0 kh\u00f4ng m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian. Tuy nhi\u00ean n\u1ebfu \u0111\u00e3 bi\u1ebft d\u00f9ng SSH, ch\u1eafc b\u1ea1n c\u0169ng s\u1ebd mu\u1ed1n <a href=\"https:\/\/kiencang.net\/chuyen-file-hai-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">chuy\u1ec3n file gi\u1eefa 2 server kh\u00e1c nhau b\u1eb1ng SSH lu\u00f4n<\/a> cho ti\u1ec7n (t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch chuy\u1ec3n file n\u00e9n .zip).<\/p>\n\n\n<pre class=\"wp-block-code\"><code>scp -r root@123.123.345.345:\/home\/websitecu\/database.sql \/home\/websitemoi.com\/<\/code><\/pre>\n\n\n<p>B\u00e2y gi\u1edd \u0111\u1ebfn ph\u1ea7n ch\u00ednh, khi \u0111\u00e3 c\u00f3 file database, c\u00e2u l\u1ec7nh \u0111\u1ec3 b\u1ea1n nh\u1eadp c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u00e0o hosting m\u1edbi l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>mysql -u usr -p dbn &lt; database.sql<\/code><\/pre>\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n<ul><li><code>database.sql<\/code> n\u1eb1m trong th\u01b0 m\u1ee5c g\u1ed1c tr\u00ean hosting m\u1edbi;<\/li><li><code>usr<\/code> l\u00e0 user name c\u1ee7a b\u1ea3ng database tr\u00ean hosting m\u1edbi;<\/li><li><code>dbn<\/code> l\u00e0 t\u00ean b\u1ea3ng database tr\u00ean hosting m\u1edbi.<\/li><\/ul>\n\n\n<p>N\u1ebfu nh\u1eadp \u0111\u00fang th\u00f4ng tin n\u00f3 s\u1ebd h\u1ecfi b\u1ea1n password c\u1ee7a database, b\u1ea1n nh\u1eadp v\u00e0o nh\u1ea5n enter l\u00e0 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh nh\u1eadp database tr\u00ean hosting m\u1edbi.<\/p>\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y l\u1ec7nh nh\u1eadp database \u0111\u01a1n gi\u1ea3n h\u01a1n l\u1ec7nh xu\u1ea5t nhi\u1ec1u.<\/p>\n\n\n<p class=\"has-very-light-gray-background-color has-background\"><strong>Ngay t\u1eeb \u0111\u1ea7u l\u00e0m sao t\u00f4i t\u1ea1o \u0111\u01b0\u1ee3c n\u01a1i ch\u1ee9a database?<\/strong> T\u00f4i t\u1ea1o n\u00f3 qua control panel, v\u00ed d\u1ee5 v\u1edbi CyberPanel t\u00f4i l\u00e0m nh\u01b0 sau: Databases &gt; Create Database &gt; Select Website &gt; Ch\u1ecdn website t\u01b0\u01a1ng \u1ee9ng &gt; Nh\u1eadp t\u00ean user, t\u00ean b\u1ea3ng v\u00e0 pass v\u00e0o. Nh\u1ea5n save l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 database t\u01b0\u01a1ng \u1ee9ng v\u1edbi hosting m\u1edbi.<\/p>\n\n\n<p>Tuy nhi\u00ean ngay c\u1ea3 khi gi\u1ea3i n\u00e9n to\u00e0n b\u1ed9 website &amp; nh\u1eadp database tr\u00ean hosting m\u1edbi, khi truy c\u1eadp trang b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i k\u1ebft n\u1ed1i. Nguy\u00ean nh\u00e2n l\u00e0 v\u00ec file <code>wp-config.php<\/code> tr\u00ean hosting m\u1edbi v\u1eabn s\u1eed d\u1ee5ng th\u00f4ng tin c\u0169 t\u01b0\u01a1ng \u1ee9ng v\u1edbi host c\u0169. \u0110\u1ec3 ki\u1ec3m tra b\u1ea1n g\u00f5 l\u1ec7nh sau:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>cat wp-config.php<\/code><\/pre>\n\n\n<p>D\u00f9 SSH c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda \u0111\u01b0\u1ee3c file, t\u00f4i th\u1ea5y ch\u1ec9nh b\u1eb1ng FTP ti\u1ec7n h\u01a1n, b\u1ea1n d\u00f9ng n\u00f3 \u0111\u1ec3 truy c\u1eadp v\u00e0o file r\u1ed3i t\u00ecm &amp; ch\u1ec9nh c\u00e1c d\u00f2ng n\u00e0y theo th\u00f4ng tin t\u1eeb hosting m\u1edbi:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>\/** The name of the database for WordPress *\/\ndefine( 'DB_NAME', 'dbn_cua_ban' );\n\/** MySQL database username *\/\ndefine( 'DB_USER', 'usr_cua-ban' );\n\/** MySQL database password *\/\ndefine( 'DB_PASSWORD', 'pa_cua_ban' );<\/code><\/pre>\n\n\n<p>Nh\u1ea5n save l\u00e0 b\u1ea1n \u0111\u00e3 k\u1ebft n\u1ed1i th\u00e0nh c\u00f4ng v\u1edbi database. T\u1ea3i l\u1ea1i website l\u1ea7n n\u1eefa b\u1ea1n s\u1ebd th\u1ea5y website hi\u1ec7n ra thay v\u00ec b\u1ecb l\u1ed7i k\u1ebft n\u1ed1i.<\/p>\n\n\n<p>Nh\u1eadp database l\u00e0 b\u01b0\u1edbc t\u1ed1i 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 cho web WordPress b\u1eb1ng SSH<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>T\u00f4i gi\u1ea3 s\u1eed l\u00e0 b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch xu\u1ea5t database b\u1eb1ng SSH, v\u00e0 di chuy\u1ec3n n\u00f3 t\u1eeb hosting c\u0169 v\u1ec1 hosting m\u1edbi. V\u00ec c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u01b0\u1eddng kh\u00f4ng l\u1edbn b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 d\u00f9ng FTP \u0111\u1ec3 t\u1ea3i n\u00f3 v\u1ec1 r\u1ed3i sau \u0111\u00f3 up l\u00ean l\u1ea1i m\u00e0 kh\u00f4ng m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian. Tuy &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>Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi 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\/nhap-database-vao-host-ssh\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi b\u1eb1ng SSH &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"T\u00f4i gi\u1ea3 s\u1eed l\u00e0 b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch xu\u1ea5t database b\u1eb1ng SSH, v\u00e0 di chuy\u1ec3n n\u00f3 t\u1eeb hosting c\u0169 v\u1ec1 hosting m\u1edbi. V\u00ec c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u01b0\u1eddng kh\u00f4ng l\u1edbn b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 d\u00f9ng FTP \u0111\u1ec3 t\u1ea3i n\u00f3 v\u1ec1 r\u1ed3i sau \u0111\u00f3 up l\u00ean l\u1ea1i m\u00e0 kh\u00f4ng m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian. Tuy &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/nhap-database-vao-host-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-18T04:02:06+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":"Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi 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\/nhap-database-vao-host-ssh\/","og_locale":"vi_VN","og_type":"article","og_title":"Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi b\u1eb1ng SSH &#8226; Ki\u1ebfn c\u00e0ng","og_description":"T\u00f4i gi\u1ea3 s\u1eed l\u00e0 b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch xu\u1ea5t database b\u1eb1ng SSH, v\u00e0 di chuy\u1ec3n n\u00f3 t\u1eeb hosting c\u0169 v\u1ec1 hosting m\u1edbi. V\u00ec c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u01b0\u1eddng kh\u00f4ng l\u1edbn b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 d\u00f9ng FTP \u0111\u1ec3 t\u1ea3i n\u00f3 v\u1ec1 r\u1ed3i sau \u0111\u00f3 up l\u00ean l\u1ea1i m\u00e0 kh\u00f4ng m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian. Tuy &hellip;","og_url":"https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2020-08-18T04:02:06+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\/nhap-database-vao-host-ssh\/","url":"https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/","name":"Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi b\u1eb1ng SSH &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2020-08-18T04:02:06+00:00","dateModified":"2020-08-18T04:02:06+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/nhap-database-vao-host-ssh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"Nh\u1eadp database \/ c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress v\u00e0o hosting m\u1edbi 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\/16559"}],"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=16559"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/16559\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=16559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=16559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=16559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}