Ungawalungisa Kanjani Amatafula Amakwe Okubi noma Okhohlakele ku-MySQL

Alejandro (a.k.a KZKG^Gaara)

Imizuzu ye-2

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

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 🙂

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 —– »  ;

Lapho nje umyalo wangaphambilini usufeziwe, konke kufanele ukuthi kubuyele kokujwayelekile, okungenani kimi bekunjalo kaningi kwesinye isikhathi 😉

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

Noma kunjalo, lokhu ngikwenza ngaphezu kwanoma yini enye njengememorandamu kimi, ngoba kwenzeke into efanayo nakimi kabili futhi angifuni ukukhohlwa imiyalo yokugcina usuku 😀

Ngiyabingelela futhi ngiyethemba ukuthi iyasiza komunye umuntu.


Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.

  1.   Leo kusho
    kwenza iminyaka 11

    Kuhle kakhulu, ngaso sonke isikhathi kufanele ube nalolu hlobo lwento esandleni nganoma yisiphi isizathu.

    Phendula uLeo
    1.    KZKG ^ Gaara kusho
      kwenza iminyaka 11

      Siyabonga 🙂
      Yebo… okwamanje lapho kwenzeka inkinga, kuhle ukuba nesixazululo esiseduze, noma okungenani ukwazi ukuthi ungayithola kuphi ngaphandle kokulibala.

      Phendula ku-KZKG ^ Gaara
  2.   eliotime3000 kusho
    kwenza iminyaka 11

    I-KZKGGaara enhle. Kunezinto i-PHPMyAdmin engenakuzenza ezingenziwa yikhonsoli.

    Phendula ku-eliotime3000
    1.    KZKG ^ Gaara kusho
      kwenza iminyaka 11

      Siyabonga 🙂

      Phendula ku-KZKG ^ Gaara
  3.   Santiago kusho
    kwenza iminyaka 11

    Kuhle, kungisindise ngaphezu kokukodwa.

    Kepha ngiyazibuza, bekungeke kube yi-mysql -u impande -p esikhundleni sempande -u impande -p? Angiqondile ukona.

    Siyabonga!

    Phendula uSantiago
  4.   Santiago kusho
    kwenza iminyaka 11

    Kuhle, kungisindise ngaphezu kokukodwa.
    Kepha ngiyazibuza, bekungeke kube yi-mysql -u impande -p esikhundleni sempande -u impande -p? Ngibuza ngaphandle kwenhloso yokona.
    Gracias

    Phendula uSantiago
    1.    KZKG ^ Gaara kusho
      kwenza iminyaka 11

      LOL !!!! Iqiniso ngokuphelele, iphutha lami LOL!
      Bengibhala futhi ngicabanga igxathu eliya phambili, ukusuka lapho ukubhala izimpande esikhundleni se-mysql ... Ngiyabonga ngesexwayiso 🙂

      Phendula ku-KZKG ^ Gaara
      1.    Santiago kusho
        kwenza iminyaka 11

        Wamukelekile! Uxolo ngokuthunyelwe okuphindwe kabili; Ngizamile ukuyithumela ngiphindelela yangitshela ukuthi isivele ikhona (ngilayishe kabusha ikhasi futhi angibonanga lutho).
        Ukubingelela

        Phendula uSantiago
  5.   Leper_Ivan kusho
    kwenza iminyaka 11

    Lokhu kuphuma ezinweleni zami njengoba sengingena enkingeni ye-DB.

    Phendula uLeproso_Ivan
  6.   alejandro kusho
    kwenza iminyaka 11

    Sawubona,

    Umbuzo owodwa, ulahla kangaki i-DB? ukwazi ukuthi kuthatha isikhathi esingakanani ukuthola imininingwane engama-600MB

    Ukulawula,

    Phendula ku-alejandro
    1.    KZKG ^ Gaara kusho
      kwenza iminyaka 11

      Ehm… angikuzwisisi kahle manje 🙂
      Antes de que hiciéramos una limpieza en la DB de DesdeLinux esta (o sea, el .sql de la DB) pesaba más de 700MB, porque guardábamos en la DB todas las estadísticas. O sea, desde casi el inicio del blog.

      Manje sisebenzisa iGoogle A. ngakho-ke sisusa amatafula ezibalo kwi-DB, futhi manje i-.sql ayifinyeleli ku-80MB

      Ingabe lokhu kuyawuphendula umbuzo wakho?

      Phendula ku-KZKG ^ Gaara
  7.   alejandro kusho
    kwenza iminyaka 11

    Sawubona,

    Ngaphandle kwe-troll, ulahla kangaki i-DB?

    Phendula ku-alejandro
    1.    KZKG ^ Gaara kusho
      kwenza iminyaka 11

      Izikhathi eziningana ngenyanga 🙂
      Intento siempre tener en mi localhost la última versión de DesdeLinux

      Phendula ku-KZKG ^ Gaara
  8.   uthanda ukuyithenga !! kusho
    kwenza iminyaka 9

    Kubukeka kulungile kimi, manje akunakwenzeka ukwenza ukubuyekeza okujwayelekile kwamatafula onakele?

    Phendula kuwe uthanda ukuwuthenga !!
  9.   Victoria kusho
    kwenza iminyaka 8

    Ngiyabonga kakhulu mngani, umnikelo wakho ungisize kakhulu.
    Phendula ngokucaphuna

    Phendula uVictoria
  10.   UJuan Mollega kusho
    kwenza iminyaka 8

    Ngiyabonga kakhulu othandekayo, ngiyabonga ngamathiphu, angisizile !!
    Ukubingelela okuvela eTrujillo-Venezuela.

    Phendula uJuan Mollega
  11.   Hernan Barra kusho
    kwenza iminyaka 8

    kulinganiselwa
    Njengoba ngazi ukuthi inqubo iyaqhubeka ngabhala ukungeniswa kwetafula lokulungisa umyalo; futhi ngilapho

    Phendula u-hernan barra
  12.   U-Andre Cruz kusho
    kwenza iminyaka 8

    Ngiyabonga kakhulu, ungisindisile isikhumba sami 😀

    Phendula u-Andre Cruz
  13.   Marco kusho
    kwenza iminyaka 7

    Sawubona mngani, angazi noma ungangisiza yini, kwenzeke into efanayo ngewebhusayithi yami, maka leli phutha:
    Ithebula le-wp_posts alilungile. Bika iphutha elilandelayo: Ithebula limakwe njengokuphahlazeka nokulungiswa kokugcina kuhlulekile. I-WordPress izozama ukulungisa leli thebula ...
    Yehlulekile ukulungisa ithebula le-wp_posts. Iphutha: Ithebula limakwe njengokuphahlazeka nokulungiswa kokugcina kuhlulekile

    Angazi noma ungangisiza ngiyilungise, ngintsha ku-WordPress esezingeni eliphakeme. Lapho uzama ukulungisa itafula le-wp-, likhombisa iphutha lokuthi alikwazi ukulungiswa. Ngiyabonga. Iwebhusayithi yami ithi: https://diarionoticiasweb.com

    Phendula uMarco