Jonga iitafile zedatha ye-MySQL kwaye ulungise ukonakala

Ndingomnye wabo bathanda ukwazi iiseva endizilawulayo, nangona zizinzile kakhulu, akukaze kubuhlungu ukuhlala uzijongile, njengoko isitsho le nto:

Iliso lenkosi liyatyebisa ihashe

Ngamaxesha athile kulungile ukwenza iitsheki ezininzi kwiserver kunye neenkonzo zayo, kule meko ndiza kuthetha ngendlela yokujonga iitafile zedatha kwaye ukuba umntu ukhohlakele, ungayilungisa njani.

Jonga iitafile ze-MySQL DB

Yonke into (okanye phantse yonke into), kukho umyalelo olula osivumela ukuba sijonge zonke iitafile kwindawo yedatha ye-MySQL:

mysqlcheck --check BASE_DE_DATOS --user="USUARIO" --password="PASSWORD"

Umzekelo, masithi ndinedathabheyisi ebizwa ngokuba yile: thesis yeprojekthi

Umsebenzisi wam ongumlawuli we-MySQL ngu: root

Kwaye igama eligqithisiweyo lomsebenzisi ngu: misuperpassword

Ke umgca uya kuba:

mysqlcheck --check proyectotesis --user="root" --password="misuperpassword"

Ingabonisa into efana nale:

dfirefoxos.wp_commentmeta Kulungile dfirefoxos.wp_comments dfirefoxos.wp_links Kulungile dfirefoxos.wp_options Kulungile dfirefoxos.wp_postmeta OK Kulungile dfirefoxos.wp_posts OK dfirefoxos.wp_term_relationships OK dfirefoxos.wp_term_firesfoxfirefox Kulungile dfirefoxononomy_termtermsfirefox OK_wp_term_fireosfirefoxonwpfoxosponomy_term_postsfirefox_wp_term_relationshipsfirefox_wp_termfireosfirefox_wpfoxospfoxonwp_term_relationshipsfirefox_term_relationships OK_wpfoxosfirefox_term_wposfirefox_wp_term_

Ngamanye amagama, zonke iitafile zilungile ngoku.

Uyilungisa njani itafile ukuba inokubonakala ngathi yonakele?

Sele ndenze isithuba esichaza ngokweenkcukacha: Ungazilungisa njani iitafile ezimakwe kakubi okanye zonakele kwi-MySQL

Nangona kunjalo, ndiza kushiya amanyathelo apha.

1. Kuqala kufuneka singenise i-MySQL kwisiphelo sendlela:

mysql -u root -p

Izakusicela iphasiwedi yengcambu, siyibeka kwaye ucinezele u-Enter.

2. Emva koko kufuneka sibonise ukuba loluphi ugcino-lwazi esiza kulusebenzisa, oko kukuthi, esisiseko sedatha esinetafile eyonakeleyo. Ukulandela umzekelo ekuqaleni, masithi isiseko sedatha si: iprojekthi thesis

use proyectotesis;

Kwaye ngoku siyixelela ukuba ilungise itafile eyonakeleyo, umzekelo masithi itheyibhile ibizwa ngokuba: luluntu_ulwazi

Ngaba:

repair table public_information;

Kwaye i-voila, oku kuya kuba ngokwaneleyo ukuyilungisa kwiimeko ezininzi.

Ndiyathemba ukuba iluncedo kuwe ... kwaye awusoze ube neetafile ezonakeleyo 😀