Cov thawj tswj hwm uas paub zoo tau paub txog qhov ua ntej tias khaws cov ntaub ntawv thaub qab thiab rov kho nws yuav cawm koj ntau yam ntawm kev ua haujlwm yog qhov tshwm sim tsis ua tiav. Yog li ntawd, lub peev xwm los khaws cov ntaub ntawv rov qab yog ib qho txuj ci tseem ceeb ntawm kev tswj hwm.
Cov Lus Qhia
Kauj ruam 1
Txhawm rau rov qab khaws cov ntaub ntawv, koj yuav tsum muaj nws txoj kev txhawb nqa nrog kev hloov pauv tshiab. Ua qhov no, tom qab txhua txoj haujlwm tshiab lossis ua ntej sim nrog koj cov lej cim, nkag mus rau koj lub khoos phis tawm ua cov ntaub ntawv archive lossis sql.
Kauj ruam 2
Qhib koj lub browser. Hauv qhov chaw nyob bar, sau: localhost. Xaiv Phpmyadmin los ntawm kev xav kom tsim txiaj. Mus rau Phpmyadmin vaj huam sib luag. Ua ntej tshaj plaws, lawb tawm cov rooj uas tau puas los ntawm kev sib tsoo. Txhawm rau ua qhov no, xaiv lub npe ntawm cov sib piv hauv cov npe hauv kab ntawv sab laug thiab hauv cov npe uas tau qhib, nyem kab ntawv txuas hauv qab no "Cim txhua". Tom qab ntawd nyem rau ntawm "Nrog cim" teb thiab xaiv "Rho tawm" los ntawm cov npe uas qhib. Paub meej tias qhov kev txiav txim hauv lub qhov rai pop-up.
Kauj ruam 3
Tam sim no mus rau hauv daim nplaub tshev hauv koj lub computer qhov chaw khaws ntaub ntawv khaws tseg. Yog tias koj khaws nws ua hom ntawv sql, tom qab ntawd tsuas qhib daim ntawv thiab luam cov ntawv cim kab ntawv rau daim ntawv los teev cia (Ctrl + A - xaiv, Ctrl + C - theej). Tom qab ntawd, nkag mus rau hauv Phpmyadmin, xaiv cov ntaub ntawv khaws cia kom rov qab, thiab hauv SQL tab, muab cov ntsiab lus (Ctrl + V) rau hauv cov lus nug cov lus teb.
Kauj ruam 4
Nyem "OK", thiab tom qab lub sijhawm, yog tias txoj haujlwm tau ua tiav, cov lus "SQL lus nug ua tiav" yuav tshwm nyob rau hauv kab kab hais kom ua. Yog tias qhov no tsis tshwm sim, ces cov ntxhuav loj dhau, thiab nws yog qhov zoo dua rau nws thauj nws mus rau hauv lub database ntawm cov lus txib ntshuam.
Kauj ruam 5
Zauv koj cov ntawv sql uas siv Winrar lossis 7-Zip. Thov nco ntsoov tias lub npe ntawm koj cov ntawv yuav tsum muaj hom ntawv thiab nrau (piv txwv li, base.sql.zip). Tom qab koj tau sau npe lub npe ntawm cov ntawv, rov qab mus rau Phpmyadmin, xaiv cov ntaub ntawv uas yuav tsum tau thiab mus rau "Import" tab.
Kauj Ruam 6
Los ntawm txhaj "Xaiv Cov Ntaub Ntawv", siv lub Explorer kom pom cov ntaub ntawv koj nyuam qhuav ua. Xaiv nws, teem lub encoding rau utf-8. Nyem kos cim rau ntawm cov ntawv "Tso cai rau tsab ntawv los rhuav tshem cov txheej txheem ntshuam" thiab xaiv hom SQL. Nyem rau khawm "Ok". Yog tias tsis muaj qhov yuam kev tshiab, koj yuav tau txais cov lus: "Cov ntaub ntawv ntshuam tiav tiav."
