Txoj kev yooj yim tshaj plaws los xa tawm MySQL database rau ib daim ntawv xa yog siv cov ntawv thov phpMyAdmin. Nws muab rau kev nkag siab yooj yim rau kev tswj hwm databases ncaj qha hauv lub qhov rai browser. Daim ntawv thov no yog ntsia los ntawm feem coob ntawm cov muab kev pabcuam hosting, thiab yog tias tsim nyog, kev xa tawm tshiab tuaj yeem rub tawm dawb los ntawm lub chaw tsim khoom lub vev xaib.
Tsim nyog
PhpMyAdmin ntawv nkag
Cov Lus Qhia
Kauj ruam 1
Ntsaws qhov phpMyAdmin interface nkag rau hauv lub browser window, nkag mus thiab xaiv ib qho uas koj xav tau los tawm ntawm daim ntawv teev npe ntawm cov databases hauv kab ntawv sab laug.
Kauj ruam 2
Nyob rau sab qaum kev thav duab sab xis ntawm nplooj ntawv ntawm cov chaw xaiv, muaj cov ntawv qhia zaub mov nrog kev txuas mus rau ntau pawg ntawm cov haujlwm. Nyem rau "Export" txuas rau hauv nws.
Kauj ruam 3
Nyem rau Xaiv Txhua qhov txuas hauv ntu Export ntawm nplooj ntawv Xaiv Kev Xaiv chaw. Yog tias koj xav tau xa tawm tsis yog tag nrho cov ntaub ntawv pov thawj, tab sis tsuas yog ib feem ntawm nws cov ntxhuav, tom qab ntawd nyem nrog nas nyob hauv cov npe no tsuas yog cov rooj uas koj xav tau, thaum tuav cia CTRL tus yuam sij.
Kauj ruam 4
Khij lub thawv tom ntej ntawm cov ntawv yuav tsum tau ua tawm hauv daim ntawv. Los ntawm lub neej ntawd, SQL txheeb xyuas ntawm no, tab sis yog tias cov ntaub ntawv khaws tseg rau export rau tom qab thauj mus rau hauv txhua daim ntawv thov chaw haujlwm, tom qab ntawd xaiv cov qauv tsim nyog hauv cov npe no.
Kauj ruam 5
Yog hais tias SQL hom ntawv tau hais kom ua, tom qab ntawd nws yog qhov yuav tsum tau kuaj xyuas qhov tseeb ntawm cov chaw hauv seem "Cov Qauv". Ua tib zoo mloog rau cov kev teeb tsa hauv seem "Cov Qauv Txheej Txheem". Yog tias nyob rau hauv tus txheej txheem ntawm kev xa tawm hauv "Ntxiv DROP ROOJ" daim teb raug tshawb xyuas, tom qab ntawd cov lus qhia rau kev txiav cov rooj uas twb muaj nrog cov npe piv yuav muab ntxiv rau hauv cov ntawv. Qhov no txhais tau tias thaum koj import nws tom qab, cov ntaub ntawv uas twb muaj lawm yuav raug rhuav tshem thiab hloov nrog cov ntaub ntawv tshiab. Yog tias koj npaj siab yuav ntxiv cov ntsiab lus ntawm lwm cov ntawv sau los ntawm cov ntaub ntawv no, ces yuav tsum kos tus cim tseg yuav tsum muab tshem tawm. Yog tias "Ntxiv IF TSIS TAU EXISTS" kev xaiv tau tshawb xyuas, tom qab ntawd cov lus qhia yuav muab tso rau hauv cov ntaub ntawv xa tawm, vim cov ntaub ntawv yuav ntxiv rau cov ntsiab lus ntawm cov ntxhuav nrog cov npe uas raug.
Kauj Ruam 6
Xaiv lub thawv "Txuag ua cov ntaub ntawv". Thaum tsis muaj lub npov no, cov ntaub ntawv raug xa tawm yuav muab tso rau hauv cov ntawv sau ncaj qha hauv phpMyAdmin interface nplooj ntawv. Yog tias tsis muaj ntau cov ntaub ntawv, tom qab ntawv xaiv no kuj tseem tuaj yeem ua tau - cov ntaub ntawv tuaj yeem theej tawm thiab siv ntxiv ntawm koj txoj kev xaiv.
Kauj Ruam 7
Nyem lub pob OK rau hauv qab ntawm txoj cai thav duab pib pib xa cov khoom.
