Maitiro ekugadzirisa iyo WordPress dhatabhesi

WordPress yakachinja zvakanyanya kubvira payakatanga mairi maakashanda se blogging chishandiso, uye nhasi iCMS yakazara-yakazara, inoshandiswa nemhando dzese dzemasaiti ane mukurumbira pasi rese sehwaro hwekugadzirisa zvirimo uye zvinyorwa Asi kana paine chimwe chinhu chinonakidza nezve chirongwa ichi chakagadzirwa na Mat mullenwegg uye chii chakaona mwenje kekutanga mugore ra2003 kukwirira kwayo kwepamusoro, uko kunotibvumidza kuti tishandise zvakaenzana ingava sevha yepamba kana webhusaiti yekambani hombe.

Asi zvisinei nehunhu hwayo, WordPress haina kusunungurwa kubva kumatambudziko uye nekudaro zvinogona kuitika kuti dhatabhesi rinotambura nekumwe kukuvara, mukuzara kwaro kana kungori mamwe matafura aro. Chero zvazvingaitika, zvinokwana kudarika zvakakwana kuti blog yedu isagone kutariswa nemazvo, nekuti ndiyo iri mutariri wekuudza CMS kwatinofanira kutsvaga zvinyorwa, mifananidzo nezvimwe zvirimo zvatinoona mune yega post.

Chiratidzo chisingakanganisike cheichi chichava inotevera meseji mune iro danda rekuisa kwedu WordPress. 'WordPress dhatabhesi yekukanganisa Tafura' ./my_home/wp_posts 'inoiswa mucherechedzo seyakagumburwa uye yekupedzisira (otomatiki?) Kugadzirisa kwakundikana kumubvunzo Sarudza post_date_gmt KUBVA pawp_post WHERE post_status =' shambadzira 'NE post_type IN (' post ',' peji ',' chinamatira ') TAURA NE post_date_gmt DESC LIMIT 1 yakaitwa ne inoda (' wp-blog-header.php '), wp, WP-> main, WP-> send_headers, get_lastpostmodified, get_lastpostdate, _get_last_post_time'

Ngatione ipapo kuti tingagadzirisa sei dhatabhesi yakaora mune yedu Kuisirwa WordPress, yatinofanira kuisa iyo Cpanel ye server yedu, iyo sevaya vane yavo domain yakachengetwa mune kumwe kuitisa vanoziva mushe chikamu icho chatinowana iko kugadzirisa kweakasiyana parameter uye ma module ari chikamu chayo.

Ikoko isu tinofanirwa kuenda kuchikamu che Dhatabhesi -> MySQL Dhatabhesi, kwatinofanira kutsvaga sarudzo ye 'Gadzira dhatabhesi', inowanikwa muchikamu che 'Chinja Dhatabhesi'. Kutitungamira zviri nani, chikamu ichi chiri pazasi pechikamu chiri 'Gadzira dhatabhesi nyowani', saka isu tinofanirwa kusarudza dhatabhesi ratiri kuzogadzirisa tobva tinya bhatani 'Gadzira dhatabhesi', mushure meizvozvo isu tinoratidzwa chinzvimbo che database yekuisa kwedu WordPress, uye izvo zvatinofanira kuona kana zvese zvafamba zvakanaka 'Zvakanaka' padyo nezita re tafura yega yega inozvinyora.

Zvino, pamwe panzvimbo pake Cpanel ngative nemidzi yekuwana servidor umo iyo database, zvinova zvinoitika kana tikabata server yedu pachedu kana iri muYunivhesiti kana mukambani. Izvi zvichatibvumidza kuti tishande nenzira iyo isu mutemo linuxers ichave akajaira, uye iri kubva ku Raira mutsara.

Nhanho yekutanga ndeyekumisa sevha MySQL:

$ sudo sevhisi mysql mira

Ipapo isu tinogadzirisa dhatabhesi iyo inotiratidza matambudziko, izvo zvatinoita kuburikidza nemirairo inotevera:

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

Ipapo isu tinongotanga iyo MySQL server zvakare:

$ sudo service mysql kutanga

Maitiro ese ari maviri anotibvumidza kugadzirisa dambudziko iro kazhinji rinowanzoitika riri roga, kunyangwe kuitika kwaro kuchikosha iyo chaiyo visualization yeedu blog kana webhusaiti (kana iyo yekambani yatinoshandira) iyo kana zvikaitika mhinduro inodikanwa nekukurumidza sezvazvinogona.