daws qhov teeb meem uas phpMyAdmin lub vev xaib server tsis muaj kev tso cai los khaws cov ntaub ntawv .sql

daws phpMyAdmin Lub vev xaib server tsis khaws cov ntaub ntawv /home/abc/cwl_cwl.sql Qhov teeb meem tso cai

Koj puas tau ntsib tej xwm txheej zoo li no? thaum koj siv phpMyAdmin Thaum xa tawm cov ntaub ntawv, kuv pom tias nws tsis tuaj yeem khaws cov ntaub ntawv mus rau cov npe teev tseg. Nws tsis yog qhov tshwj xeeb maddening?

Qhov teeb meem no muaj ntau heev, vim hais tias feem ntau cov neeg rau zaub mov tsis muaj ntawv tso cai rau txoj kev ntawd.

Yog li, tam sim no cia peb daws qhov teeb meem no ib zaug thiab rau tag nrho thiab ua kom koj lub vev xaib ua haujlwm zoo.

Vim li cas phpMyAdmin lub vev xaib server tsis muaj kev tso cai los cawm .sql cov ntaub ntawv?

Ua ntej, peb yuav tsum nkag siab txog lub ntsiab lus tseem ceeb: Txhua lub vev xaib server muaj qee qhov kev tso cai nkag mus, uas tswj cov neeg siv lossis cov kev pabcuam tuaj yeem nyeem, sau, lossis ua haujlwm qee yam.

Yog tias koj tus neeg rau zaub mov (xws li Apache lossis Nginx) tsis muaj kev tso cai los sau rau qee cov npe, nws yuav tsis tuaj yeem khaws cov ntaub ntawv. yog vim li cas phpMyAdmin Nws hais rau koj tias "Koj tsis muaj kev tso cai los khaws cov ntaub ntawv."

Txhawm rau muab nws yooj yim,phpMyAdmin Xav txuag database backup rau /home/abc/cwl_cwl.sql Txoj kev no, tab sis vim hais tias tus neeg rau zaub mov tsis muaj kev tso cai, nws tsis tuaj yeem txav mus rau daim nplaub tshev no txhua.

Yog li, qhov teeb meem yog dab tsi? Tso cai! Tso cai! Tso cai!

Kev daws: Restore tus khub /home/abc/ Cov ntawv tso cai

Txij li qhov teeb meem nyob hauv kev tso cai, cia peb pib los ntawm kev hloov pauv kev tso cai.

Tso cai rau tus neeg rau zaub mov nkag mus thiab sau rau hauv phau ntawv tso cai phpMyAdmin Ua nws txoj hauj lwm smoothly.

1. Hloov cov ntawv tso cai

Qhov no yog txoj kev ncaj tshaj plaws. koj yuav tau hloov kho /home/abc/ Kev tso cai ntawm cov npe kom cov neeg rau zaub mov (xws li Apache lossis Nginx) tuaj yeem sau rau nws. Xav tias koj lub server yog Apache thiab ua haujlwm www-data Tus neeg siv (qhov no yog tus neeg siv lub neej ntawd Apache, tau kawg koj tuaj yeem kho tus neeg siv thiab pab pawg raws li koj qhov kev teeb tsa tiag tiag).

kauj ruam:

sudo chown www-data:www-data /home/abc/ -R
sudo chmod 755 /home/abc/ -R

piav qhia:

• chown www-data:www-data /home/abc/ -R: Cov lus txib no yuav /home/abc/ Tus tswv ntawm cov npe thiab nws cov npe subdirectories raug hloov mus rau www-data Cov neeg siv thiab pab pawg.
• chmod 755 /home/abc/ -R: Cov lus txib no yuav muab rau tus tswv phau ntawv nyeem, sau ntawv, thiab ua tiav kev tso cai, thaum pab pawg thiab lwm tus neeg siv tsuas yog nyeem thiab ua tiav kev tso cai.

ntawm no,755 Nws yog qhov kev tso cai classic heev uas tuaj yeem ua kom ntseeg tau tias lub vev xaib server muaj kev tso cai txaus los ua haujlwm cov ntaub ntawv, thaum tsis muab kev tso cai ntau dhau rau lwm tus neeg siv los tiv thaiv kev ruaj ntseg.

2. Siv /tmp/ Directory (lwm cov tshuaj uas tsis tawm hauv paus directory)

Yog tias koj xav hloov kho /home/abc/ Yog tias koj tsis paub meej txog cov ntawv tso cai, lossis yog tias koj xav tswj hwm tus qauv ntawm cov thawj coj, muaj lwm txoj hauv kev ntse dua.

koj tso tau phpMyAdmin Txuag cov ntaub ntawv rau /tmp/ Phau ntawv, phau ntawv no feem ntau muaj kev tso cai qhib rau txhua tus neeg siv.

Thaum exporting lub database, ncaj qha xaiv /tmp/ Raws li txoj kev txuag, cov lus txib yog raws li nram no:

/tmp/cwl_cwl.sql

Ua li no zam teeb meem kev tso cai. Cov ntaub ntawv yuav raug cawm rau /tmp/ directory, thiab tom qab ntawd koj tuaj yeem txav nws mus rau cov npe koj xav tau, txuag koj qhov teeb meem ntawm kev hloov pauv kev tso cai.

3. Tshawb xyuas phpMyAdmin kev teeb tsa

Yog tias koj tau sim cov hau kev saum toj no thiab nws tseem tsis ua haujlwm, qhov teeb meem yuav yog phpMyAdmin Ntawm nws tus kheej configuration. Qee zaum,phpMyAdmin Nws tuaj yeem raug teeb tsa kom tsuas yog tso cai rau cov ntaub ntawv khaws cia rau cov npe tshwj xeeb, qhov kev txwv no tuaj yeem pom hauv cov ntaub ntawv teeb tsa.

kauj ruam:

Koj yuav tsum saib lossis hloov kho phpMyAdmin Configuration file, txoj kev yog feem ntau:

/etc/phpmyadmin/

los yog:

/usr/share/phpmyadmin/

Koj tuaj yeem tshawb xyuas yog tias muaj kev txwv txoj hauv kev zoo sib xws thiab hloov kho lawv raws li. Yog tias koj tsis paub meej tias yuav hloov kho cov ntaub ntawv teeb tsa li cas, nws raug nquahu kom rov qab cov ntaub ntawv qub ua ntej kom koj tuaj yeem rov qab tau yooj yim yog tias muaj qee yam yuam kev.

Vim li cas cov txheej txheem no ua haujlwm?

Qhov tseeb, tsis muaj teeb meem dab tsi yog qhov kev daws teeb meem, lub hauv paus tseem nyob ntawm qhov teeb meem kev tso cai. Cov web servers, tshwj xeeb tshaj yog cov servers xws li Apache lossis Nginx, tau nruj tswj hwm los ntawm kev khiav haujlwm thaum nkag mus rau cov kab ke. Peb tuaj yeem yooj yim hla cov kev txwv no los ntawm kev kho cov kev tso cai lossis hloov txoj kev txuag.

Hloov kho cov ntawv tso cai tuaj yeem daws qhov teeb meem ntawm tus neeg rau zaub mov tsis tuaj yeem sau, tab sis qee zaum vim muaj kev ruaj ntseg, koj yuav tsis xav hloov cov kev tso cai ntawm cov ntawv tseem ceeb. Lub sijhawm no /tmp/ Phau ntawv yog ib qho kev xaiv zoo, hloov tau yooj yim thiab yooj yim.

Thiab daim tshev kawg phpMyAdmin Kev teeb tsa yog txhawm rau tshem tawm qee qhov teeb meem nyuaj dua qhov system-theem. Tom qab tag nrho, qee zaum qhov teeb meem tsis yog peb txoj cai;Softwaretus kheej configuration txwv.

kuv xav

Hais txog qhov teeb meem ntawm kev tso cai, nws yog qhov ua tau kom tsis txhob muaj qhov nyuaj hauv kev sib koom tes ntawm kev ua haujlwm thiab lub vev xaib server. Koj tuaj yeem xav tias nws yog ib qho kev tiv thaiv nruj txhua tus neeg siv thiab cov kev pab cuam yuav tsum tau qhia lawv tus ID thiab tau txais kev tso cai yog tias lawv xav nkag thiab ua tej yam. Thiab thaum qhov "kev tso cai" tsis txaus, teeb meem tshwm sim.

Nyob rau theem siab dua, qhov teeb meem kev tso cai zoo li yooj yim, tab sis nws yog qhov tseem ceeb ntawm kev ua kom muaj kev ruaj ntseg thiab ruaj khov ntawm tag nrho cov kab ke. Kev teeb tsa kev tso cai siab dhau lossis qis dhau yuav ua rau muaj teeb meem yog tias nws qis dhau, nws yuav cuam tshuam rau kev ua haujlwm ib txwm muaj ntawm qhov kev zov me nyuam yog tias nws siab dhau, nws yuav ua rau muaj kev pheej hmoo.

Yog li ntawd, daws phpMyAdmin Thaum nws los txog rau cov teeb meem kev tso cai, peb tsis yog "kho cov tsos mob", tab sis kuj "kho cov hauv paus hauv paus" - koj yuav tsum xyuas kom meej tias lub server configuration yog ob qho tib si muaj kev nyab xeeb thiab zoo.

Cov ntsiab lus thiab cov lus qhia ua haujlwm

Piv txwv li, thaum twg phpMyAdmin Thaum koj ntsib teeb meem kev tso cai khaws cov ntaub ntawv, koj muaj ntau txoj kev xaiv los ntawm:

1. Hloov cov ntawv tso cai: Qhov no yog txoj hauv kev ncaj qha tshaj plaws los muab kev tso cai rau tus neeg rau zaub mov los sau rau hauv phau ntawv qhia thiab daws qhov teeb meem tseem ceeb.
2. siv /tmp/ txheej txheem: Yog tias koj tsis xav hloov kho cov ntawv tso cai, koj tuaj yeem khaws cov ntaub ntawv mus rau ib ntus /tmp/, thiab ces txav manually.
3. ib qho kev xeem phpMyAdmin 配置: Yog tias tsis muaj teeb meem nrog kev tso cai, nws yuav yog phpMyAdmin Teeb meem tshwm sim los ntawm koj tus kheej configuration, xyuas cov ntaub ntawv configuration kom tshem tawm qhov ua tau no.

Txhua qhov kev daws teeb meem muaj nws cov xwm txheej siv tau. Kuv qhov kev pom zoo yog thawj zaug sim hloov kho cov ntawv tso cai no yog txoj hauv kev ncaj ncees tshaj plaws. Yog tias koj tsis xav hloov kev tso cai rau kev ruaj ntseg, koj tuaj yeem xaiv siv /tmp/ Cov ntsiab lus. Thaum kawg, yog tias qhov teeb meem tseem tsis tau daws, kos phpMyAdmin configuration file.

Cov teeb meem kev tso cai yuav tsis ploj mus, tab sis cov kev daws teeb meem muaj ntau yam. Tam sim no, koj tuaj yeem xaiv qhov kev daws teeb meem zoo tshaj plaws raws li koj qhov xwm txheej thiab ua tam sim no!