Manage WordPress zvirevo neMySQL mirairo

Ago imwe nguva yapfuura ndakakuratidza maitiro ekugadzirisa WordPress saiti nemirairo, zvaive kuburikidza nechinyorwa pera. Mune ino kesi ini ndinokuratidza chaizvo maitiro ekugadzirisa WordPress zvirevo kuburikidza neSQL mibvunzo, ndokuti, kuburikidza nemirairo mune MySQL koni.

Chinhu chekutanga kuchengeta mundangariro ndechekuti ivo vanofanirwa kuve nekuwana kune iyo MySQL terminal kana koni, tifunge isu tinowana iyo server neSSH uye mukati mayo tinonyora:

mysql -u root -p

Kana izvi zvangonyorwa uye kudzvanywa pinda ichavabvunza ivo password yemushandisi weMySQL, vanoinyora, vodhinda zvakare pinda uye voila, vanenge vatowana:

Kana tangopinda mukati meMySQL shell isu tinofanirwa kuratidza kuti ndeipi dhatabhesi yatiri kuzoshandisa, unogona kuona dhatabhesi iripo ne:

ratidza dhatabhesi;

Izvi zvinokuratidza sekutaura kwandakaita dhatabhesi dziripo, ngatiti iyo yaunoda inonzi sitewordpress, ngatishandisei:

shandisa wordpress saiti;

Ngatitarisei kuti matafura anonzi chii:

ratidza matafura;

Izvi zvichatiudza mazita ematafura, akakosha zvakanyanya nekuti isu tinofanirwa kuona kuti chii chaizvo zita reti tafura inoenderana nezvakataurwa iri: makomendi

Inowanzoidaidzwa kuti wp_comments kana zvimwewo, chakakosha ndechekuti inogara ichiperera mu: makomenti

Delete SPAM zvirevo

Nemutsara uyu zvese zvakataurwa seSAMP zvichabviswa:

Bvisa kubva wp_comments APO comment_approved = 'spam';

Delete ese makomendi akamirira kuenzanisa

BVIRA Kubva wp_comments PANO comment_approved = '0';

Tsiva zvinyorwa mune zvese zvakataurwa

Ngatitii isu tinoda kutsvaga zvese zvakataurwa nezwi rekuti "zvematongerwo enyika" uye kuritsiva ne "rakaora", zvingave

ZVIMWE wp_comments SET `comment_content` = REPLACE (` comment_content`, 'politicos', 'corruptionos');

Delete makomendi anoenderana neayo saiti yemunyori URL

Ngatitii nekuda kwechimwe chikonzero isu tinoda kubvisa zvese zvakataurwa nechero mushandisi uyo, kana achitaura, akatsanangura mune yemafomu fomu data (zita, saiti uye email) kuti saiti yake yaive http://taringa.com (kupa muenzaniso) , zvaizove sezvizvi:

DZOSA kubva kune wp_comments KUMASHURE ekutaura_author_url SENGO 'http://taringa.com';

Vhara zvirevo pazvinyorwa zvekare

Ndinoziva nezve vanhu vanoda kuvhara zvirevo pane zvekare zvinyorwa pane yavo saiti, saka ivo vanofanirwa kugadzirisa iwo ega ega zvinyorwa kuti vadzivise iyo "makomendi akagoneswa" sarudzo mune yega yega, iyi tambo ichagadzirisa hupenyu hwavo:

UPDATE wp_posts SET comment_status = 'yakavharwa' PANO post_date <'2010-02-10' Uye post_status = 'shambadza';

Sezvauri kuona, pakati pemutsara iri zuva, 2010-02-10, izvi zvinoreva kuti zvese zvinyorwa zvakaburitswa uye zvine zuva rekuburitsa rakaderera pane Kukadzi 10, 2010 (ndokuti, zvakatsikiswa pamberi ) ichavhara zvirevo, hapana munhu achazokwanisa kutaura pamusoro pazvo zvekare.

Vhara zvirevo pazvinyorwa zvese

Kana iwe usiri kuda kuvhara makomendi chete mune zvimwe zvinyorwa asi mune zvese, iyi tambo ichakubatsira iwe:

ZVIMWE wp_posts SET comment_status = 'yakavharwa', ping_status = 'yakavharwa' PANO comment_status = 'kuvhura';

Kana iwe uchida kudzosera izvi, chinja yakavharwa kuti uvhure uye zvinopesana, uye voila, ita zvekare mutsara pamwe neshanduko.

Delete makomenti akaitwa mune imwe nguva renji

Ngatitii tinoda kudzima zvese zvakataurwa musi waApril 1, 2014, pakati pa4: 15 masikati na10: 40 husiku, mutsetse unenge uri:

Bvisa kubva wp_comments PAPI comment_date> '2014-04-01 16:15:00' UYE wongorore_date <= '2014-04-01 22:40:00';

Sezvauri kuona, iyo nguva iri mumaawa makumi maviri nemana, ndiko kuti, nguva yechiuto.

Magumo!

Zvakanaka, hapana chimwezve chekuwedzera, ndinoziva kuti anopfuura mumwe chete anozowana izvi zvinonakidza.

Reply with quote