Qhov yuav tsum tau khaws cov ntsiab lus ntawm databases ntawm lub local disk ntawm koj lub computer tshwm sim ntau zaus. Yog tias peb tab tom tham txog cov ntaub ntawv ntawm txhua lub vev xaib hauv Internet, tom qab ntawd, pom meej, cov ntaub ntawv khaws cia nyob rau hauv MySQL hom - tam sim no nws yog qhov tseem ceeb DBMS hauv kev lag luam web. Hauv qab no yog cov txheej txheem rau kev tso unloading databases los ntawm MySQL DBMS.
Cov Lus Qhia
Kauj ruam 1
Qhov kev xaiv zoo tshaj plaws yog siv phpMyAdmin online interface. Nws tau muab los ntawm yuav luag txhua tus muab kev pabcuam raws li MySQL qhov chaw tswj ntaub ntawv. Nyob rau thawj theem ntawm cov ntaub ntawv uploading kev ua haujlwm, koj yuav tsum nrhiav ntu "Databases" hauv koj tus tswj hwm tswj hwm, uas muaj qhov txuas rau phpMyAdmin. Qhib nws thiab mus rau lub chaw khaws ntaub ntawv uas cov ntxhuav yuav tsum tau muab tso tseg nyob. Xaiv cov ntaub ntawv uas yuav tsum tau nyob hauv kem sab laug ntawm lub interface.
Kauj ruam 2
Tom qab nkag mus rau lub chaw khaws ntaub ntawv, mus rau nplooj ntawv upload - nyob rau sab saum toj ntawm txoj cai pane, nyem qhov txuas uas hais tias "Export".
Kauj ruam 3
Hauv cov pab pawg ntawm kev teeb tsa nrog lub ncauj lus "Export" koj yuav tsum xaiv txhua lub rooj tsis suav. Koj tuaj yeem nyem qhov Xaiv Txhua qhov txuas, lossis xaiv qee qhov los ntawm nias txhua lub rooj sib tham thaum tuav cia CTRL tus yuam sij.
Kauj ruam 4
Tam sim no xaiv ib hom ntawv los cawm cov ntaub ntawv uploaded. Yog tias koj npaj siab yuav xa lawv mus rau lwm tus SQL neeg rau zaub mov, tom qab ntawd tawm hauv hom SQL, thiab xaiv cov hom ntawv tsim nyog los ua haujlwm nrog cov ntaub ntawv hauv qee lwm daim ntawv thov.
Kauj ruam 5
Yog tias hom ntawv SQL tau raug xaiv, tom qab ntawd hauv cov pab pawg ntawm cov chaw nrog kab lus "Kab Txwv" khij rau cov thawv tsim nyog. Qhov tseem ceeb tshaj plaws ntawm no yog cov chaw hauv seem "Txawv Tebchaws" - ib qho chaw kos rov qab los ntawm cov ntawv sau "Ntxiv DROP RABLE" yuav ua rau qhov tseeb tias ua ntej yuav thauj cov ntaub ntawv mus rau lawv cov chaw cia tshiab, cov ntxhuav uas twb muaj nrog tib lub npe yuav raug rhuav tshem. Cov. Yog tias koj xav kom tsis txhob sau dua tshiab, tab sis kom ntxiv cov ntaub ntawv rau cov uas twb muaj lawm, ces qhov cim no yuav tsum tsis txhob txheeb. Qhov "Ntxiv IF TSIS EXISTS" kev xaiv muaj qhov laj thawj zoo sib xws - lub rooj yuav tsim yog tias tib yam tsis muaj nyob rau lub server tshiab, txwv tsis pub cov ntaub ntawv yuav ntxiv rau cov qub.
Kauj Ruam 6
Yog tias koj xav tau cov ntaub ntawv nyob hauv cov ntawv sau cia, xaiv lub thawv tom ntej no "Txuag ua cov ntaub ntawv". Tsis muaj qhov cim tseg, cov ntaub ntawv yuav muab tso rau hauv kab ntawv sau, los ntawm qhov nws tuaj yeem theej tawm thiab kuj tau khaws cia rau hauv cov ntawv lossis siv nyob rau lwm qhov.
Kauj Ruam 7
Thaum kawg, txhua yam uas tseem tshuav yog los nias lub pob "OK" los pib txheej txheem.
