{"id":7519,"date":"2024-01-16T08:44:33","date_gmt":"2024-01-16T08:44:33","guid":{"rendered":"https:\/\/musilda.cz\/?p=7519"},"modified":"2024-01-16T08:44:33","modified_gmt":"2024-01-16T08:44:33","slug":"jak-vycistit-databazi-wordpress-webu","status":"publish","type":"post","link":"https:\/\/affinite.io\/cs\/jak-vycistit-databazi-wordpress-webu\/","title":{"rendered":"Jak vy\u010distit datab\u00e1zi WordPress webu"},"content":{"rendered":"\n

\u010casto opom\u00edjen\u00fdm t\u00e9matem je datab\u00e1ze WordPressu, kter\u00e1 se postupem \u010dasu zapl\u0148uje daty a\u017e do t\u00e9 m\u00edry, kdy zp\u016fsobuje probl\u00e9my v samotn\u00e9 rychlosti webov\u00fdch str\u00e1nek. V tomto \u010dl\u00e1nku se pod\u00edv\u00e1me hned na n\u011bkolik mo\u017en\u00fdch zp\u016fsob\u016f \u010di\u0161t\u011bn\u00ed WordPress datab\u00e1ze.<\/p>\n\n\n\n

Co je to datab\u00e1ze? <\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

Datab\u00e1ze je zjednodu\u0161en\u011b \u0159e\u010deno souhrn strukturovan\u00fdch dat. Data se zde ukl\u00e1daj\u00ed a t\u0159\u00edd\u00ed do r\u016fzn\u00fdch tabulek. Ve WordPressu mohou b\u00fdt za data pova\u017eov\u00e1na nap\u0159\u00edklad informace o vytvo\u0159en\u00fdch str\u00e1nk\u00e1ch, tagy, informace o u\u017eivatel\u00edch… <\/p>\n\n\n\n

Probl\u00e9m nast\u00e1v\u00e1 u n\u011bkter\u00fdch WordPress plugin\u016f, kter\u00e9 i po sv\u00e9m odstran\u011bn\u00ed obsahuj\u00ed n\u011bkter\u00e1 data v datab\u00e1zi a brzd\u00ed t\u00edm cel\u00fd web. <\/p>\n\n\n\n

Tabulky v datab\u00e1zi vytvo\u0159en\u00e9 WordPressem<\/h2>\n\n\n\n

Po instalaci WordPressu se automaticky vytvo\u0159\u00ed 12 z\u00e1kladn\u00edch tabulek v datab\u00e1zi:<\/p>\n\n\n\n

wp_users<\/td>Obsahuje ve\u0161ker\u00e9 informace o u\u017eivatel\u00edch<\/td><\/tr>
wp_usermeta<\/td>Ukl\u00e1d\u00e1 dodate\u010dn\u00e9 metainformace o u\u017eivatel\u00edch<\/td><\/tr>
wp_comments<\/td>Jednotliv\u00e9 koment\u00e1\u0159e na webu<\/td><\/tr>
wp_commentmeta<\/td>Ukl\u00e1d\u00e1 dodate\u010dn\u00e9 metainformace o koment\u00e1\u0159\u00edch<\/td><\/tr>
wp_options<\/td>Obsahuje r\u016fzn\u00e1 nastaven\u00ed u jednotliv\u00fdch plugin\u016f a motiv\u016f v\u010detn\u011b glob\u00e1ln\u00edho nastaven\u00ed WP<\/td><\/tr>
wp_links<\/td>Tato tabulka byla v minulosti vyu\u017e\u00edv\u00e1na k uchov\u00e1v\u00e1n\u00ed odkaz\u016f na jin\u00e9 webov\u00e9 str\u00e1nky. Od ur\u010dit\u00e9 verze WordPressu (kolem 2015) je pova\u017eov\u00e1na za zastaralou a pou\u017e\u00edv\u00e1 se pro zachov\u00e1n\u00ed kompatibility<\/td><\/tr>
wp_postmeta<\/td>Ukl\u00e1d\u00e1 dodate\u010dn\u00e9 metainformace o jednotliv\u00fdch p\u0159\u00edsp\u011bvc\u00edch<\/td><\/tr>
wp_termmeta<\/td>Podobn\u011b jako wp_postmeta, ukl\u00e1d\u00e1 dodate\u010dn\u00e9 metainformace o jednotliv\u00fdch polo\u017ek\u00e1ch(kategorie, \u0161t\u00edtky…)<\/td><\/tr>
wp_posts<\/td>Obsahuje t\u00e9m\u011b\u0159 ve\u0161ker\u00fd obsah webu. Pat\u0159\u00ed sem nap\u0159\u00edklad p\u0159\u00edsp\u011bvky a str\u00e1nky<\/td><\/tr>
wp_term_relationships<\/td>Slou\u017e\u00ed k propojen\u00ed nap\u0159\u00edklad p\u0159\u00edsp\u011bvk\u016f se \u0161t\u00edtky, a kategoriemi v tabulce wp_terms<\/td><\/tr>
wp_term_taxonomy<\/td>Ukl\u00e1d\u00e1n\u00ed informac\u00ed o taxonomii.<\/td><\/tr>
wp_terms<\/td>Obsahuje informace o kategori\u00edch a \u0161t\u00edtc\u00edch<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

V\u00edce informac\u00ed najdete v \u010dl\u00e1nku „Struktura WordPress datab\u00e1ze<\/a>„.<\/p>\n\n\n\n

Jak vy\u010distit datab\u00e1zi WordPressu<\/h2>\n\n\n\n

Uvedeme si dva nej\u010dast\u011bj\u0161\u00ed zp\u016fsoby:<\/p>\n\n\n\n