Uyilungisa njani i-WordPress database

WordPress iguquke kakhulu ukusukela oko yaqalwa apho yayisebenza khona isixhobo kubloga, kwaye namhlanje yi-CMS epheleleyo, esetyenziswa zizo zonke iintlobo zeziza ezidumileyo kwihlabathi lonke njengesiseko sokulawula umxholo kunye nokupapashwa. Kodwa ukuba kukho into enomdla ngale projekthi eyenziwe ngu Mat mullenwegg kwaye yintoni eyabona ukukhanya okokuqala ngo-2003 kukuphakama kwayo okuphezulu, okusivumela ukuba siyisebenzise ngokulinganayo nokuba iseva yasekhaya okanye iwebhusayithi yenkampani enkulu.

Kodwa ngaphandle komgangatho wayo, i-WordPress ayixolelwanga kwiingxaki kwaye ngenxa yoko kunokwenzeka ukuba i-database ifumana umonakalo othile, iyonke okanye ezinye iitafile zayo. Ngayiphi na imeko, iya kuba ngaphezulu ngokwaneleyo ukuba ibhlog yethu ingabonwa ngokuchanekileyo, kuba iphethe uxelele i-CMS ukuba ijonge phi iitekisi, imifanekiso kunye neminye imixholo esiyibonayo kwisithuba ngasinye.

Uphawu olungathandabuzekiyo koku iya kuba ngumyalezo olandelayo kwilog yokufakwa kweWindowsPress: 'Itafile yemposiso yedatha yeWordPress' ./my_home/wp_posts 'iphawulwe njengophazanyisiweyo kwaye okokugqibela (ngokuzenzekelayo?) Ukulungiswa akuphumelelanga kumbuzo KHETHA post_date_gmt KWI-wp_posts APHO post_status =' publish 'AND post_type IN (' post ',' page ',' attachment ') UKUYALELWA NGE-post_date_gmt DESC LIMIT 1 eyenziwe yi (' wp-blog-header.php '), wp, WP-> ephambili, WP-> send_headers, get_lastpostmodified, get_lastpostdate, _get_last_post_time'

Masibone ke ukuba silungisa njani isiseko sedatha esonakeleyo kwindawo yethu Ukufakwa kweWordPress, ekufuneka singene kuyo yiCpanel yeseva yethu, ethi njengabo banesizinda sabo esisingathiweyo kulwamkelo oluthile bayazi kakuhle licandelo esingena kulo kuqwalaselo lweeparameter ezahlukeneyo kunye neemodyuli eziyinxalenye yalo.

Apho kufuneka siye kwicandelo le- Iinkcukacha -> I-MySQL yolwazi, apho kufuneka sijonge khona ukhetho lwe 'Ukulungiswa kwedatha', efumaneka kwicandelo le 'Guqula oovimba beenkcukacha'. Ukusikhokela ngcono, eli candelo libekwe ngezantsi kweli candelo 'Yenza isiseko sedatha esitsha', ke kufuneka sikhethe isiseko sedatha esiza kuyilungisa kwaye emva koko ucofe kwiqhosha 'Ukulungiswa kwedatha', emva koko siza kuboniswa inqanaba ledatha yokufakwa kweWindowsPress, kwaye into ekufuneka siyibonile ukuba yonke into ihambe kakuhle 'KULUNGILE' ecaleni kwegama letafile nganye eyenzileyo.

Ngoku mhlawumbi endaweni yakhe cPanel masibe nokufikelela kwiingcambu mncedisi apho i database, iya kuba njalo ukuba sisingatha iserver yethu okanye ikwiyunivesithi okanye kwinkampani. Oku kuyasivumela ukuba sisebenze ngendlela eya kuthi isetyenziselwe i-linuxers, kwaye ivela kwi Umgca wokuyalela.

Inyathelo lokuqala kukumisa iserver MySQL:

$ Sudo service mysql yeka

Emva koko silungisa i-database ebonisa iingxaki, esizenzayo ngalo myalelo ulandelayo:

$ cd / var / lib /
$ sudo myisamchk -r -v -f mysql / /

Emva koko siqala kwakhona iseva ye-MySQL:

$ sudo service mysql qala

Zombini ezi ndlela ziya kusivumela ukuba sisombulule ingxaki ngokubanzi ethambekele ekwenzekeni, nangona ukwenzeka kwayo kufanelekile umbono ochanekileyo webhlog yethu okanye iwebhusayithi (okanye leyo yenkampani sisebenza kuyo) apho kunokwenzeka ukuba isisombululo sifuneke ngokukhawuleza kangangoko kunokwenzeka.