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;
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 😀
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
Sannu,
Babu ra'ayin aboki, ban san wane littafi ba ne, yi haƙuri.
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.
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 😀
Yayi kyau, ban san waccan ba!
Gyara da Ingantawa .. 😀
Hakanan, kodayake a cikin phpmyadmin yana da ikon iya sarrafa shi a ƙarshen umarnin idan har mutum bai saba da IDE sosai ba.