Bincika tebur na bayanan MySQL kuma gyara lalata

Ina ɗaya daga cikin waɗanda suke so in san sabar da nake sarrafawa, kodayake suna da ƙarfi sosai, ba zai taɓa ɓata musu rai ba koyaushe, kamar yadda ake faɗa:

Idon maigida yana kitsar da doki

Lokaci zuwa lokaci yana da kyau ayi bincike da yawa akan sabar da kuma ayyukan ta, a wannan yanayin zanyi magana game da yadda ake duba teburin matattarar bayanai kuma idan mutum ya lalace, yadda za'a gyara shi.

Duba allunan wani MySQL DB

Game da komai (ko kusan komai), akwai umarni mai sauki wanda zai bamu damar bincika dukkan tebur a cikin bayanan MySQL:

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

Misali, a ce ina da rumbun adana bayanai da ake kira: thesis project

Mai amfani da MySQL mai amfani shine: tushen

Kuma kalmar sirrin wannan mai amfani itace: misuperpassword

Don haka layin zai kasance:

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

Zai nuna wani abu kamar:

dfirefoxos.wp_commentmeta OK OK dfirefoxos.wp_comments dfirefoxos.wp_links OK OK dfirefoxos.wp_options dfirefoxos.wp_postmeta OK OK dfirefoxos.wp_posts dfirefoxos.wp_term_relationships OK OK dfirefoxos.wwwp_term_firefox dfirefoxos.wp_termtermsfirefoxfirefox_wp_term_fireosfirefox_wpfoxosponomy_term_postsfirefoxfirefox_term_relationships OK_wpfoxosfirefox_term_relationshipsfirefox OK_wp_term_fireosfirefox_wpfoxospfoxonwp_term_

A wasu kalmomin, duk teburin suna yanzu.

Yadda za a gyara tebur idan ya zama kamar lalata?

Na riga nayi post na bayyana wannan dalla dalla: Yadda Ake Gyara Tebur mai Alamar mara kyau ko rashawa a cikin MySQL

Koyaya, Zan bar matakan anan.

1. Da farko dole ne mu shiga MySQL ta hanyar m:

mysql -u root -p

Zai tambayemu kalmar sirri, sai mu sanya sannan danna [Shigar da].

2. Sannan dole ne mu nuna wane rumbun adana bayanai ne da zamuyi amfani dasu, ma'ana, wacce ita ce rumbun adana bayanai wadanda suke da lalatattun tebur Biyan misali a farkon, a ce mahimman bayanai sune: rubutun aikin

use proyectotesis;

Kowane semicolon yana da matukar muhimmanci; sanya a karshen.

Yanzu kuma muna gaya masa don gyara lalataccen tebur, misali a ce tebur ana kiransa: bayanan jama'a

Za:

repair table public_information;

Kuma voila, wannan ya isa ya gyara shi a mafi yawan lokuta.

Ina fatan yana da amfani a gare ku ... kuma cewa ba ku da tabuka masu lalata 😀


7 comments, bar naka

Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Wanda ke da alhakin bayanan: Miguel Ángel Gatón
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.

  1.   Alberto cardona m

    Barka dai, gudummawa mai kyau, wacce ta gabata don gyara kuskuren kuma 😀

    Tambaya ɗaya, a halin yanzu ina amfani da mariadb, shin kun san ko littafin (jagora) «sql99» yana cikin Spanish?
    o Wasu kyakkyawan jagorar sql99, don sanin cikakken tsarin magana game da DDL tunda ba'a kammalashi a cikin jagorar MariaDB ba.

    gaisuwa

    1.    KZKG ^ Gaara m

      Sannu,

      Babu ra'ayin aboki, ban san wane littafi ba ne, yi haƙuri.

  2.   lokacin3000 m

    Cikakke, saboda haka zan iya gyara kuskuren da bai bani damar amfani da URL ɗin Alias ​​na farko ba wanda WordPress baya bani bayan ƙaura shafin na daga Apache zuwa NGINX.

  3.   koratsuki m

    Hakanan, tare da phpMyAdmin za ku iya, bayan kun shiga, zaɓi maɓallin bayanan, yi alama a kan dukkan teburin kuma aiwatar da zaɓin «Gyara teburin» daga menu mai faɗi ...
    Salu2 kuma ina fatan hakan zai muku hidima 😀

    1.    KZKG ^ Gaara m

      Yayi kyau, ban san waccan ba!

    2.    kari m

      Gyara da Ingantawa .. 😀

      1.    lokacin3000 m

        Hakanan, kodayake a cikin phpmyadmin yana da ikon iya sarrafa shi a ƙarshen umarnin idan har mutum bai saba da IDE sosai ba.