Cov khib nyiab yog cov ntaub ntawv uas tau xaiv los ntawm lub hauv paus hauv ib qho chaw uas tsis tu ncua, nyob rau hauv daim ntawv ntawm daim ntawv teev npe tam sim ntawd, lawv tau npaj los txhawm rau txhawm rau txhawm rau txhawm rau txhawm. Cov ntawv pov tseg tsis yog khi rau ib hom server tshwj xeeb, tsis zoo li cov ntaub ntawv ua haujlwm cov ntaub ntawv lawv tus kheej.
Tsim nyog
txuj ci hauv kev ua haujlwm nrog MySql
Cov Lus Qhia
Kauj ruam 1
Import cov ntawv pov tseg cov ntawv pov tseg rau hauv Denver site database. Ib qho kev ua haujlwm uas tau yooj yim ntawm cov neeg siv lub tshuab hoster tuaj tsis tuaj yeem ua rau hauv Denver, txij li tsis muaj lub pob ntshuam hauv phpMyAdmin tswj hwm. Rub tawm tshiab cov phpMyAdmin. Hloov cov ntaub ntawv hauv daim nplaub tshev uas nyob hauv qab txoj kev hauv tsev / localhost / www / Cuab Yeej / phpmyadmin nrog cov ntaub ntawv uas nyob hauv qhov faib tawm. Tom qab ntawd, Lub pob tseem ceeb yuav tsum tshwm sim hauv phpMyAdmin tswj hwm vaj huam sib luag, uas tsim nyog los lis cov khoom seem.
Kauj ruam 2
Qhib php.ini cov ntaub ntawv hauv usr / zos / php5 directory nrog notepad. Ua kom cov lus hauv qab no ntxiv rau hauv cov ntaub ntawv no: qhov siab tshaj plaws nco, qhov ntau npaum li cas lub sijhawm rau txhua tsab ntawv, qhov siab tshaj plaws xa cov ntaub ntawv loj, cov ntaub ntawv ntau tshaj plaws rau kev xa tawm. Qhov no yog qhov tsim nyog txhawm rau txhawm rau txheeb xa cov ntaub ntawv tsis muaj teeb meem yog tias nws loj. Rov qab Apache.
Kauj ruam 3
Mus rau koj lub phpMyAdmin tswj hwm vaj huam sib luag, nyem lub khawm Ntshuam. Yog tias cov ntaub ntawv pov thawj database loj thiab tsis tuaj yeem thauj khoom siv phpMyAdmin, siv cov hauv qab no. Tsim cov ntaub ntawv tshiab hauv MySQL, nkag rau tus neeg siv tshiab. Mus rau usr / local / mysql / cov nplaub tshev cov ntaub ntawv - ib lub nplaub tshev yuav tsum tshwm sim hauv nws, uas muaj npe tib yam li koj cov ntaub ntawv tshiab. Hauv nws, MySQL txuag cov ntaub ntawv ntawm cov ntaub ntawv tshiab. Luam cov ntaub ntawv los ntawm cov ntaub ntawv qub rau daim nplaub tshev no, rov qab Denver.
Kauj ruam 4
Siv cov chaw khaws ntaub ntawv siv lub console. Sau cov lej cim hauv kab ntawv hauv qab no: mysql -u myuser -p <dump.sql, tom qab ntawd koj yuav tau sim rau MySQL tus password, sau tus password los nkag lub database pov tseg. Tom qab ntawv, ib tus neeg txhais lus hais kom sai yuav tshwm sim, nyob rau hauv uas Myuser yog Mysql username, thiab Dump yog koj lub pob tseg database. Yog tias sim tam sim ntawd rau lub npe database, muab qhov hais kom ua mysql -u myuser -p "Sau Cov Ntaub Ntawv Npe" <dump.sql.
