Zimbalwa izinto ezikhathazayo njengokufumanisa ukuba iwebhusayithi yakho iphantsi - ngakumbi ukuba uthembele kuyo ngeshishini. Umyalezo othi "Impazamo yokuSeka uQhagamshelwano lweDatha yeDatha" imele umba onzima kwaye inqanda konke ukufikelela kwisiza sakho, ngoko ke ukuyilungisa yinto ephambili. Nangona kunjalo, ukuba awuqhelananga nendlela i-WordPress esebenza ngayo, inokuba yingxaki edidayo. Nangona le mpazamo inzulu, iyakwazi ukulungiswa kakhulu. Ngamanyathelo ambalwa okusombulula ingxaki, unokwenza indawo yakho ibuyele kwi-intanethi ngokukhawuleza.
Yintoni "Impazamo ekuSekweni koQhakamshelwano lweDatabase"?
Phantse yonke ingcaciso yewebhusayithi - kubandakanywa idatha yeposi, idatha yekhasi, ulwazi lwe-meta, izicwangciso ze-plugin, iziqinisekiso zokungena, kunye nokunye - igcinwe kwaye ihlelwe kwi-database ye-MySQL. Idatha kuphela engagcinwanga kukho isiqulatho semidiya esifana nemifanekiso kunye nomxholo wakho/iplagin/iifayile ezingundoqo ezifana Index.php, wp-login.php, njl njl. Iwebhusayithi yakho ixhomekeke kulwimi olukwicala lomncedisi olubizwa ngokuba yi-PHP.
Xa isivakashi sifika kwindawo yakho, i-WordPress isebenzisa i-PHP ukubuza i-database kwaye idonsa ulwazi oluchanekileyo, oluthi luboniswe njengephepha elipheleleyo. Ukuba, ngenxa yaso nasiphi na isizathu, i-WordPress ayikwazi ukufikelela kwisiseko sedatha yesayithi lakho okanye ayisebenzi ngokufanelekileyo, umphumo ngumyalezo othi "Impazamo yokuSeka uQhagamshelwano lweDatha".
"Impazamo ekusekeni uxhulumaniso lwedatha" ithetha ukuba iwebhusayithi yakho ayisanxibelelani okanye inokufikelela kwisiseko sedatha yakho ye-WordPress, kwaye ke yonke iwebhusayithi yakho iyehla. Le mpazamo inqanda lonke iphepha ekulayisheni. Iphepha lilonke alinalutho kuba akukho datha inokufunyanwa ukunika eli phepha, njengoko unxibelelwano lungasebenzi kakuhle. Akunjalo kuphela oku kuphula i-frontend yesayithi lakho, kodwa kuya kukuthintela ukuba ufikelele kwideshibhodi yakho ye-WordPress.
Ukuba indawo yakho isebenzisa i-caching, iindwendwe zisenokubona iikopi ezigciniweyo zamaphepha akho. Ke ngoko, ukuba ubamba impazamo kwangoko kwaye usombulule ingxaki ngaphambi kokuba i-cache yendawo yakho ihlaziye, unokunqanda ukuphazamiseka okuninzi kwindawo yakho nakwishishini. Ngethamsanqa, njengoko iimpazamo ze-WordPress zihamba, impazamo yoqhagamshelo lwesiseko sedatha ihlala ilula ukuyicombulula.
Yintoni ebangela "impazamo yokuSekwa koQhagamshelwano lweDatabase"?
Imposiso ekusekeni uqhagamshelwano lwesiseko sedata ivela kuba uxhulumaniso lweMySQL-PHP luqhawulwe ngesizathu esithile. Nayiphi na kwezi meko zilandelayo inokubangela le mpazamo:
- Iziqinisekiso zokungena kwisiseko sedatha ezingachanekanga: Mhlawumbi esona sizathu sixhaphakileyo sokuba 'Impazamo yokuSekwa koQhakamshelwano lweDatha yeDatha' kukuba i-WordPress ineziqinisekiso zokungena ezingachanekanga kwisiseko sedatha yakho. Oku kunokuba ligama lesiseko sedatha, igama lomsebenzisi, okanye igama lokugqitha. Khumbula, ezi nkcukacha zokungena zahlukile kwezo uzisebenzisayo ukufikelela kwindawo yakho.
- Urhwaphilizo lwesiseko sedatha: I-WordPress MySQL database iqulethe ulwazi oluninzi. Ukuba nayiphi na inxalenye icinyiwe okanye yonakele, umphumo unokuba yimpazamo ekuthethwa ngayo. Urhwaphilizo lunokubangelwa kukukhangelwa kwedatha ngesandla, kodwa lunokwenzeka nje ngesiphumo sokusetyenziswa okuqhelekileyo. Nangona i-MySQL yomelele, akukho nto igqibeleleyo, kwaye iimpazamo ziyenzeka.
- Urhwaphilizo lwefayile engundoqo yeWordPress: Ngokufanayo, inkohlakalo ingenzeka kwiifayile ze-WordPress eziphambili ezenza indawo yakho. Nangona ezi fayile zingaphandle kwedathabheyisi, ngamanye amaxesha zinokubangela impazamo efanayo.
- Iingxaki ngomncedisi wewebhu okanye umboneleli wokubamba: Ukuba iingxaki zivela kunye nomncedisi wakho okanye umncedisi (ukuba u-self-host) kwaye i-WordPress ayikwazi ukufikelela kuyo ukubuza i-database, iya kuphosa le mpazamo. Ezi ngxaki zinokubandakanya ukucima, ilahleko yedatha, kunye nokusilela kwehardware.
Uyilungisa njani "impazamo yokuSeka uQhagamshelwano lweDatabase"
Nangona oku kuyimpazamo enkulu, ngethamsanqa kulula ukuyisombulula. Nantsi imiyalelo yokusombulula ingxaki kunye nokulungisa ingxaki.
1. Khangela iziqinisekiso zakho ze-WordPress database
Kuba lo ngoyena nobangela wempazamo, kufuneka kwakhona ibe linyathelo lokuqala ekuxazululeni ingxaki yakho. Into yokuqala ekufuneka uyenzile kukufumana iziqinisekiso ezisetyenziswa yiWordPress ngoku ukufikelela kwisiseko sedatha yakho. Olu lwazi lugcinwe kwindawo yakho WP-config.php ifayile. Unokusebenzisa iCanel okanye iFTP/SFTP ukufikelela kuyo. Apha, khangela amaqhekeza amathathu olwazi - igama lesiseko sedatha, igama lomsebenzisi, kunye negama lokugqitha.
Ngolu lwazi esandleni, yiya kwi-MySQL Databases yakho. Qinisekisa ukuba igama lesiseko sedatha lihambelana naleyo utsale kuyo WP-config.php ngaphambili. Ukuba ayihambelani, buyela ku WP-config.php kwaye uyihlaziye ngegama elichanekileyo lesiseko sedatha. Qinisekisa ukuba igama lomsebenzisi okanye igama lokugqitha lihambelana nezikwi WP-config.php ifayile, ukuba akunjalo, emva koko zihlaziye ngeenkcukacha ezichanekileyo.
2. Jonga ulwazi lomamkeli wedatha yakho
Ukuba uhlolisise iziqinisekiso zokungena kwi-database kwaye ulungise naziphi na iimpazamo, kodwa usafumana umyalezo othi "Impazamo yokuSeka uQhagamshelwano lweDatabase", into elandelayo omele uyijonge lulwazi lwakho lomgcini wedatha. Igama lenginginya lesiseko sedatha yakho linokufumaneka WP-config.php, ekunene ecaleni kwegama lesiseko sedatha kunye neempawu zokungena.
Qaphela olu lwazi, emva koko uye kwi-MySQL Databases usebenzisa i-cPanel okanye i-FTP/SFTP, qiniseka ukuba igama lenginginya kweyakho. WP-config.php ifayile zidweliswe kweli phepha. Ukuba akunjalo, kuya kufuneka udibanise. Xa ugqibile, cofa ku “Yenza eligama lenginginya le-MySQL” ngoku. Qaphela ukuba kungathatha iiyure ezimbalwa ukuba igama lenginginya elitsha lisasazeke nge-DNS, ngoko zikhululeke ukuthatha ikhefu apha. Xa ixesha lidlulile, buya kwaye ujonge ukuba indawo yakho iyasebenza.
3. Lungisa i-database yakho ye-WordPress
Ukuba usafumana umyalezo wemposiso, ungazama ukulungisa i-database ukulungisa urhwaphilizo olunokwenzeka. Ungasebenzisa isixhobo sokulungisa i-WordPress esakhelwe ngaphakathi kule nto. Ukufikelela kuyo, vula eyakho WP-config.php ifayile kwaye wongeze ikhowudi elandelayo ekugqibeleni:
define('WP_ALLOW_REPAIR', true);
Okulandelayo, vula ithebhu entsha yesikhangeli kwaye uhambe uye ku-https://yoursitename.com/wp-admin/maint/repair.php, ubuyisela "igama lakho" kunye nesizinda sokwenyani sewebhusayithi yakho. Oku kuya kuzisa isixhobo sokulungisa isiseko sedatha. Cofa ku 'Lungisa iDatabase' kwaye uyeke ukuba yenze into yayo. Unokukhetha u-'Lungisa kwaye wenze iDatha yeNkcukacha' ukuba uyathanda, kodwa kuthatha ixesha elide kakhulu. Nokuba yeyiphi na indlela, xa isixhobo sigqityiwe, layisha iwebhusayithi yakho kwakhona kwaye ujonge impazamo.
Ukuba ihambile, uya kwazi ukuba i-database eyonakeleyo ibingunobangela. Nangona kunjalo, ukuba usawubona umyalezo wemposiso, yiya kwinyathelo elilandelayo. Ngaphambi kokuba wenze, qiniseka ukuba uphinde ubuyele WP-config.php kwaye ucime ikhowudi oyongezileyo ukuvula isixhobo. Ukuba uyishiya apho, umntu oneenjongo ezimbi unokufikelela ngokulula kwindawo yakho.
4. Khangela ukuba iseva yedatha yakho iphantsi
Ukuba onke la manyathelo angentla awaphumelelanga, enye inokwenzeka kukuba iseva yakho yedatha yehlile. Ngeli xesha, luluvo olulungileyo ukuqinisekisa kunye nomboneleli wakho wokubamba ukuba yonke into isebenza ngokuchanekileyo. Kukho inani lezizathu zokuba kutheni umphathi wesiseko sedatha okanye umncedisi angafumana imiba:
- Kuninzi kakhulu uqhagamshelo lwangaxeshanye kwisiseko sedatha: Abanye ababoneleli banemida yokuba zingaphi uqhagamshelo umncedisi anokuba nalo ngexesha elinye.
- Iingxaki nenye indawo kwiseva yakho yokubamba ekwabelwana ngayo: Ukuba ukwisicwangciso sokubamba ekwabelwana ngaso, wahlulahlula izixhobo kunye nezinye iisayithi. Ukuba omnye wabo uneengxaki, inokuphalala kwindawo yakho. Esi sesinye sezizathu ezinikezelweyo okanye ezilawulwa yi-WordPress izicwangciso zokubamba kunokuba luncedo.
- Iingxaki ze-Hardware: I-Hardware ekugqibeleni iyasilela, kwaye kunokwenzeka ukuba iseva egcinwe kuyo idatabase yakho iyenzile kanye loo nto. Ngokufanelekileyo, umamkeli wakho uya kuba nokuphindaphinda endaweni ukuze ukuba iseva enye iyehla, kukho enye ikopi yedatha yakho ekhoyo, kodwa oku akusoloko kunjalo - ngakumbi ukuba ubamba eyakho idatabase kwikhaya okanye kwiseva yeofisi.
Ukubheja kwakho okuhle apha kukufikelela kumphathi wakho wewebhu kwaye ubuze malunga nokuphuma okanye eminye imiba eyaziwayo.
5. Hlaziya i-URL yesayithi yakho ye-WordPress
Ukuba usandul 'ukuhambisa ufakelo lwakho lwe-WordPress nangasiphi na isizathu (njengokufudukela kwigama elitsha lesizinda okanye ukufudukela kwi-HTTPS), unokufuna ukuhlaziya i-URL yendawo yakho kwisiseko sedatha.
6. Qala ngokutsha iseva yakho yewebhu
Lo unokubonakala usisiseko esincinci, kodwa ngamanye amaxesha ezona zisombululo zilula zezona zisebenzayo. Ukuba ubamba i-database yakho kwiseva yakho, zama ukuyicima kwaye uyibuyisele. Iikhompyuter zintsonkothile, kwaye ukuqalisa kwakhona ngokulula kunokulungisa zonke iintlobo zeengxaki ezingaqhelekanga onokuthi uhlangabezane nazo.
7. Qhagamshelana nombuki zindwendwe wakho ukuze ufumane uncedo
Ukuba awukhululekanga ukwenza eyakho ingxaki, okanye uzame yonke into kwaye awukakwazi ukususa umyalezo othi “Impazamo yokuSekwa koQhagamshelwano lweDatha, akukho ntloni ekufikeleleni uncedo.
isiphelo
Ukuba uye wajonga kwiwebhusayithi yakho kwaye wazifumana ubuliswa ngumyalezo othi "Impazamo yokuSeka uQhagamshelwano lweDatabase", awuwedwa. Yimpazamo eqhelekileyo ngolungiso olulula, ke ngoko ukufumana indawo yakho kwaye isebenze kwakhona akufanele kube nzima kakhulu.