Tarisa matafura e database yeMySQL uye gadzirisa huori

Ini ndiri mumwe weavo vanofarira kuziva maseva andinogadzirisa, kunyangwe ari akatsiga kwazvo, hazvimbokuvadza kugara uchivatarisa, sekutaura kunoita chirevo:

Ziso ratenzi rinokodza bhiza

Nguva nenguva zvakanaka kuita macheki akati wandei pane server nemasevhisi ayo, mune ino kesi ini ndichataura nezve maitiro ekutarisa matafura e database uye kana imwe ikaora, maitiro ekuigadzirisa.

Tarisa matafura eMySQL DB

Kana chiri chese chinhu (kana chinenge zvese), pane rairo rakareruka rinotibvumidza kutarisa matafura ese mune dhatabhesi reMySQL:

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

Semuenzaniso, ngatiti ndine dhatabhesi inonzi: chirongwa chirevo

Wangu MySQL maneja mushandisi ndeye: mudzi

Uye password yeuyo mushandisi ndeye: misuperpassword

Saka mutsetse unenge uri:

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

Izvo zvaizoratidza chimwe chinhu senge:

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_

Mune mamwe mazwi, matafura ese aripo izvozvi.

Maitiro ekugadzirisa tafura kana ichinge yaita seyakaora?

Ini ndatoita chinyorwa ndichitsanangura izvi zvakadzama: Maitiro Ekugadzirisa Matafura Akamisikidzwa Akaipa kana Akaora muMySQL

Nekudaro, ini ndinosiya matanho apa.

1. Kutanga isu tinofanirwa kupinda muMySQL kuburikidza neterminal:

mysql -u root -p

Izvo zvichatibvunza isu password yemidzi, isu tinoiisa uye tinya [Pinda].

2. Ipapo isu tinofanirwa kuratidza kuti ndeipi dhatabhesi yatinoshandisa, ndiko kuti, inova dhatabhesi iyo ine tafura yakashata. Kutevedzera muenzaniso pakutanga, ngatiti iyo dhatabhesi ndeiyi: chirongwa chirevo

use proyectotesis;

Uye zvino tinozvitaura kugadzirisa tafura yakashata, semuenzaniso ngatiti tafura inonzi: public_information

Unga:

repair table public_information;

Uye voila, izvi zvinofanirwa kukwana kuti zvigadziriswe mune dzakawanda zviitiko.

Ndinovimba zvinobatsira kwauri ... uye kuti hauzombove nematafura akaora 😀