{"id":36334,"date":"2025-09-30T06:01:00","date_gmt":"2025-09-30T03:01:00","guid":{"rendered":"https:\/\/coma.lv\/2025\/09\/30\/ka-atrast-un-aizstat-tekstu-sava-wordpress-datubaze-ar-vienu-klikski\/"},"modified":"2025-09-30T06:03:22","modified_gmt":"2025-09-30T03:03:22","slug":"ka-atrast-un-aizstat-tekstu-sava-wordpress-datubaze-ar-vienu-klikski","status":"publish","type":"post","link":"https:\/\/coma.lv\/lv\/2025\/09\/30\/ka-atrast-un-aizstat-tekstu-sava-wordpress-datubaze-ar-vienu-klikski\/","title":{"rendered":"K\u0101 atrast un aizst\u0101t tekstu sav\u0101 WordPress datub\u0101z\u0113 ar vienu klik\u0161\u0137i"},"content":{"rendered":"\n

Ja v\u0113laties atrast un aizvietot noteiktu tekstu, adresi vai att\u0113lu, to viegli var izdar\u012bt, izmantojot WordPress spraudni mekl\u0113\u0161anai un aizvieto\u0161anai vai vienk\u0101r\u0161u SQL vaic\u0101jumu.<\/p>\n

Kad var noder\u0113t mekl\u0113\u0161ana un aizvieto\u0161ana WordPress datub\u0101z\u0113<\/h2>\n

Pie\u0146emsim, ka esat pievienojis konkr\u0113tu tekstu vai adresi vair\u0101kiem saviem ierakstiem. J\u016bs nezin\u0101t, kuros tie\u0161i ierakstos tas ir pievienots, bet zin\u0101t, ka \u0161o ierakstu ir \u013coti daudz. Varat p\u0101rbaud\u012bt ierakstus manu\u0101li, viens p\u0113c otra, t\u0113r\u0113jot daudz laika un, visticam\u0101k, kaut ko palaist gar\u0101m.<\/p>\n

Izmantojot komandu mekl\u0113\u0161anai un aizvieto\u0161anai, to pa\u0161u var izdar\u012bt daudz \u0101tr\u0101k un efekt\u012bv\u0101k. Vien\u012bgais, kas j\u0101\u0146em v\u0113r\u0101, ir tas, ka, ja pie\u013causiet k\u013c\u016bdu, atpaka\u013c to vairs nevar\u0113s atgriezt. Tikl\u012bdz teksts tiek aizvietots, tas paz\u016bd uz visiem laikiem. T\u0101p\u0113c uzman\u012bgi ievadiet tekstu, ko mekl\u0113jat un ar ko aizvietosiet.<\/p>\n

Darba s\u0101k\u0161ana<\/h2>\n

K\u0101 jau min\u0113ts iepriek\u0161, izmai\u0146as nevar\u0113s atgriezt, t\u0101p\u0113c ieteicams izveidot datub\u0101zes rezerves kopiju \u2013 to var izdar\u012bt, izmantojot spraudni vai\u00a0phpMyAdmin<\/a> – p\u0113c tam var s\u0101kt mekl\u0113\u0161anu un aizvieto\u0161anu.<\/p>\n

Mekl\u0113\u0161ana un aizvieto\u0161ana, izmantojot spraudni<\/h2>\n

Ja neesat paz\u012bstams ar kodu un nev\u0113laties rakst\u012bt SQL vaic\u0101jumus, ir vienk\u0101r\u0161\u0101ks veids, k\u0101 atrast un aizvietot tekstu \u2014 WordPress spraudnis Better Search Replace<\/strong>.<\/p>\n

\"WordPress\"<\/p>\n

Tas \u013cauj palaist mekl\u0113\u0161anas un aizvieto\u0161anas komandas tie\u0161i WordPress admin panel\u012b.<\/p>\n

Galven\u0101 priek\u0161roc\u012bba ir t\u0101, ka Better Search Replace korekti str\u0101d\u0101 ar serializ\u0113tajiem datiem<\/strong>, kas bie\u017ei tiek glab\u0101ti WordPress opcij\u0101s un metadatos. Tas ir \u012bpa\u0161i svar\u012bgi, ja aizvietojat dom\u0113na nosaukumus vai p\u0101rejat uz HTTPS \u2014 vienk\u0101r\u0161a teksta aizvieto\u0161ana var boj\u0101t serializ\u0113tos mas\u012bvus. T\u0101d\u0113\u013c ieteicams izmantot tie\u0161i \u0161o spraudni vai WP-CLI (skat. zem\u0101k).<\/p>\n

SQL vaic\u0101juma palaide phpMyAdmin<\/h2>\n

Varat izmantot phpMyAdmin<\/a>, lai atrastu un aizvietotu tekstu WordPress datub\u0101z\u0113. Vispirms piesakieties savas hostinga cPanel admin panel\u012b. Ritiniet l\u012bdz sada\u013cai \u201cDatub\u0101zes\u201d un noklik\u0161\u0137iniet uz phpMyAdmin.<\/p>\n

\"WordPress\"<\/p>\n

Ekr\u0101nuz\u0146\u0113mum\u0101 redzama cPanel admina saskarne Hostnet. J\u016bsu saskarne var izskat\u012bties cit\u0101di. Tiks atv\u0113rts phpMyAdmin, kur jums j\u0101klik\u0161\u0137ina uz WordPress datub\u0101zes nosaukuma un p\u0113c tam uz SQL.<\/p>\n

\"WordPress\"<\/p>\n

SQL vaic\u0101jums j\u0101ievada \u0161\u0101di:<\/p>\n

<br \/>update TABLE_NAME set FIELD_NAME =<br \/>replace(FIELD_NAME, &#039;Text to find&#039;, &#039;text to replace with&#039;);<br \/><\/pre>\n
Piem\u0113ram, ja v\u0113laties atrast un nomain\u012bt tekstu WordPress ierakstos:<\/p>\n
<br \/>update wp_posts set post_content =<br \/>replace(post_content, &#039;Text to find&#039;, &#039;text to replace with&#039;);<br \/><\/pre>\n
Nospiediet pogu Go, lai turpin\u0101tu. phpMyAdmin palaid\u012bs SQL vaic\u0101jumu un veiksm\u012bgas izpildes gad\u012bjum\u0101 par\u0101d\u012bs aizvietoto rindu skaitu. Tagad varat p\u0101rbaud\u012bt savu vietni, lai redz\u0113tu izmai\u0146as.<\/p>\n
Piez\u012bme: tabulu prefikss var at\u0161\u0137irties no standarta wp_.<\/em><\/p>\n
Alternat\u012bva pieredz\u0113ju\u0161iem lietot\u0101jiem: WP-CLI<\/h2>\n
Liel\u0101k\u0101m vietn\u0113m un izstr\u0101d\u0101t\u0101jiem viens no \u0101tr\u0101kajiem veidiem teksta aizvieto\u0161anai \u0161obr\u012bd ir WP-CLI<\/a> \u2014 WordPress komandrindas r\u012bks. Tas ar\u012b atbalsta serializ\u0113tus datus un var str\u0101d\u0101t ar vis\u0101m tabul\u0101m vienlaic\u012bgi.<\/p>\n
Komandas piem\u0113rs:<\/p>\n
<br \/>wp search-replace &#039;http:\/\/oldsite.com&#039; &#039;https:\/\/newsite.com&#039; --all-tables<br \/><\/pre>\n
\u0160\u012b komanda veiks dro\u0161u aizvieto\u0161anu vis\u0101 datub\u0101z\u0113 un autom\u0101tiski apstr\u0101d\u0101s serializ\u0101ciju.<\/p>\n
\n
M\u016bsu specializ\u0101cija \u2014 WordPress viet\u0146u izstr\u0101de un uztur\u0113\u0161ana. Kontakti bezmaksas konsult\u0101cijai \u2014 vadim@coma.lv<\/a>, +371 29394520<\/a><\/em><\/p>\n
\n","protected":false},"excerpt":{"rendered":"
Ja v\u0113laties atrast un aizvietot noteiktu tekstu, adresi vai att\u0113lu, to viegli var izdar\u012bt, izmantojot WordPress spraudni mekl\u0113\u0161anai un aizvieto\u0161anai vai vienk\u0101r\u0161u SQL vaic\u0101jumu. Kad var noder\u0113t mekl\u0113\u0161ana un aizvieto\u0161ana WordPress datub\u0101z\u0113 Pie\u0146emsim, ka esat pievienojis konkr\u0113tu tekstu vai adresi vair\u0101kiem saviem ierakstiem. J\u016bs nezin\u0101t, kuros tie\u0161i ierakstos tas ir pievienots, bet zin\u0101t, ka \u0161o […]<\/p>\n","protected":false},"author":1,"featured_media":37651,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1226,1319],"tags":[],"class_list":["post-36334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-pamacibas"],"_links":{"self":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts\/36334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/comments?post=36334"}],"version-history":[{"count":5,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts\/36334\/revisions"}],"predecessor-version":[{"id":36337,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts\/36334\/revisions\/36337"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/media\/37651"}],"wp:attachment":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/media?parent=36334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/categories?post=36334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/tags?post=36334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}