{"id":55665,"date":"2022-08-05T11:20:11","date_gmt":"2022-08-05T04:20:11","guid":{"rendered":"https:\/\/wiki.tino.org\/staging\/?post_type=ht_kb&#038;p=55665"},"modified":"2022-08-05T11:20:14","modified_gmt":"2022-08-05T04:20:14","slug":"cach-import-va-export-database-mysql-bang-lenh-tren-terminal","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/cach-import-va-export-database-mysql-bang-lenh-tren-terminal\/","title":{"rendered":"C\u00e1ch Import V\u00e0 Export Database Mysql B\u1eb1ng L\u1ec7nh Tr\u00ean Terminal\u00a0"},"content":{"rendered":"\n<p>\u0110\u1ed1i v\u1edbi c\u00e1c file sql dung l\u01b0\u1ee3ng l\u1edbn tr\u00ean 1GB b\u1ea1n s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi import qua giao di\u1ec7n web phpmyadmin khi b\u1ecb gi\u1edbi h\u1ea1n upload file c\u1ee7a php ho\u1eb7c b\u1ecb timeout&#8230;<br>B\u00e0i vi\u1ebft n\u00e0y, TinoHost s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch import file mysql th\u00f4ng qua l\u1ec7nh command tr\u00ean terminal.<\/p>\n\n\n\n<h3 id=\"K\u1ebft_n\u1ed1i_hosting\/vps_b\u1eb1ng_giao_th\u1ee9c_SSH\">K\u1ebft n\u1ed1i hosting\/vps b\u1eb1ng giao th\u1ee9c SSH<\/h3>\n\n\n\n<p>+ B\u1ea1n truy c\u1eadp v\u00e0o hosting b\u1eb1ng t\u00e0i kho\u1ea3n \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5p.<\/p>\n\n\n\n<p>+ Tr\u00ean b\u1ea3ng \u0111i\u1ec1n khi\u1ec3n ch\u1ecdn \u201cSFTP Connection\u201d \u0111\u1ec3 l\u1ea5y th\u00f4ng tin k\u1ebft n\u1ed1i c\u1ee7a hosting<\/p>\n\n\n\n<p>Ho\u1eb7c t\u00e0i kho\u1ea3n root c\u1ee7a VPS\/Server \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5p qua email \u0111\u0103ng k\u00fd d\u1ecbch v\u1ee5.<\/p>\n\n\n\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ch\u01b0a bi\u1ebft s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u201cSSH\/SFTP Connection\u201d b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn\u00a0<a href=\"https:\/\/tino.vn\/blog\/docs\/huong-dan-cach-su-dung-phan-mem-putty-ket-noi-ssh-toi-vps\/\" data-type=\"URL\" data-id=\"https:\/\/tino.vn\/blog\/docs\/huong-dan-cach-su-dung-phan-mem-putty-ket-noi-ssh-toi-vps\/\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>H\u01b0\u1edbng d\u1eabn import v\u00e0 export database mysql<\/p>\n\n\n\n<h3 id=\"1._Export_database_(xu\u1ea5t_d\u1eef_li\u1ec7u)\">1. Export database (xu\u1ea5t d\u1eef li\u1ec7u)<\/h3>\n\n\n\n<p>T\u1ea1i terminal b\u1ea1n nh\u1eadp v\u00e0o c\u00e2u l\u1ec7nh sau \u0111\u1ec3 export d\u1eef li\u1ec7u:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td>mysqldump -u username -p database_name &gt; backup.sql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><a href=\"https:\/\/tenten.vn\/ten-mien\/summer-sale-newid?code=dQXqjEIzeploWFrf&amp;idCampaign=2419\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><\/a><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>username<\/code>&nbsp;l\u00e0 t\u00ean ng\u01b0\u1eddi d\u00f9ng b\u1ea1n c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/li><li><code>database_name<\/code>&nbsp;l\u00e0 t\u00ean c\u1ee7a c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u1ec3 xu\u1ea5t<\/li><li><code>backup.sql<\/code>&nbsp;l\u00e0 t\u1ec7p trong th\u01b0 m\u1ee5c hi\u1ec7n t\u1ea1i l\u01b0u tr\u1eef k\u1ebft qu\u1ea3 \u0111\u1ea7u ra.<\/li><\/ul>\n\n\n\n<p>Khi ch\u1ea1y l\u1ec7nh s\u1ebd hi\u1ec7n th\u00f4ng b\u00e1o nh\u1eadp password, b\u1ea1n c\u1ea7n nh\u1eadp password c\u1ee7a database \u0111\u1ec3 xu\u1ea5t d\u1eef li\u1ec7u th\u00e0nh c\u00f4ng. (khi nh\u1eadp pass s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb k\u00fd t\u1ef1 n\u00e0o)<\/p>\n\n\n\n<p>L\u1ec7nh s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 xu\u1ea5t d\u1eef li\u1ec7u, \u0111\u1ec3 xem k\u1ebft qu\u1ea3 b\u1ea1n vui l\u00f2ng d\u00f9ng c\u00e2u l\u1ec7nh sau \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3: ls -l<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 id=\"2._Import_database_(nh\u1eadp_d\u1eef_li\u1ec7u)\"><strong>2. Import database (nh\u1eadp d\u1eef li\u1ec7u)<\/strong><\/h3>\n\n\n\n<p>T\u1ea1i terminal b\u1ea1n nh\u1eadp v\u00e0o c\u00e2u l\u1ec7nh sau \u0111\u1ec3 export d\u1eef li\u1ec7u:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td>mysql -u username -p new_database &lt; backup.sql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><code>username<\/code>&nbsp;l\u00e0 t\u00ean ng\u01b0\u1eddi d\u00f9ng b\u1ea1n c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/li><li><code>newdatabase<\/code>&nbsp;l\u00e0 t\u00ean c\u1ee7a c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o<\/li><li><code>backup.sql<\/code>&nbsp;l\u00e0 t\u1ec7p k\u1ebft xu\u1ea5t d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c nh\u1eadp, n\u1eb1m trong th\u01b0 m\u1ee5c hi\u1ec7n t\u1ea1i<\/li><\/ul>\n\n\n\n<p>N\u1ebfu l\u1ec7nh ch\u1ea1y th\u00e0nh c\u00f4ng, n\u00f3 s\u1ebd kh\u00f4ng t\u1ea1o ra b\u1ea5t k\u1ef3 \u0111\u1ea7u ra n\u00e0o. N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 l\u1ed7i n\u00e0o x\u1ea3y ra trong qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u th\u00ec h\u1ec7 th\u1ed1ng s\u1ebd th\u00f4ng b\u00e1o l\u1ed7i v\u00e0 b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00e1c th\u00f4ng tin m\u00e0 qu\u00fd kh\u00e1ch nh\u1eadp t\u1ea1i c\u00e2u l\u1ec7nh<\/p>\n\n\n\n<p>Sau khi import database th\u00e0nh c\u00f4ng, b\u1ea1n truy c\u1eadp phpMyAdmin ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u00e3 nh\u1eadp.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn Export\/Import mysql t\u1eeb terminal qua d\u00f2ng l\u1ec7nh. hy v\u1ecdng b\u00e0i vi\u1ebft ph\u1ea7n n\u00e0o gi\u00fap \u00edt \u0111\u01b0\u1ee3c cho b\u1ea1n trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng dich v\u1ee5 VPS\/Hosting t\u1ea1i TinoHost.<\/p>\n\n\n\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ed1i v\u1edbi c\u00e1c file sql dung l\u01b0\u1ee3ng l\u1edbn tr\u00ean 1GB b\u1ea1n s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi import qua giao di\u1ec7n web phpmyadmin khi b\u1ecb gi\u1edbi h\u1ea1n upload file c\u1ee7a php ho\u1eb7c b\u1ecb timeout&#8230;B\u00e0i vi\u1ebft n\u00e0y, TinoHost s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch import file mysql th\u00f4ng qua l\u1ec7nh command tr\u00ean terminal. K\u1ebft n\u1ed1i hosting\/vps b\u1eb1ng giao [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":16424,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[17],"class_list":["post-55665","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-huong-dan-ve-cloud-vps"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/55665","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=55665"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/55665\/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=55665"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=55665"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=55665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}