Ungawalungisa Kanjani Amatafula Amakwe Okubi noma Okhohlakele ku-MySQL

Isikhathi esingaphezu konyaka sisebenzise i-plugin ye-Counterizer ye-WordPress futhi ngaleyo ndlela sigcina izibalo zebhulogi kanye nabafundi bayo, le-plugin ivaliwe ezinsukwini ezimbalwa ezedlule njengoba (phakathi kwezinye izinto) igcine idatha engaphezulu kwama-600MB ku-database.

Kwenzeka ukuthi (ngaphambi kokucima i-plugin nokuhlanza i-DB) ngazama ukulahla i-database, okusho ukuthi, ukuyithumela ku-.SQL futhi ngaleyo ndlela ngiyilande futhi endaweni yokugcina yokusingatha ngithole iphutha elilandelayo:

i-mysqldump: Unephutha: 144: Ithebula './dl_database/Counterize_Referer' limakwe njengokuphahlazeka futhi ukulungiswa kokugcina (okuzenzakalelayo?) kwehlulekile lapho kusetshenziswa i-LOCK TABLES

Ngakho-ke, ukulahlwa akuzange kwenziwe futhi kahle... umqondo nje wokucabanga ukuthi i-DesdeLinux DB yayinenkinga yenza izinwele zami zaphela 

Ukwenza ucwaningo oluncane kuwebhu ngikwazile ukufunda ukuxazulula le nkinga, ngokusobala AKUKHO ukuthi i-database inezinkinga ncamashi, nje ukuthi itafula limakwe ngokuthi 'linezinkinga', ngenhlanhla lokhu kulula ukukulungisa.

Okokuqala ake sifinyelele kuseva ye-MySQL:

mysql -u root -p

Sicindezela u- [Enter] futhi izosicela iphasiwedi yempande ye-MySQL, siyibeka bese sicindezela u- [Enter] futhi.

Lo myalo kungenzeka uma ngabe iseva ye-MySQL ifakwa kukhompyutha efanayo, uma ufuna ukuxhuma ukude kwenye iseva ye-MySQL kufanele ungeze okulandelayo kulayini: -h IP-YOKUSEBENZA

Uma usungaphakathi kwe-MySQL sizokutshela ukuthi iyiphi i-database ongayisebenzisa, ngokwesibonelo inkinga ngokusho kwephutha elingenhla isetafuleni Counterize_Referers kusuka ku-database  dl_database, ukuze:

use database dl_database;

Manje ukulungisa isisekelo setafula:

repair table Counterize_Referers;

Qaphela ukuthi ekugcineni kwale migqa kune semicolon —– »  ;

Uma umyalo odlule usukhishiwe, yonke into kufanele ngabe ibuyele kokujwayelekile, okungenani esimweni sami kube kanje izikhathi ezingaphezu kwesisodwa 

Ngemuva kwalokho kuhlala kuphela ukwenza kabusha imiyalo yokulahla i-database ne-voila, akukho okunye.

Noma kunjalo, lokhu ngikwenza ngaphezu kwanoma yini enye njengememorandamu kimina, njengoba into efanayo isivele yenzeke kabili kimi futhi angifuni ukukhohlwa imiyalelo yokulondoloza usuku 

Ngiyabingelela futhi ngiyethemba ukuthi iyasiza komunye umuntu.


Engeza njengomthombo okhethwayo