Thaum ntau cov ntawv thov network siv ib qho chaw khaws ntaub ntawv, txij ua ke mus ua ke nws yuav tsim nyog los txiav tawm tas nrho los yog ib nrab ntawm cov ntxhuav ntawm cov ntaub ntawv no lossis tsuas yog lawv cov ntsiab lus xwb. Txoj hauv kev yooj yim tshaj plaws los ua qhov no yog siv daim ntawv thov phpMyAdmin, uas tso cai rau koj los ua cov haujlwm tsim nyog ncaj qha rau hauv browser siv qhov sib cuam tshuam.
Tsim nyog
PhpMyAdmin nkag tau
Cov Lus Qhia
Kauj ruam 1
Rub phpMyAdmin, sau koj tus ID nkag mus thiab tus password hauv daim ntawv tso cai thiab xaiv cov ntaub ntawv khaws cia kom huv hauv kab laug sab ntawm lub interface.
Kauj ruam 2
Nyem rau "Kos Txhua Qhov" txuas rau hauv qab daim ntawv teev cov ntxhuav hauv txoj cai ntawm daim ntawv thov interface yog tias koj xav rho tawm txhua yam ntawm cov ntaub ntawv no.
Kauj ruam 3
Xaiv kab "Rho tawm" hauv kab ntawv nco "Teev" Nrog cim ". Tom qab ntawd, tsis tas nias lub khawm ntxiv, daim ntawv thov yuav sau cov lus nug hauv SQL thiab nug koj kom paub meej tias nws tua - nyem "Yes". Daim ntawv thov yuav xa, cov ntxhuav thiab lawv cov ntsiab lus yuav raug muab lwv, thiab lub rooj ntawm qhov txiaj ntsig ntawm qhov kev nug SQL yuav raug ntsaws rau hauv txoj cai tsim ntawm lub interface.
Kauj ruam 4
Yog tias koj xav tshem tawm cov ntsiab lus ntawm txhua cov kab ntawv hauv cov ntaub ntawv no, tom qab ntawd, tom qab nyem rau ntawm "Xyuas tag nrho" txuas, xaiv cov lus "Clear" hauv daim ntawv teev cia. Qhov kev thov no tseem yuav raug xa mus sai thiab koj yuav raug hais kom paub tseeb tias TRUNCATE cov lus txib tau ua rau txhua lub rooj. Nyem "Yog" thiab cov lus nug SQL yuav raug tua thiab daim ntawv qhia uas nthuav tawm ntawm nplooj ntawv no.
Kauj ruam 5
Yog tias koj xav tau txheeb cov ntxhuav cov ntaub ntawv los ntawm "cov khib nyiab" ntau ntau (cov ntaub ntawv pabcuam tsis siv thiab cov ntaub ntawv tsis raug), tom qab ntawv nyem "Cim cov xav tau kev ua haujlwm zoo" txuas. Lub sijhawm no, nyob rau hauv daim ntawv teev cia hauv qab, koj yuav tsum xaiv cov lus "Optimize Table". Thov nco tseg: qhov txuas "Cim xav tau kev ua kom tiav" yuav muaj nyob rau hauv lub interface tsuas yog daim ntawv thov tuaj yeem pom cov rooj uas xav tau kev ua kom zoo.
Kauj Ruam 6
Koj yuav tsum ua zoo ib yam yog tias koj xav tau los rov qab cov ntaub ntawv puas. Tom qab xaiv tag nrho cov ntxhuav, xaiv kab "Restore lub rooj" kab hauv kab lus nco.
