WordPress Search and Replace

WordPress stores absolute URLs in dozens of database tables, so a domain change or an SSL move leaves old addresses scattered through posts, options and plugin settings: a search and replace is how…

Kei te whakatakoto whakaaro a WordPress i ngā tūtira tūturu i roto i te mano o ngā tēpu pātengi raraunga, nō reira ko te panui rohe, te nekehanga SSL rānei, he āhuatanga tawhito e marara ana i roto i ngā pōkaro, ngā whiringa, me ngā tūmomo āhuatanga plugin: ko te rapu me te whakakapi te huarahi e whakakore ai i ēnei mea i te ārai. Ka whāki tēnei aratohu i ngā huarahi e rua e whakaae ana ki te mahi i konei i KPanel, he aha te take i kino ai tētahi āhuatanga tuatahi noa e tino matawhānui ana, me pēhea te whakamatau i te otinga.

I Te Wā E Hiahiatia ai

Te nekehanga mai i http:// ki https:// i muri i te hoatu i te SSL.
Te whakarerenga rohe, hei tauira old-brand.co.nz ki new-brand.co.nz.
I muri i te pana i te tiiroki ki te mahi tūturu, kei te noho tonu te ingoa pūmamae tiiroki i roto i te pātengi raraunga.
Te whakakore i tētahi pūkete rauemi tawhito me te ata whakatika i ia URI āhuatanga i te tēatera kotahi.
Te whakatika i tētahi he maha i puta ā-wao i te tini pōkaro, penei i tētahi nama waea tawhito, i tētahi ingoa taonga kāore e whakamahia koa.

Ka tuhituhi anō te rapu me te whakakapi i ngā rārangi puta noa i ia tēpu, ā karekau he whakahoki ā-rārangi. Tiri muri i mua i te tīmata, ia wā, ahakoa he whakarereke e āhuatanga iti nei. Ko KPanel e hanga āhuatanga tiri otomāti ina whakamahia e koe ngā taputapu i roto i konei, engari mēnā ka ā koe i te tohutohu i a koe tonu, ka tūturu nō koe mō tēnei. Tirohia Mā te Tiri Muri.

He Aha Ai E Kore ai e Taea te Whakatakoto Āhuatanga SQL REPLACE Noa Iho

Ko tēnei te hē kino tēnā i roto i te mahi pātengi raraunga WordPress, nō reira he mea karohirohi ki te mōhio i mua i te tohu i tētahi huarahi.

Ko WordPress e whakatakoto i ngā tūmomo plugin, ngā whiringa ahuatanga, me ngā raraunga widget i waenganui i ngā kupu whakatonutanga PHP. Ko tētahi kupu whakatonutanga e tuhituhi ana i te roa o ia uara i roto, penei:

a:1:{s:3:"url";s:26:"http://old-domain.co.nz/x";}

Ko tērā s:26 e kī ana ko te URI he 26 momotuhi te roa. Whakakapi i http:// ki https:// e whakamahi ana i tētahi REPLACE() SQL noa, ā ka ātea te tuhinga ki te 27 momotuhi ā ka kī tonu te roa i roto 26. Na reira e whakakāore a PHP te whakatonutanga o te whiringa katoa, ā ka hoki anō te tūmomo ki te pūmau. Ko ngā tūmomo āhuatanga i roto i te kaiwhakahōu āhuatanga, ngā torotoro e ngaro ai ā rātou torotoro, ngā raihana plugin e whakamaranga anō i a rātou.

Ko te whakarapu-whakakapi WP-CLI e whakatakoto ai a KPanel e whakakorikori i ia uara, e whakakapi ai i roto, ā e whakatohutohungia anō me ngā roa tika. Nō reira ko ia anake te āhuatanga e whakaataata ana i konei.

Kaua e whakatakoto i UPDATE wp_options SET option_value = REPLACE(...) rānei te mea ōrite i roto i phpMyAdmin ki tētahi pātengi raraunga WordPress. He āhuatanga e whakaatu ana kua whakatutuki, e whakaatu ana i ngā rārangi i pā, ā ka whakaparuparu noa i ia tūmomo whakatonutanga i pa ki a ia. Karekau he whakaora noa te whakahoki i tētahi tiri muri.

Huarahi 1: Te Kaari Rapu me te Whakakapi

Ko tēnei te whiringa tika mō te nuinga. Kei te āwhina i ia mahere WordPress.

Takihi ki KPanel ā pāwhiri i Websites i te pae taha maui.
Pāwhiri i te pae tūmotu.
Whakatuwhera i te WordPress tab, ā ka whakatuwhera i te Quick Actions wāhanga.
Kimihia te Search & Replace kaari ā pāwhiri i Configure.
Tuhia te tuhinga e noho ana i te Find (old value).
Tuhia te tuhinga hōu i te Replace with.
Waiho te Dry run (preview only, no changes) i tuhinga, ā pāwhiri i Preview.

Ko te dry run e whakaatu ana i te maha o ngā whakakapi e mahia ai ā e whakamaroke ai te kaute ki ia tēpu me te pou, nō reira koe e kite ai i te tino wāhi e tae ai te whakarereke i mua i te whakatau.

Kei te tika te āhuatanga matawhānui:

Whakamaranga i te Dry run.
Pāwhiri i Run.
Whakaōatu i te kōrerorero.

Ko tētahi tiri muri katoa e tuhia otomāti i mua i te tīmata o te whakakapi, ā ko te whakatakoto e kapi ana i ia tēpu katoa, rārangi mai i ngā plugin.

Rapu i te kupu tino whakapōtae ake. Te whakakapi i old-domain.co.nz e tuhi anō ai i mail.old-domain.co.nz me staging.old-domain.co.nz, karekau hea te hiahia rautaki. Te whakauru i te āhuatanga, penei i https://old-domain.co.nz, e mau ai te piri.

Huarahi 2: WP-CLI Mai i te Hōkoia

Ko te hōkoia e tuku ana i a koe i te inji ōrite me te mana nui ake ki runga i ngā hara. Ko tēnei tētahi o ngā wāhanga e puta ake ana i ngā mahere whakahaere; ki ērā atu mahere, ko te tab strip e whakaatu i tētahi hononga +8 on Managed hāngai.

Whakatuwhera i te pae tūmotu, ā ka WordPress, ā Console. Ko te tohu kē tīmata ana i wp, nō reira tuhia noa te toenga o te tohutohu.

Matawhānui i mua:

search-replace 'http://old-domain.co.nz' 'https://old-domain.co.nz' --all-tables --dry-run

Ā ka whakatakoto i a ia mō te ture:

search-replace 'http://old-domain.co.nz' 'https://old-domain.co.nz' --all-tables

Ko te hōkoia karekau e tiri muri mō koe. Ko te tiri muri otomāti i mua i te whakatakoto ka puta noa i te whakamahi i te kaari Rapu me te Whakakapi i te Huarahi 1. Mēnā ka whakatakoto koe i te tohutohu i konei, tiri muri i a koe i te kāinga mai i te Backups tab o te pae tūmotu.

Ngā hara whai painga:

Hara	He aha tāna mahi
`--all-tables`	Te whakauru i ngā tēpu āhuatanga i hanga ai e plugin, ehara noa i ngā tēpu matua o WordPress
`--dry-run`	E whakaatu ana i te āhuatanga ka rerekē ā karekau he tuhinga
`--precise`	Te whakamahi i te PHP hāngai i te SQL mō te whakakapi. He torutoru, engari e mau ana i ngā āhuatanga whakatonutanga taumaha
`--skip-columns=guid`	Te waiho i ngā GUID o te pōkaro (tirohia i raro)
`--report-changed-only`	Te tapahi i te putanga ki ngā tēpu i rerekē noa

He Kōrero mō ngā GUID

Ka whai tētahi pōkaro WordPress i tētahi guid pou. Ahakoa he āhuatanga URI, he tohu noa, ā ko ngā kaipānui iwiwiw e whakamahi ana i a ia ki te kōrero mēnā kua kite rānei i tētahi kaupapa. Ko te tuhi anō i tēnei e kore ai ngā pōkaro katoa i te iwiwiw e whakaatu anō he hōu.

Tuhi anō i ngā GUID i te wā ka whakarereke koe i te rohe mō ake tonu ā e tīmata anō. Waiho i a rātou e --skip-columns=guid i te wā ka nekehanga noa koe mai i te HTTP ki te HTTPS i taua rohe ōrite.

Te Whakarerenga Rohe: Me Whakamahi i te Kaari Whakarerenga Tūmotu Rohe Hāngai

Mēnā ko te āhuatanga katoa ko te nekehanga o te pae tūmotu ki te rohe hōu, kaua e tīmata i te rapu me te whakakapi. Ko te Change Site URL kaari, i taua wāhanga Quick Actions ōrite, e whakarerenga ana i ngā siteurl me home whiringa ā e whakatakoto i te whakakapi puta noa i ia tēpu i roto i tētahi mahi, i te raupapa tika. Ko te mahi i te atu huarahi e taea ai te whakahorohoro a WordPress ki te kawe i tana ake admin.

I Muri i te Whakakapi

Haere i roto i tēnei rārangi i mua i te karanga kua mahia.

Whakahorohoro te pūmamae. I te wāhanga Quick Actions, whakatakoto Flush Cache. Mēnā whakamahi te pae tūmotu i te pūmamae whārangi katoa, whakahorohoro mai i WordPress, ā Caching.
Whakahorohoro ngā ture tuhi anō. Whakatakoto Flush Rewrites i taua wāhanga ōrite, rānei whakatuwhera i Settings, ā Permalinks i wp-admin ā pāwhiri i Save Changes kore nei te whakarereke i te aha.
Whakahorohoro te CDN mēnā kei runga te pae tūmotu, mai i Performance, ā Kapsule CDN. Tirohia Whakahorohoro te Pūmamae CDN.
Uta te pae tūmotu i tētahi matapihi tapu kia kore ai te pūmamae pūtirotiro e whakamatau koe.
Tiro i te raka pokapū. Ko tētahi raka pokapū kore rānei whakatamariki i muri i te nekehanga SSL he āhuatanga URI i waiho: Te Whakatika i ngā Whakatamariki Āhuatanga Pahinga.
Pāwhiri i ngā whārangi māmā. Ko te home page slider, te logo pane, ia whārangi i hangaia e tētahi kai whakatuwhera whārangi, me te tapahinga i tētahi tore. Ko ēnei e mau ana i ngā URI e noho ana i roto i ngā whiringa whakatonutanga.
Whakahorohoro tētahi plugin pūmamae mai i tana ake wāhanga tūmomo.

Whakatairanga Take

Ko te dry run e whakaatu ana i te kore whakakapi. Ko te kupu karekau i roto i te pātengi raraunga i tērā āhuatanga tika. Tirohia he slash mutunga, tētahi www. tohu-mua, rānei te āhuatanga. Whaiaro rapu mō te ingoa pūmamae noa iho i mua tāpiri ki te whakaōatu kei te noho rānei.

Ngā āhuatanga āhuahanga e moemoea ana i muri i te whakarerenga rohe. Ko ngā URI pāpāho e noho ana i wp_posts me wp_postmeta ā e tīkina ai e --all-tables, engari te CDN rānei tētahi plugin whakapai āhuatanga e pūmamae ana i ana ake kōpī i tuhi anō. Whakahorohoro i te CDN me te pūmamae o te plugin, ā tukuwhiu anō.

Kua ngaro ngā tūmomo i muri i te whakakapi. Ko tēnā te take whakatonutanga, ā ko te āhuatanga e kī ana kua mahia te whakarereke e te SQL maro hāngai ehara i ngā taputapu i konei. Whakaoraia te tiri muri i mua i te whakatakoto: Te Whakaoraia Mai i tētahi Tiri Muri.

Ngā URI tiiroki e hoki tonu mai. Ko tētahi āhuatanga e pupuritanga anō, he tuutuu whakatakoto ā-rohe, rānei tētahi whiringa pūmamae. Tirohia te whakatakoto i Te Whakamahi i te Tiiroki: Te Pana me te Tango ā whakamatau kua tuhia te Rewrite URLs.

Te Whakatakoto i te Rapu me te Whakaui i a WordPress i roto i tō Pātengi Raraunga