Yadda Ake Gyara Tebur mai Alamar mara kyau ko rashawa a cikin MySQL

Fiye da shekara guda munyi amfani da plugin na Counterizer don WordPress kuma don haka adana ƙididdigar blog da masu karanta ta, wannan kayan aikin mun kashe a aan kwanakin da suka gabata tunda (a tsakanin sauran abubuwa) ya adana sama da 600MBs na bayanai a cikin bayanan.

Ya faru cewa (kafin kashe kayan aikin da tsabtace DB) Na yi ƙoƙarin yin jujjuya bayanai, ma'ana, fitarwa zuwa .SQL kuma ta haka ne zazzage shi kuma kuskuren mai zuwa ya bayyana a cikin tashar karɓar:

mysqldump: Samu kuskure: 144: Tebur './dl_database/Counterize_Referers' an yi alama a matsayin mai lalacewa kuma gyarawa ta ƙarshe (ta atomatik?) ta gaza yayin amfani da TATTALIN LOCK

Por lo que, el dump no se efectuaba y bueno… la solo idea de pensar que la DB de DesdeLinux tenía algún problema me puso los pelos de punta 🙂

Yin ɗan bincike kan yanar gizo Na sami damar koyon yadda za a magance wannan matsalar, ga alama ba BA cewa tushen bayanan yana da matsala daidai, kawai ana nuna tebur a matsayin 'tare da matsaloli', abin farin ciki wannan yana da sauƙin gyarawa.

Da farko bari mu shiga sabar MySQL:

mysql -u root -p

Mun latsa [Enter] zai tambaye mu kalmar sirri ta MySQL, sai mu sa ta kuma sake danna [Enter].

Da zarar mun shiga MySQL zamu fada muku wane rumbun adana bayanan da zakuyi amfani dasu, misali matsalar bisa ga kuskuren da ke sama tana cikin tebur Counterize_Referers daga bayanan  dl_bayanai, don haka:

use database dl_database;

Kuma yanzu don gyara tushen tebur:

repair table Counterize_Referers;

Da zarar an zartar da umarnin da ya gabata, tabbas komai ya koma yadda yake, aƙalla a wurina lamarin ya kasance haka fiye da sau ɗaya 😉

Bayan haka ne kawai ya rage don sake yin umurni don zubar da bayanan da voila, babu komai.

Koyaya, Ina yin wannan fiye da komai azaman abin tunawa a wurina, saboda abu ɗaya ya faru dani sau biyu kuma bana son manta umarnin da aka tanada don ajiye ranar 😀

Gaisuwa da fatan zai taimaki wani.