{"id":22430,"date":"2021-07-31T19:06:00","date_gmt":"2021-07-31T12:06:00","guid":{"rendered":"https:\/\/kiencang.net\/?p=22430"},"modified":"2022-07-31T20:40:06","modified_gmt":"2022-07-31T13:40:06","slug":"toi-uu-hoa-csdl-wordpress","status":"publish","type":"post","link":"https:\/\/kiencang.net\/toi-uu-hoa-csdl-wordpress\/","title":{"rendered":"T\u1ed1i \u01b0u h\u00f3a database c\u1ee7a WordPress theo c\u00e1ch th\u1ee7 c\u00f4ng"},"content":{"rendered":"\n
C\u00f3 \u0111\u00f4i \u0111i\u1ec1u t\u00f4i mu\u1ed1n n\u00f3i v\u1ec1 v\u1ea5n \u0111\u1ec1 CSDL (database) trong WordPress.<\/p>\n\n\n\n
T\u00f4i t\u1eebng r\u1ea5t vui m\u1eebng khi kh\u00e1m ph\u00e1 ra plugin chuy\u00ean s\u00e2u \u0111\u1ec3 t\u1ed1i \u01b0u CSDL cho WordPress, n\u00f3 c\u00f3 t\u00ean: Advanced Database Cleaner<\/a>. Plugin n\u00e0y gi\u00fap ph\u00e1t hi\u1ec7n c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u d\u01b0 th\u1eeba, c\u00e1c cron jobs kh\u00f4ng c\u1ea7n thi\u1ebft v\u00e0 c\u1ea3 options kh\u00f4ng c\u00f2n c\u00f3 \u00edch n\u1eefa.<\/p>\n\n\n\n Nh\u01b0ng t\u00f4i nhanh ch\u00f3ng nh\u1eadn ra r\u1eb1ng, Advanced Database Cleaner c\u00f3 kh\u1ea3 n\u0103ng ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u d\u01b0 th\u1eeba kh\u00f4ng t\u1ed1t \u0111\u1ebfn m\u1ee9c \u0111\u1ee7 \u0111\u1ec3 b\u1ea1n an t\u00e2m d\u1ef1a ho\u00e0n to\u00e0n v\u00e0o n\u00f3<\/em>. \u0110\u1eb7c bi\u1ec7t l\u00e0 \u1edf chi\u1ec1u d\u1eef li\u1ec7u \u0111\u00f3 th\u1ef1c t\u1ebf l\u00e0 d\u01b0 th\u1eeba<\/strong> nh\u01b0ng Advanced Database Cleaner l\u1ea1i cho r\u1eb1ng n\u00f3 thu\u1ed9c v\u1ec1 plugin n\u00e0o \u0111\u00f3 ho\u1eb7c c\u1ee7a WordPress Core (l\u00f5i c\u1ee7a WordPress, c\u00e1c t\u00e0i nguy\u00ean quan tr\u1ecdng kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p x\u00f3a). Chi\u1ec1u ng\u01b0\u1ee3c l\u1ea1i n\u00f3 \u00edt l\u1ed7i h\u01a1n, ngh\u0129a l\u00e0 n\u1ebfu n\u00f3 x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u n\u00e0o \u0111\u1ea5y l\u00e0 d\u01b0 th\u1eeba (orphaned), kh\u1ea3 n\u0103ng cao n\u00f3 l\u00e0 d\u01b0 th\u1eeba th\u1eadt.<\/p>\n\n\n\n C\u00f3 l\u00fd do cho \u0111i\u1ec1u n\u00e0y:<\/p>\n\n\n\n \u0110\u1ec3 t\u00f4i \u0111\u01b0a ra v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u h\u01a1n.<\/p>\n\n\n\n D\u1eef li\u1ec7u d\u01b0 th\u1eeba gi\u1ed1ng nh\u01b0 \u0111\u1ed3 \u0111\u1ea1c d\u01b0 th\u1eeba trong nh\u00e0 ch\u00fang ta v\u1eady. Vi\u1ec7c mua s\u1eafm \u0111\u1ed3 \u0111\u1ea1c cho c\u0103n nh\u00e0 c\u0169ng kh\u00f4ng kh\u00e1c g\u00ec ta c\u00e0i c\u1eafm r\u1ea5t nhi\u1ec1u plugin, th\u1eed c\u00e1i n\u1ecd c\u00e1i kia tr\u00ean website. Qua th\u1eddi gian, nhi\u1ec1u \u0111\u1ed3 \u0111\u1ea1c trong nh\u00e0 tr\u1edf n\u00ean v\u00f4 d\u1ee5ng v\u00e0 chi\u1ebfm m\u1ea5t kh\u00f4ng gian, t\u01b0\u01a1ng t\u1ef1, c\u00e1c plugin kh\u00f4ng d\u00f9ng c\u0169ng th\u1ebf, th\u1eadm ch\u00ed c\u00f2n t\u1ec7 h\u01a1n \u1edf kh\u00eda c\u1ea1nh l\u00e0 ngay c\u1ea3 khi b\u1ea1n \u0111\u00e3 g\u1ee1 b\u1ecf b\u1ea3n c\u00e0i \u0111\u1eb7t c\u1ee7a n\u00f3 th\u00ec v\u1eabn c\u00f2n h\u00e0ng t\u00e1 d\u1eef li\u1ec7u d\u01b0 th\u1eeba trong CSDL<\/strong> (\u0111a s\u1ed1 c\u00e1c plugin kh\u00f4ng t\u1ef1 d\u1ecdn d\u1eb9p ch\u00ednh n\u00f3 sau khi \u0111\u01b0\u1ee3c g\u1ee1 c\u00e0i \u0111\u1eb7t).<\/p>\n\n\n\n Nh\u01b0ng t\u1ea1i sao c\u00e1c plugin kh\u00f4ng ch\u1ecbu x\u00f3a (m\u1ed9t s\u1ed1) b\u1ea3ng n\u00f3 \u0111\u00e3 t\u1ea1o trong database?<\/p>\n\n\n\n C\u00f3 \u00edt nh\u1ea5t hai l\u00fd do gi\u1ea3i th\u00edch v\u00ec sao plugin n\u00e0o \u0111\u1ea5y kh\u00f4ng x\u00f3a s\u1ea1ch CSDL c\u1ee7a n\u00f3:<\/p>\n\n\n\n OK, gi\u1edd th\u00ec ta \u0111\u00e3 hi\u1ec3u nguy\u00ean nh\u00e2n c\u1ee7a vi\u1ec7c kh\u00f4ng th\u1ec3 d\u1ef1a ho\u00e0n to\u00e0n v\u00e0o c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng. Nh\u01b0ng t\u1ed1i \u01b0u CSDL theo c\u00e1ch th\u1ee7 c\u00f4ng c\u0169ng kh\u00f4ng h\u1ec1 \u0111\u01a1n gi\u1ea3n, n\u00f3 \u0111\u00f2i h\u1ecfi b\u1ea1n m\u1ed9t s\u1ed1 th\u1ee9 nh\u01b0:<\/p>\n\n\n\n (*): T\u00f4i g\u1eb7p ph\u1ea3i r\u1ea5t nhi\u1ec1u kh\u00f3 kh\u0103n khi t\u1ed1i \u01b0u CSDL th\u1ee7 c\u00f4ng cho trang kh\u00f4ng ph\u1ea3i do b\u1ea3n th\u00e2n l\u00e0 ng\u01b0\u1eddi qu\u1ea3n tr\u1ecb ch\u00ednh. L\u00fd do kh\u00f3 kh\u0103n n\u1eb1m \u1edf ch\u1ed7 b\u1ea1n kh\u00f4ng bi\u1ebft ch\u00ednh x\u00e1c website n\u00e0y t\u1eebng c\u00e0i plugin n\u00e0o, v\u00ec trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p \u0111\u00e2y l\u00e0 th\u00f4ng tin c\u1ea7n ph\u1ea3i c\u00f3 \u0111\u1ec3 ra quy\u1ebft \u0111\u1ecbnh ch\u00ednh x\u00e1c c\u00f3 n\u00ean lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u n\u00e0o hay kh\u00f4ng.<\/p>\n\n\n\n So s\u00e1nh gi\u1eefa t\u1ed1i \u01b0u b\u1eb1ng c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng v\u00e0 t\u1ed1i \u01b0u th\u1ee7 c\u00f4ng: th\u1ef1c ra, \u0111\u00e2y kh\u00f4ng ph\u1ea3i so s\u00e1nh thu\u1ea7n t\u00fay \u0111\u1ed1i l\u1eadp nhau, m\u00e0 n\u00f3 n\u00f3i l\u00ean r\u1eb1ng t\u1ed1i \u01b0u th\u1ee7 c\u00f4ng n\u00ean \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng \u0111\u1ec3 cho k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t (**). T\u1ed1i \u01b0u th\u1ee7 c\u00f4ng ho\u00e0n to\u00e0n th\u00ec s\u1ebd r\u1ea5t v\u1ea5t v\u1ea3:<\/p>\n\n\n\n