{"id":15847,"date":"2024-06-17T11:59:00","date_gmt":"2024-06-17T04:59:00","guid":{"rendered":"https:\/\/blog.tinohost.com\/?p=2215"},"modified":"2026-10-26T10:27:28","modified_gmt":"2026-10-26T03:27:28","slug":"cach-lay-database-cua-website-tren-hosting-cpanel","status":"publish","type":"post","link":"https:\/\/tino.vn\/blog\/cach-lay-database-cua-website-tren-hosting-cpanel\/","title":{"rendered":"C\u00e1ch l\u1ea5y database c\u1ee7a website tr\u00ean hosting cPanel (2 c\u00e1ch)"},"content":{"rendered":"\n

\u0110\u1ec3 l\u1ea5y database c\u1ee7a website tr\u00ean hosting cPanel, b\u1ea1n m\u1edf phpMyAdmin, ch\u1ecdn database v\u00e0 b\u1ea5m Export, ho\u1eb7c v\u00e0o Backup v\u00e0 b\u1ea5m t\u00ean database \u1edf m\u1ee5c t\u1ea3i b\u1ea3n sao l\u01b0u MySQL.<\/strong> C\u00e1ch \u0111\u1ea7u cho file .sql<\/code>, c\u00e1ch sau cho file n\u00e9n .gz<\/code>; c\u1ea3 hai \u0111\u1ec1u ch\u1ee9a to\u00e0n b\u1ed9 b\u1ea3ng v\u00e0 d\u1eef li\u1ec7u c\u1ee7a website.<\/p>\n\n\n\n

B\u00e0i thu\u1ed9c nh\u00f3m qu\u1ea3n tr\u1ecb website tr\u00ean hosting<\/a> trong ch\u1ee7 \u0111\u1ec1 hosting<\/a>. B\u1ea1n c\u1ea7n l\u1ea5y database khi chuy\u1ec3n website sang hosting kh\u00e1c, gi\u1eef m\u1ed9t b\u1ea3n sao tr\u01b0\u1edbc khi c\u1eadp nh\u1eadt l\u1edbn, ho\u1eb7c g\u1eedi d\u1eef li\u1ec7u cho ng\u01b0\u1eddi h\u1ed7 tr\u1ee3 k\u1ef9 thu\u1eadt ki\u1ec3m tra l\u1ed7i.<\/p>\n\n\n\n

Database c\u1ee7a website ch\u1ee9a nh\u1eefng g\u00ec?<\/h2>\n\n\n\n

Database<\/a> c\u1ee7a website l\u01b0u to\u00e0n b\u1ed9 d\u1eef li\u1ec7u \u0111\u1ed9ng: b\u00e0i vi\u1ebft, trang, t\u00e0i kho\u1ea3n ng\u01b0\u1eddi d\u00f9ng, s\u1ea3n ph\u1ea9m, \u0111\u01a1n h\u00e0ng v\u00e0 ph\u1ea7n l\u1edbn c\u1ea5u h\u00ecnh. M\u00e3 ngu\u1ed3n v\u00e0 \u1ea3nh n\u1eb1m trong th\u01b0 m\u1ee5c public_html<\/code>, c\u00f2n n\u1ed9i dung n\u1eb1m trong database MySQL ho\u1eb7c MariaDB. V\u00ec v\u1eady sao l\u01b0u website ph\u1ea3i l\u1ea5y c\u1ea3 hai ph\u1ea7n.<\/p>\n\n\n\n

M\u1ed9t hosting cPanel th\u01b0\u1eddng c\u00f3 nhi\u1ec1u database (website c\u0169, b\u1ea3n th\u1eed nghi\u1ec7m, plugin). Tr\u01b0\u1edbc khi t\u1ea3i, c\u1ea7n bi\u1ebft ch\u00ednh x\u00e1c database n\u00e0o \u0111ang \u0111\u01b0\u1ee3c website d\u00f9ng.<\/p>\n\n\n\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ea5y database c\u1ee7a website tr\u00ean hosting cPanel<\/h2>\n\n\n\n

L\u1ea5y database tr\u00ean cPanel g\u1ed3m hai vi\u1ec7c: x\u00e1c \u0111\u1ecbnh \u0111\u00fang t\u00ean database website \u0111ang d\u00f9ng, r\u1ed3i t\u1ea3i n\u00f3 v\u1ec1 b\u1eb1ng phpMyAdmin (Export) ho\u1eb7c b\u1eb1ng trang Backup.<\/strong> phpMyAdmin cho file .sql<\/code> v\u00e0 cho ch\u1ecdn t\u1eebng b\u1ea3ng; Backup t\u1ea3i nguy\u00ean m\u1ed9t database d\u1ea1ng n\u00e9n, \u00edt b\u1ecb ng\u1eaft h\u01a1n v\u1edbi database l\u1edbn.<\/p>\n\n\n\n

X\u00e1c \u0111\u1ecbnh t\u00ean database c\u1ea7n l\u1ea5y<\/h3>\n\n\n\n

T\u00ean database ghi trong file c\u1ea5u h\u00ecnh c\u1ee7a m\u00e3 ngu\u1ed3n. V\u1edbi WordPress, m\u1edf wp-config.php<\/code> trong File Manager v\u00e0 xem d\u00f2ng DB_NAME<\/code> (wp-config.php \u1edf \u0111\u00e2u<\/a>). M\u00e3 ngu\u1ed3n kh\u00e1c th\u01b0\u1eddng d\u00f9ng file .env<\/code>, config.php<\/code> ho\u1eb7c configuration.php<\/code>. Tr\u00ean cPanel, t\u00ean database th\u01b0\u1eddng c\u00f3 ti\u1ec1n t\u1ed1 l\u00e0 t\u00ean t\u00e0i kho\u1ea3n hosting, v\u00ed d\u1ee5 tentaikhoan_wp386<\/code>.<\/p>\n\n\n\n

Sau khi c\u00f3 t\u00ean database, ch\u1ecdn m\u1ed9t trong hai c\u00e1ch d\u01b0\u1edbi.<\/p>\n\n\n\n

\"So<\/figure>\n\n\n\n

C\u00e1ch 1: Export database t\u1eeb phpMyAdmin<\/h3>\n\n\n\n

Truy c\u1eadp cPanel >> phpMyAdmin<\/strong> (m\u1ee5c Databases) >> ch\u1ecdn database \u1edf c\u1ed9t tr\u00e1i, sau \u0111\u00f3 b\u1ea5m tab Xu\u1ea5t<\/strong> (Export). N\u1ebfu ch\u01b0a quen giao di\u1ec7n, xem phpMyAdmin l\u00e0 g\u00ec<\/a>.<\/p>\n\n\n\n

\"phpMyAdmin<\/figure>\n\n\n\n

\u1ea2nh ch\u1ee5p tr\u00ean phpMyAdmin 4.8.5; b\u1ea3n hi\u1ec7n h\u00e0nh l\u00e0 5.2.3 (phpmyadmin.net, 25\/10\/2026), tab Xu\u1ea5t (Export) v\u1eabn \u1edf c\u00f9ng v\u1ecb tr\u00ed.<\/em><\/p>\n\n\n\n

phpMyAdmin chuy\u1ec3n sang trang ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c xu\u1ea5t. \u0110\u1ec3 m\u1eb7c \u0111\u1ecbnh Nhanh<\/em> v\u00e0 \u0111\u1ecbnh d\u1ea1ng SQL<\/em>, r\u1ed3i b\u1ea5m Th\u1ef1c hi\u1ec7n<\/strong> \u0111\u1ec3 t\u1ea3i file v\u1ec1 m\u00e1y.<\/p>\n\n\n\n

\"Trang<\/figure>\n\n\n\n

Ch\u1ecdn T\u00f9y th\u00edch<\/em> (Custom) khi c\u1ea7n nhi\u1ec1u h\u01a1n: ch\u1ec9 xu\u1ea5t m\u1ed9t s\u1ed1 b\u1ea3ng, n\u00e9n file b\u1eb1ng gzip \u0111\u1ec3 t\u1ea3i nhanh h\u01a1n, ho\u1eb7c th\u00eam l\u1ec7nh DROP TABLE<\/code> \u0111\u1ec3 khi nh\u1eadp l\u1ea1i s\u1ebd ghi \u0111\u00e8 b\u1ea3ng c\u0169. Database l\u1edbn, xu\u1ea5t qua tr\u00ecnh duy\u1ec7t c\u00f3 th\u1ec3 b\u1ecb ng\u1eaft; khi \u0111\u00f3 d\u00f9ng c\u00e1ch 2.<\/p>\n\n\n\n

C\u00e1ch 2: T\u1ea3i database t\u1eeb t\u00ednh n\u0103ng Backup c\u1ee7a cPanel<\/h3>\n\n\n\n

Truy c\u1eadp cPanel >> m\u1ee5c Files >> Backup<\/strong>.<\/p>\n\n\n\n

\"Giao<\/figure>\n\n\n\n

\u1ede ph\u1ea7n t\u1ea3i b\u1ea3n sao l\u01b0u MySQL (Download a MySQL Database Backup<\/em>), cPanel li\u1ec7t k\u00ea m\u1ecdi database tr\u00ean hosting. B\u1ea5m v\u00e0o t\u00ean database \u0111\u1ec3 t\u1ea3i v\u1ec1; theo t\u00e0i li\u1ec7u cPanel<\/a>, file c\u00f3 d\u1ea1ng n\u00e9n .gz<\/code>.<\/p>\n\n\n\n

\u1ea2nh ch\u1ee5p giao di\u1ec7n cPanel n\u0103m 2023. Tr\u00ean c\u00e1c b\u1ea3n cPanel hi\u1ec7n h\u00e0nh, m\u1ee5c n\u00e0y n\u1eb1m \u1edf ph\u1ea7n Partial Backups, d\u01b0\u1edbi ti\u00eau \u0111\u1ec1 Databases.<\/em><\/p>\n\n\n\n

Hosting c\u00f3 JetBackup (nh\u01b0 trong \u1ea3nh) c\u00f2n cho t\u1ea3i database t\u1eeb c\u00e1c b\u1ea3n sao l\u01b0u t\u1ef1 \u0111\u1ed9ng c\u1ee7a nh\u1eefng ng\u00e0y tr\u01b0\u1edbc, h\u1eefu \u00edch khi d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i \u0111\u00e3 h\u1ecfng. C\u00e1ch l\u00e0m xem b\u00e0i kh\u00f4i ph\u1ee5c d\u1eef li\u1ec7u hosting b\u1eb1ng JetBackup 5<\/a>.<\/p>\n\n\n\n

Ki\u1ec3m tra file database sau khi t\u1ea3i v\u1ec1<\/h2>\n\n\n\n

Sau khi t\u1ea3i, ki\u1ec3m tra file database theo b\u1ed1n \u0111i\u1ec3m: dung l\u01b0\u1ee3ng kh\u00e1c 0, c\u00f3 l\u1ec7nh t\u1ea1o b\u1ea3ng v\u00e0 ch\u00e8n d\u1eef li\u1ec7u, k\u1ebft th\u00fac b\u1eb1ng m\u1ed9t c\u00e2u l\u1ec7nh ho\u00e0n ch\u1ec9nh, v\u00e0 \u0111\u00e3 c\u00f3 b\u1ea3n l\u01b0u ngo\u00e0i hosting.<\/strong> M\u1ed9t file t\u1ea3i d\u1edf v\u1eabn mang \u0111\u00fang t\u00ean, n\u00ean c\u1ea7n m\u1edf th\u1eed tr\u01b0\u1edbc khi xo\u00e1 hay ghi \u0111\u00e8 d\u1eef li\u1ec7u tr\u00ean hosting.<\/p>\n\n\n\n