Ko ia pae tukutuku KapsuleHost he pūkete raraunga tōna ka whiwhi uru pūkete raraunga mā te pūtirotiro mā roto i te phpMyAdmin, e tuwhera ana mā te takirua-whakamana kotahi (single sign-on), nō reira kāore he kupuhipa tuarua hei pupuru. E kapi ana tēnei aratohu i te tuwhera i a ia, te pānui i ō taipitopito hononga, ngā mahi e tika ana kia mahia i reira, me ngā mahi pūkete raraunga e rua kāore rawa koe e tika ana kia mahia i roto i te phpMyAdmin i runga i tētahi pae tukutuku WordPress.
Te Tuwhera i te phpMyAdmin
- Takiuru ki KPanel ka pāwhiri ai i Ngā Paetukutuku i te taha maui.
- Pāwhiritia tō pae tukutuku.
- I roto i te tahua ake a te pae tukutuku, tuwhera i Putanga Raraunga.
- Pāwhiritia Tuwhera te phpMyAdmin.
Ka tuwhera te phpMyAdmin i roto i tētahi ripa hōu, kua takiuru kē, ā, kua anga tonu atu ki te pūkete raraunga a tō pae tukutuku. Kāore he puka takiuru me kāore hoki he tikanga whakaū motuhake hei tiaki.
Mēnā ka kī mai te wharangi kāore he pūkete raraunga kua whakaritea mō tēnei momo pae tukutuku, he mea tūmau tēnā. Ka hangaia ngā pae tukutuku HTML pūmau me ētahi momo taupānga kāore he pūkete raraunga. Ko ngā momo pae tukutuku e whakamahi ana i tētahi pūkete raraunga, tae atu ki te WordPress me te WooCommerce, he pūkete raraunga tōna i ngā wā katoa.
Ō Taipitopito Hononga
Kei taua mata anō ngā whakaūtanga e whakamahia ana e tō taupānga, me tōna pātene tārua me te kupuhipa e huna ana i muri i tētahi mana whakaatu:
| Āpure | Uara |
|---|---|
| Host | 127.0.0.1 |
| Tauranga | 3306 |
| Pūkete raraunga | Tō ingoa pūkete raraunga |
| Ingoa kaiwhakamahi | Tō kaiwhakamahi pūkete raraunga |
| Kupuhipa | Kua huna tae noa ki tō pāwhiri i te whakaatu |
Koia ēnei ngā uara e tika ana kia whakaurua ki roto i te wp-config.php, i tētahi kōnae .env, ki ngā whirihoranga pūkete raraunga a tētahi anaketanga rānei.
Ko te tikanga o 127.0.0.1 ko "tēnei tūmau". Kāore e taea te tae atu mai i tō rorohiko kakau, ā, ahakoa pēhea tō whakarite i te pātū ahi, kāore e huri tēnei: kāore rawa te pūkete raraunga e whakarongo ana ki tētahi wāhitau tūmatanui, nā te hoahoa anō. Hei hono atu i tētahi kiritaki pākihi pēnei i te TablePlus, i te Sequel Ace rānei, whakamahia he ana mā te SSH. Tirohia Te Hono atu ki Tō Pūkete Raraunga mā te Ana SSH.
Hei Aha Tēnei Taputapu
He take motuhake ā te phpMyAdmin e tika ai tōna whai wāhi:
- Te pānui raraunga. Te whakaū i ngā mea i tino rokohanga e tētahi uru hononga, te tirotiro mēnā kei te tū tētahi rārangi, te tatau i ngā pūkete.
- Te kawe mai i tētahi pūkete raraunga i te wā o tētahi hūnuku, i tētahi whakahokinga anō rānei.
- Te kawe atu i tētahi pūkete raraunga, hei kape haumaru anō, hei tuku atu rānei ki tētahi kaiwhakawhanake.
- Te whakatika i tētahi uara pakaru kotahi, pēnei i tētahi
siteurli pōhēhē te tāu mai, ā, kua ārai nei i a koe i te wp-admin. - Te whakatau i te rahi. Mā te whakaraupapa i ngā ripanga mā te rahi ka kite tonu koe mēnā kua rahi rawa tētahi ripanga rangitaki, ripanga taurangi rānei.
Te Kawe mai i tētahi Pūkete Raraunga
- Tuwheratia te phpMyAdmin mai i te ripa Database.
- Pāwhiritia tō ingoa pūkete raraunga i te papa maui.
- Pāwhiritia Import kei runga.
- Kōwhiritia te kōnae
.sqlka pāwhiri ai i Go.
Ka whakakapia e tētahi kawe mai ngā ripanga e rite ana. Kāore ia e whakakotahi.
He mahi whakangaromanga, he mahi tonu hoki te kawe mai ki runga i tētahi pūkete raraunga e mahi ana. Ka whakakapia ia rārangi i roto i tētahi ripanga e rite ana ki tā roto i te kōnae, ā, kāore he "whakakore" i roto i te phpMyAdmin. Tangohia tuatahitia he haumaru mai i te whārangi Tuku Kōpī a te pae tukutuku: Te Tango i tētahi Haumaru.
Mō tētahi kawe nui, kōpeehia tuatahitia ki .sql.gz, e whakaaetia ana e te phpMyAdmin, ā, mā konei ka iti ake te rahi o te kōnae i raro i te ōkawa tukunga. Mēnā kei te rahi tonu, wehewehea ki ētahi kōnae maha mā ia ripanga, tukuna mai rānei he tiikiti ā mā mātou e kawe mai mā te taha tūmau mōu.
Te Kawe atu i tētahi Pūkete Raraunga
- Pāwhiritia tō ingoa pūkete raraunga i te papa maui.
- Pāwhiritia Export.
- He tika te Quick me te hōputu SQL mō tētahi kape ōkawa. Kōwhiritia Custom mēnā he ripanga motuhake tāu e hiahia ana, mēnā rānei kei te hiahia koe kia gzip-tia te putanga.
- Pāwhiritia Go.
He kape whaihua anō te kaweatanga a te phpMyAdmin, ehara i te rautaki haumaru. Ko te pūkete raraunga anake tāna e hopu ai, kāore ōu kōnae, ā, ka noho tonu ki te wāhi i tiakina ai e koe. Ka haumarutia aunoatia tō pae tukutuku ia rā me ngā mea e rua, ā, ka taea e koe te tango i tētahi ā-ringa i ngā wā katoa: Te Tango i tētahi Haumaru.
E Rua ngā Mea Kia Kaua e Mahia i Konei
Kaua e whakahaere i tētahi rapu me whakakapinga mā te SQL
Ka rongoātia e te WordPress ngā tautuhinga uru hononga me kaupapa ataata hei aho whakaraupapa PHP (serialised), e rekoata ana i te roa o ia uara kei roto. Ka huri tētahi patapatai REPLACE() i te kuputuhi me te kore e huri i te roa kua rekoatahia, nō reira kāore te PHP e taea te pānui i te kōwhiringa, ā, ka hoki noa ki te putu kore mā te pokokohua. Ka ngaro ngā tautuhinga kaupapa ataata, ka putu ngā tōrere, ka whakakorea ngā raihana.
Whakamahia te kāri Rapu me Whakakapinga i te ripa WordPress a te pae tukutuku, e whakahaere tika ana i te whakaraupapa (serialisation) ā ka tango tuatahi i tētahi haumaru. Whakamāramatanga katoa: Te Whakahaere i tētahi Rapu me Whakakapinga.
Kaua e tautuhi anō i tētahi kupuhipa mā te whakatika i te wp_users
E kī ana ngā aratohu tawhito kia whakaritea e koe user_pass mā te whakamahi i te mahi MD5 mai i te tātai hekeheke a te phpMyAdmin. Kāore te WordPress o nāianei e whakamahi ana i ngā tātanga MD5, ā, mēnā ka hē tēnei mahi, ka ārai noatia te pūkete kaiwhakamahi, kāore e tautuhia anōtia.
He taputapu tika tā KPanel mō tēnei mahi i te ripa WordPress a te pae tukutuku, kātahi ka Users: takiuru tika atu mā Login as, tuku i tētahi īmēra tautuhinga anō, kape rānei i tētahi hono tautuhinga anō hei tuku atu māu anō. Tirohia Te Tautuhi Anō i tētahi Kupuhipa Kaiwhakahaere WordPress kua Ngaro.
Ngā Taputapu Pūkete Raraunga WordPress i roto i te KPanel
Mō ngā mahi pūkete raraunga WordPress o ia rā, he haumaru ake, he tere ake hoki te ripa WordPress, kātahi te wāhanga Putanga Raraunga, i te phpMyAdmin. Ka hoatu e ia ngā rahi ripanga i te tirohanga poto, te whakarite pai me te whakatika me tētahi haumaru aunoa kua tangohia tuatahi, te whakahuri i ngā ripanga tawhito ki tētahi pūnaha rokiroki hou, me te horoi pātene kotahi mō ngā whakarōpūtanga panuitanga, ngā tuhinga tauira tāutō, ngā taurangi kua pau te wā, me ngā panuitanga kua paopaotia. Kei tētahi wāhanga anō te rapu me whakakapinga, i runga i Ngā Mahi Tere.
Whakamahia te phpMyAdmin ina hiahia koe kia titiro ki ngā rārangi mata (raw rows). Whakamahia te wāhanga Database ina hiahia koe kia huri i tētahi mea.
Te Whakatikatika Raru
Kāore e tuwhera te phpMyAdmin. Me whai mana tuhi te pātene ki te pae tukutuku. Mēnā he pānui-anake noa iho tō tūranga pūkete KapsuleHost, pātaitia tētahi rangatira pūkete. Mēnā he mana tuhi tāu ā kei te hē tonu, tērā pea kei te whakaritea tonu te pae tukutuku: tirohia te konihi tūnga kei runga ake o te pae tukutuku.
Kāore e taea e au te hono mai i tōku rorohiko kakau mā ngā taipitopito kei te ripa Database. He tika tēnā, ā, he mea whakaaro tonu. Kāore te pūkete raraunga e whakaaturia ana ki te marea. Whakamahia he ana SSH: Te Hono atu ki Tō Pūkete Raraunga mā te Ana SSH.
Ka mutu te kaweatanga mai me te kore he hapa. Tata tonu he take rahi kōnae. Gzip-tia, wehewehea rānei.
I huri ahau i tētahi uara ā kua pakaru te pae tukutuku. Whakahokia mai i te haumaru hōu rawa: Te Whakahoki Mai i tētahi Haumaru. Koinei te take e tangohia tuatahitia ai te haumaru.
Kua nui rawa ake ngā ripanga. Whakaraupapatia mā te rahi i roto i te phpMyAdmin kia kitea te take, kātahi ka horoia mai i te ripa WordPress, kātahi te wāhanga Putanga Raraunga, kaua e mukua ngā rārangi mā te ringa.