Lelee MySQL ọdụ data tebụl na Mmezi Nrụrụ Aka

Abụ m otu n'ime ndị na-enwe mmasị ịmara sava ndị m na-ejikwa, ọ bụ ezie na ha kwụsiri ike, ọ naghị afụ ụfụ ilegide ha anya mgbe niile, dịka okwu a na-ekwu:

Anya nke nna ukwu ahụ na-eme ka ịnyịnya gbaa ịnyịnya

Site n'oge ruo n'oge ọ dị mma ịme ọtụtụ nyocha na ihe nkesa na ọrụ ya, na nke a, m ga-ekwu maka otu esi elele tebụl nke nchekwa data ma ọ bụrụ na mmadụ rụrụ arụ, otu esi edozi ya.

Lelee tebụl nke MySQL DB

Banyere ihe niile (ma ọ bụ ihe niile), enwere iwu dị mfe nke na-enye anyị ohere ịlele tebụl niile na nchekwa data MySQL:

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

Iji maa atụ, were ya na m nwere nchekwa data a na-akpọ: project thesis

Onye nchịkwa MySQL m bụ: mgbọrọgwụ

Na okwuntughe nke onye ọrụ ahụ bụ: misuperpassword

Ya mere, akara ga-abụ:

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

Ọ ga-egosi ihe dịka:

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

N’ikwu ya n’ụzọ ọzọ, tebụl niile dị ugbu a.

Kedu otu esi edozi tebụl ma ọ bụrụ na ọ dị ka nrụrụ aka?

Emegoro m post na-akọwa nke a n'ụzọ zuru ezu: Esi rụkwaa tebụl akara ma ọ bụ nrụrụ aka na MySQL

Agbanyeghị, m ga-ahapụ usoro ndị a.

1. Mbụ anyị ga-abanye MySQL site na ọnụ:

mysql -u root -p

Ọ ga-ajụ anyị maka paswọọdụ mgbọrọgwụ, anyị tinye ya wee pịa [Tinye].

2. Mgbe ahụ, anyị ga-egosi ebe nchekwa data anyị ga-eji, ya bụ, nke bụ nchekwa data nwere tebụl rụrụ arụ. Gbaso ihe atụ na mbido, ka anyị kwuo na nchekwa data bụ: tesis project

use proyectotesis;

Semicolon ọ bụla dị ezigbo mkpa; tinye na njedebe.

Ma ugbu a, anyị na-agwa ya ka ọ rụzie tebụl rụrụ arụ, dịka ọmụmaatụ ka anyị kwuo na a na-akpọ tebụl: public_information

Ga:

repair table public_information;

Na voila, nke a kwesịrị ezu iji rụkwaa ya n'ọtụtụ ọnọdụ.

Echere m na ọ baara gị uru ... na ị nweghị tebụl rụrụ arụ 😀


Ọdịnaya nke isiokwu agbaso ụkpụrụ anyị nke ụkpụrụ nduzi. Kpesa mmejọ pịa ebe a.

Ihe 7 kwuru, hapụ nke gị

Hapu okwu gi

Adreesị email gị agaghị bipụtara. Chọrọ ubi na-akara na *

*

*

  1. Rụ ọrụ maka data: Miguel Ángel Gatón
  2. Nzube nke data: Nchịkwa SPAM, njikwa okwu.
  3. Ikike: Nkwenye gị
  4. Nkwurịta okwu nke data: Agaghị agwa ndị ọzọ data ahụ ma ọ bụghị site na iwu.
  5. Nchekwa data: Ebe nchekwa data nke Occentus Networks (EU) kwadoro
  6. Ikike: Oge obula inwere ike igbachi, weghachite ma hichapụ ihe omuma gi.

  1.   Alberto cardona dijo

    Ndewo, onyinye dị oke mma, nke gara aga iji dozie njehie 😀

    Otu ajụjụ, ana m eji mariadb ugbu a, ị maara ma ọ bụrụ na akwụkwọ (ndu) «sql99» dị na Spanish?
    o guidefọdụ ezigbo nduzi sql99, iji mata njikọ zuru ezu gbasara DDL ebe ọ bụ na usoro MariaDB ezughị ezu.

    Nzaghachi na see okwu

    1.    KZKG ^ Gaara dijo

      hello,

      Enweghị echiche ọ bụla, amaghị m akwụkwọ ọ bụ, ndo.

  2.   Ogechukwu3000 dijo

    Zuru oke, ya mere enwere m ike imezi njehie nke na-anaghị ekwe ka m tinye URL aha nke mbụ na WordPress anaghị enye m mgbe m kwagara saịtị m site na Apache ruo NGINX.

  3.   Koratsuki dijo

    Ọzọkwa, site na phpMyAdmin ị nwere ike, mgbe ị banyere, họrọ nchekwa data, kaa tebụl niile ahụ akara ma mepụta nhọrọ «Mmezi tebụl» site na menu ndọpụta ...
    Salu2 na echere m na o ga abara gi uru 😀

    1.    KZKG ^ Gaara dijo

      Ọ dị mma, amaghị m nke ahụ!

    2.    elav dijo

      Mmezi na-ebuli .. 😀

      1.    Ogechukwu3000 dijo

        Otu ihe ahụ, ọ bụ ezie na na phpmyadmin ọ nwere ikike ijikwa ya na njedebe nke iwu ọ bụrụ na mmadụ anaghị eji IDE eme ihe.