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.
Ngethemba ukuthi iwusizo kuwena... nokuthi awulokothi ube namatafula akhohlakele 