{"id":2776,"date":"2024-05-08T10:08:10","date_gmt":"2024-05-08T08:08:10","guid":{"rendered":"https:\/\/areaweb2.pppcreative.sk\/?p=2776"},"modified":"2026-05-29T16:13:53","modified_gmt":"2026-05-29T16:13:53","slug":"wordpress-databaza","status":"publish","type":"post","link":"https:\/\/www.areaweb.sk\/cs\/wordpress-databaza\/","title":{"rendered":"WordPress databaza"},"content":{"rendered":"

Udaje k DB<\/strong> sa nach\u00e1daj\u00fa v kore\u0148ovom prie\u010dinku webu vo wp-config<\/strong>.php<\/p>\n\n\n\n

Pri migr\u00e1cii dom\u00e9ny sta\u010d\u00ed zmeni\u0165 url v tomto s\u00fabore a bude v\u00e1m web fungova\u0165:<\/p>\n\n\n\n

define(‘WP_HOME’, ‘https:\/\/www.areaweb.sk’);
define(‘WP_SITEURL’, ‘https:\/\/www.areaweb.sk’);<\/p>\n\n\n\n

alebo:<\/strong>

UPDATE frxdyu_posts SET post_content = replace(post_content, ‘areaweb.sk’, ‘areaweb.pppcreative.sk’)
UPDATE frxdyu_postmeta SET meta_value = replace(meta_value, ‘areaweb.sk’, ‘areaweb.pppcreative.sk’)<\/p>\n\n\n\n

UPDATE wp_options SET option_value = replace(option_value, ‘oldurl.com’, ‘newurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, ‘oldurl.com’,’newurl.com’);<\/p>\n\n\n\n

UPDATE `mquyvz_posts` SET `post_content` = REPLACE(`post_content`, 'skuska1', 'pecka') WHERE `post_content` LIKE '%podrá\u017eka s vysokou ohybnos\u0165ou pre maximálne pohodlné chodenie%' COLLATE utf8mb4_bin\n\nUPDATE `vebu_posts` SET `post_content` = REPLACE(`post_content`, 'Parameter2', 'Parameter2') WHERE `post_content` LIKE '%pecka pecka%' COLLATE utf8mb4_bin;\n\nUPDATE `mquyvz_posts` SET `post_content` = REPLACE(`post_content`, 'Charakteristika:', 'Dokonalý komfort pri státí.<br> Charakteristika:') WHERE `post_content` LIKE '%podrá\u017eka s vysokou ohybnos\u0165ou pre maximálne pohodlné chodenie%' COLLATE utf8mb4_bin;<\/code><\/pre>\n\n\n\n
 https:\/\/www.hostinger.com\/tutorials\/wordpress\/how-to-change-wordpress-urls-in-mysql-database-using-phpmyadmin<\/a><\/p>\n\n\n\n
alebo pou\u017ei\u0165 plugin<\/strong>
Better Search Replace<\/a>
Go Live Update URLs<\/a>
WP Migrate DB Plugin<\/a>
<\/p>\n\n\n\n
WordPress datab\u00e1za<\/strong> (MySQL\/MariaDB) uklad\u00e1 pr\u00edspevky, nastavenia, pou\u017e\u00edvate\u013eov a objedn\u00e1vky. S\u00fabory v FTP nesta\u010dia na z\u00e1lohu obsahu.<\/p>\n\n\n\n
Hlavn\u00e9 tabu\u013eky<\/h2>\n\n\n\n