Bheka Amathebula Esizinda sedatha ye-MySQL nokulungisa Konakele

Ngingomunye walabo abathanda ukwazi amaseva engiwaphetheyo, yize ezinzile kakhulu, akukaze kube buhlungu ukuhlala ubabhekile, njengoba isisho sithi:

Iso lenkosi likhuluphele ihhashi

Ngezikhathi ezithile kuhle ukwenza amasheke amaningi kuseva nezinsizakalo zayo, kulokhu ngizokhuluma ngokuthi ungabheka kanjani amatafula e-database futhi uma kwenzeka eyodwa yonakele, ukuthi ungayilungisa kanjani.

Bheka amatafula we-MySQL DB

Ngokuqondene nayo yonke into (noma cishe yonke into), kukhona umyalo olula ovumela ukuthi sihlole wonke amatafula ku-database ye-MySQL:

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

Isibonelo, ake ngibe ne-database ebizwa ngokuthi: iphrojekthi thesis

Umsebenzisi wami ongumqondisi we-MySQL ngu: root

Futhi iphasiwedi yalowo msebenzisi ithi: misuperpassword

Ngakho-ke umugqa uzoba:

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

Kungakhombisa okuthile okufana nalokhu:

dfirefoxos.wp_commentmeta Kulungile dfirefoxos.wp_comments dfirefoxos.wp_links Kulungile Kulungile dfirefoxos.wp_options Kulungile dfirefoxos.wp_postmeta Kulungile dfirefoxos.wp_posts dfirefoxos.wp_term_relationships Kulungile Kulungile dfirefoxos.wp_termtermsfirefox Kulungile dfirefoxos.wp_term_term_firefoxfirefox_wp_termfireosfirefoxonwpfoxosponomy_term_postsfirefox_wp_term_relationshipsfirefox_wpfoxospfoxonwp_term_relationshipsfirefox OK_wp_term_fireosfirefoxonwpfoxospfoxonwp_term_relationshipsfirefox_wp_term_relationshipsfirefox OK_wp_term_fireosfirefox_wpfoxospfoxfire

Ngamanye amagama, wonke amatafula akhona njengamanje.

Ungalilungisa kanjani itafula uma kungenzeka libonakale lonakele?

Sengivele ngibhale okuchaza ngokuningiliziwe lokhu: Ungawalungisa Kanjani Amatafula Amakwe Okubi noma Okhohlakele ku-MySQL

Kodwa-ke, ngizoshiya izinyathelo lapha.

1. Okokuqala kufanele singene nge-MySQL ngokusebenzisa i-terminal:

mysql -u root -p

Izosibuza iphasiwedi yezimpande, siyibeke bese sicindezela u- [Enter].

2. Ngemuva kwalokho kufanele sikhombise ukuthi iyiphi i-database esizoyisebenzisa, okungukuthi, okuyi-database enetafula elonakele. Ukulandela isibonelo ekuqaleni, ake sithi i-database ithi: project thesis

use proyectotesis;

Futhi manje siyitshela ukuthi ilungise itafula elonakele, ngokwesibonelo ake sithi itafula libizwa: public_information

Ngabe:

repair table public_information;

Futhi i-voila, lokhu kufanele kube ngokwanele ukuyilungisa ezimweni eziningi.

Ngiyethemba kuzoba wusizo kuwe ... nokuthi awusoze waba namatafula akhohlakele 😀