Sombulula ingxaki ukuba iseva yewebhusayithi yephpMyAdmin ayinayo imvume yokugcina iifayile ze-sql

sombulula phpMyAdmin Iseva yewebhusayithi ayigcinanga fayile /home/abc/cwl_cwl.sql Umba weemvume

Ngaba wakha wadibana nemeko enjalo? xa usebenzisa phpMyAdmin Xa ndithumela ngaphandle i-database, ndifumene ukuba ayinakuyigcina ifayile kuluhlu oluchaziweyo. Ngaba ayiphambani ngakumbi?

Le ngxaki eneneni ixhaphake kakhulu, kuba umncedisi akanayo imvume yokubhala kulo ndlela.

Ke, ngoku masisombulule le ngxaki kube kanye kwaye wenze iwebhusayithi yakho iqhube kakuhle.

Kutheni iseva yewebhusayithi yephpMyAdmin ingenayo imvume yokugcina iifayile ze.sql?

Okokuqala, kufuneka siqonde ingqikelelo esisiseko: Iseva nganye yewebhusayithi inesetingi zemvume yokufikelela, elawula ukuba ngabaphi abasebenzisi okanye iinkonzo ezinokufunda, ukubhala, okanye ukwenza imisebenzi ethile.

Ukuba umncedisi wakho (ofana ne-Apache okanye i-Nginx) akanayo imvume yokubhalela kulawulo oluthile, ngokwemvelo ayiyi kukwazi ukugcina ifayile. kunjalo ngoba phpMyAdmin Ikukhuthaza ukuba "Awunayo imvume yokugcina ifayile."

Ukuyibeka ngokulula,phpMyAdmin Ufuna ukugcina i-backup yedatabase /home/abc/cwl_cwl.sql Lo mendo, kodwa ngenxa yokuba umncedisi akanayo imvume, akanakuyisusa le ncwadi kwaphela.

Ngoko, yintoni kanye kanye ingxaki? Iimvume! Iimvume! Iimvume!

Isisombululo: Buyisela isibini /home/abc/ Iimvume zikavimba weefayili

Kuba ingxaki ilele kwiimvume, masiqale ngokuguqula iimvume.

Ukuvumela umncedisi ukuba afikelele kwaye abhale kulawulo kuvumela phpMyAdmin Yenza umsebenzi wayo ngokukhawuleza.

1. Guqula iimvume zolawulo

Le yeyona ndlela ingqalileyo. kufuneka ulungise /home/abc/ Iimvume kuluhlu ukwenzela ukuba umncedisi (onje ngeApache okanye iNginx) angabhalela kuyo. Cinga ukuba iseva yakho yiApache kwaye iyasebenza www-data Umsebenzisi (lo ngumsebenzisi ongagqibekanga we-Apache, ngokuqinisekileyo ungahlengahlengisa umsebenzisi kunye neqela ngokoqwalaselo lwakho lokwenyani).

inyathelo:

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

cacisa:

• chown www-data:www-data /home/abc/ -R: Lo myalelo uya kwenza /home/abc/ Umnini kavimba weefayili kunye noovimba beefayili balo batshintshelwe www-data Abasebenzisi kunye namaqela.
• chmod 755 /home/abc/ -R: Lo myalelo uya kunika umnini-ncwadi ukuba afunde, abhale, kwaye aphumeze iimvumelwano, ngelixa iqela kunye nabanye abasebenzisi befunde kwaye baphumeze iimvume kuphela.

Apha,755 Lulungiselelo lwemvume oluqhelekileyo olunokuqinisekisa ukuba iseva yewebhusayithi ineemvume ezaneleyo zokusebenzisa iifayile, ngelixa inganiki imvume eninzi kwabanye abasebenzisi ukukhusela ukhuseleko lwenkqubo.

2. Sebenzisa /tmp/ Uvimba weefayili (esinye isisombululo esingashiyiyo ingcambu kavimba weefayili)

Ukuba unomdla wokuguqula /home/abc/ Ukuba awuqinisekanga malunga neemvume zolawulo, okanye ukuba ufuna ukugcina uvimba weefayili woqobo, kukho enye indlela ekrelekrele ngakumbi.

ungavumela phpMyAdmin Gcina ifayile kuyo /tmp/ Uvimba weefayili, olu luhlu lunemvumelwano yokubhala ngokubanzi evulelwe bonke abasebenzisi.

Xa uthumela ngaphandle i-database, khetha ngokuthe ngqo /tmp/ Njengendlela yokugcina, lo myalelo ulandelayo:

/tmp/cwl_cwl.sql

Ukwenza oku kuthintela imiba yemvume. Ifayile izakugcinwa kuyo /tmp/ ulawulo, kwaye emva koko ungayihambisa ngesandla kulawulo olufunayo, igcina ingxaki yokuguqula iimvumelwano.

3. Khangela phpMyAdmin uqwalaselo

Ukuba uye wazama ezi ndlela zingasentla kwaye ayikasebenzi, ingxaki inokuba phpMyAdmin Kuqwalaselo lwayo. Kwezinye iimeko,phpMyAdmin Inokuthi iqwalaselwe ukuvumela kuphela iifayile ukuba zigcinwe kubalawuli abathile, esi sithintelo sinokufunyanwa kwifayile yoqwalaselo.

inyathelo:

Kufuneka ujonge okanye ulungise phpMyAdmin Ifayile yoqwalaselo, umendo uqhelekile:

/etc/phpmyadmin/

okanye:

/usr/share/phpmyadmin/

Ungajonga ukuba imida yendlela efanayo ikhona kwaye uyiguqule ngokufanelekileyo. Ukuba awuqinisekanga ukuba ungayiguqula njani ifayile yoqwalaselo, kuyacetyiswa ukuba ubuyisele ifayile yoqobo kuqala ukuze ukwazi ukuyibuyisela ngokulula ukuba kukho into engahambi kakuhle.

Kutheni zisebenza ezi ndlela?

Enyanisweni, kungakhathaliseki ukuba luhlobo luni lwesisombululo, undoqo ujikeleza umba wemvume. Iiseva zewebhu, ngakumbi iiseva ezifana ne-Apache okanye i-Nginx, zilawulwa ngokuqinileyo yinkqubo yokusebenza xa ufikelela kubalawuli benkqubo. Singakwazi ukudlula ngokulula ezi zithintelo ngokulungelelanisa iimvume okanye ukutshintsha indlela yokugcina.

Ukuguqula iimvume zolawulo kunokusombulula ingxaki yomncedisi engakwazi ukubhala, kodwa ngamanye amaxesha ngenxa yezizathu zokhuseleko, usenokungafuni ukulungisa iimvume zeefolda ezingundoqo. Ngeli xesha /tmp/ Izalathisi zezona ndlela ilungileyo, zibhetyebhetye kwaye zilula.

Kwaye itshekhi yokugqibela phpMyAdmin Uqwalaselo kukuphelisa ezinye iingxaki ezifihlakeleyo zomgangatho wenkqubo. Ngapha koko, ngamanye amaxesha ingxaki ayilogunya lethu;软件eyakho imida yoqwalaselo.

uluvo lwam

Ngokuphathelele umba weemvume, ngokwenene yinkimbinkimbi engenakuphepheka kumsebenzi wokubambisana wenkqubo yokusebenza kunye nomncedisi wewebhusayithi. Unokucinga ngayo njengenkqubo engqongqo yokugada Wonke umsebenzisi kunye nenkqubo kufuneka abonise i-ID yakhe kwaye afumane imvume ukuba bafuna ukungena kwaye benze izinto. Kwaye xa le "mvume" inganelanga, kuvela iingxaki.

Kwinqanaba eliphezulu, umba wemvume ubonakala ulula, kodwa ngokwenene yinxalenye ebalulekileyo yokuqinisekisa ukhuseleko kunye nokuzinza kwenkqubo yonke. Ukuseta iimvume eziphakamileyo kakhulu okanye eziphantsi kakhulu kunokubangela iingxaki ukuba ziphantsi kakhulu, kuya kuchaphazela ukusebenza kwesiqhelo kwenkqubo Ukuba iphezulu kakhulu, kunokubangela imingcipheko yokhuseleko.

Ngoko ke, lungisa phpMyAdmin Xa kuziwa kwimiba yeemvume, asikho nje "ukunyanga iimpawu", kodwa "nokuphatha unobangela" - kufuneka uqinisekise ukuba uqwalaselo lomncedisi lukhuselekile kwaye lusebenza kakuhle.

Isishwankathelo kunye neengcebiso zokwenza

Ukushwankathela, nini phpMyAdmin Xa udibana nemiba yemvume yokugcina iifayile, unezisombululo ezininzi onokukhetha kuzo:

1. Guqula iimvume zolawulo: Le yeyona ndlela ingqalileyo yokunika umncedisi imvume yokubhalela kulawulo nokusombulula ingxaki engundoqo.
2. 使用 /tmp/ isiqulatho: Ukuba awufuni ukulungisa iimvume zolawulo, ungagcina okwethutyana ifayile kuyo /tmp/, kwaye emva koko uhambe ngesandla.
3. uviwo phpMyAdmin Uqwalaselo: Ukuba akukho ngxaki ngoseto lwemvume, isenokuba phpMyAdmin Iingxaki ezibangelwa kuqwalaselo lwakho, jonga ifayile yoqwalaselo ukuphelisa le nto inokwenzeka.

Isisombululo ngasinye sineemeko ezisebenzayo. Ingcebiso yam kukuqala uzame ukulungisa iimvume zolawulo Le yeyona ndlela ithe ngqo nesebenzayo. Ukuba awufuni ukulungisa iimvume ngenxa yezizathu zokhuseleko, ungakhetha ukusebenzisa /tmp/ Isiqulatho. Ekugqibeleni, ukuba ingxaki ayikasonjululwa, khangela phpMyAdmin ifayile yoqwalaselo.

Imiba yeemvume ayiyi kuhamba, kodwa izisombululo zahlukene. Ngoku, unokukhetha esona sisombululo sifanelekileyo ngokwemeko yakho kwaye uthathe inyathelo ngoku!