Ungayilungisa kanjani i-WordPress database

WordPress iguquke kakhulu selokhu yaqala lapho yayisebenza khona ithuluzi lokubhuloga, futhi namuhla iyi-CMS egcwele, esetshenziswa yizo zonke izinhlobo zamasayithi ahlonishwa kakhulu emhlabeni wonke njengesisekelo sokuphatha okuqukethwe nezincwadi. Kepha uma kukhona okuthile okuthokozisayo ngale phrojekthi eyenziwe ngu Mat mullenwegg futhi okubonile ukukhanya okokuqala ngo-2003 ukukwazi ukuphakama okukhulu, okusivumela ukuthi sikusebenzise ngokulinganayo noma ngabe iseva yasekhaya noma iwebhusayithi yenkampani enkulu.

Kepha ngaphandle kwekhwalithi yayo, i-WordPress ayikhishwa ezinkingeni ngakho-ke kungenzeka ukuthi i-database ibhekane nomonakalo othile, ngokuphelele noma amanye amatafula ayo. Kunoma ikuphi, kuzokwanela ngokwanele ukuze ibhulogi yethu ingakwazi ukubukwa kahle, ngoba yiyo ephethe ukutshela i-CMS ukuthi kufanele ibheke kuphi imibhalo, izithombe nokunye okuqukethwe esikubonayo kokuthunyelwe ngakunye.

Isimpawu esingaqondakali salokhu kuzoba umlayezo olandelayo ku-log yokufakwa kwethu kwe-WordPress: 'Ithebula lephutha ledatha ye-WordPress' ./my_home/wp_posts 'limakwe njengokuphahlazeka nokugcina (okuzenzakalelayo?) Ukulungiswa kwehlulekile embuzweni KHETHA post_date_gmt KUSUKELA ku-wp_posts LAPHO post_status =' shicilela 'FUTHI post_type IN (' post ',' page ',' attachment ') Oda nge-post_date_gmt DESC LIMIT 1 eyenziwe nge-require (' wp-blog-header.php '), wp, WP-> main, WP-> send_headers, get_lastpostmodified, get_lastpostdate, _get_last_post_time'

Ake sibone-ke ukuthi singalungisa kanjani i-database eyonakele ku- Ukufakwa kwe-WordPress, okumele singene kuyo i-Cpanel yeseva yethu, okuthi njengoba labo abanezizinda zabo ezigcinwe kokunye ukusingathwa bazi kahle ukuthi yingxenye lapho sifinyelela khona ukucushwa kwamapharamitha ahlukile namamojula ayingxenye yawo.

Lapho kufanele siye esigabeni se- Imininingwane -> Imininingwane ye-MySQL, lapho kufanele sibheke khona inketho ye 'Lungisa i-database', etholakala engxenyeni ye 'Shintsha imininingwane'. Ukuze usiqondise kangcono, lesi sigaba sitholakala ngaphansi kwesigaba esikuso 'Dala i-database entsha', ngakho-ke kufanele sikhethe i-database esizoyilungisa bese sichofoza inkinobho 'Lungisa i-database', ngemuva kwalokho sizokhonjiswa isimo sedatha yokufakwa kweWordPress yethu, futhi okufanele sikubone uma konke kuhambe kahle 'KULUNGILE' eceleni kwegama lethebula ngalinye eliyibhalayo.

Manje mhlawumbe esikhundleni sakhe cPanel masibe nokufinyelela kwezimpande ku- iseva lapho i- database, okuzokwenzeka uma sisingatha i-server yethu noma uma itholakala eNyuvesi noma enkampanini. Lokhu kuzosivumela ukuthi sisebenze ngendlela yokuthi ama-linuxer wezomthetho azojwayelwa kakhulu, futhi kuvela ku Umugqa womyalo.

Isinyathelo sokuqala ukumisa iseva MySQL:

$ sudo service mysql yima

Ngemuva kwalokho silungisa i-database esikhombisa izinkinga, esizenza ngomyalo olandelayo:

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

Ngemuva kwalokho simane siqale iseva ye-MySQL futhi:

$ sudo service mysql qala

Zombili lezi zindlela zizosivumela ukuthi sixazulule inkinga ejwayele ukwenzeka yodwa, yize ukwenzeka kwayo kungumnqamulajuqu ukubona kahle ibhulogi yethu noma iwebhusayithi (noma leyo yenkampani esisebenza kuyo) uma kwenzeka kwenzeka isixazululo siyadingeka ngokushesha okukhulu.