Ukufikelela kwinkqubo yefayile usebenzisa i-SQL

Ndisandula ukufumana ukhetho oluhle kwi-MySQL yokufaka inkqubo yefayile kunye nokufumana ulwazi oluxabisekileyo, umzekelo malunga nobukho beefayile kunye neefolda okanye imixholo yazo. Oku kunokuba luncedo njengenye indlela yokwenza umsebenzi we-php file_exists , njengoko ulwazi malunga nobukho beefayile (ezo) lusenokusetyenziswa kumbuzo wokuqhubeka kokuhlelwa kwemisebenzi kunye nokudityaniswa kwemisebenzi.


Ukuba umsebenzisi wedatha onxulumene noko unelungelo leFILE , ungawusebenzisa lo myalelo

SELECT LOAD_FILE(*PFAD ZUR DATEI*)

Ngexesha lombuzo sukujonga kuphela ukuba ikhona na ifayile, kodwa ufunde nomxholo wayo.

Kwiinkqubo zeWindows kufuneka kuqatshelwe ukuba ukubuyela umva kufuneka kumakishwe ngokufanelekileyo kwindlela eya kwifayile (umzekelo: C: \\ Windows \\ System32 \\ drivers \\ etc \\ hosts). Umba wokhuseleko akufuneki ungakhathalelwanga ngokupheleleyo, kuba xa ilungelo leFILE linikiwe, ukufikelela kwindawo yogcino lwedatha ngokuzenzekelayo kuthetha ukufikelela kuyo yonke inkqubo yefayile.

Ukuqinisekisa ukuba ayisiwo kuphela amaxabiso e-NULL abuyiswayo, kufuneka kuqinisekiswe ukuba umsebenzisi osebenzisa i-MySQL ufundile amalungelo.

Ukufikelela kwiifayile ezinkulu, ipropathi yomhlaba "max_allowed_packet", emiselwe kwi-1 MB, kufuneka inyuswe.

mysql -u... -p...
set global max_allowed_packet = 1024 * 1024 * 512;
exit;

Ngoku (emva kokuqalisa kwakhona iserver) ukufikelela kwiifayile ezifikelela kwi-512 MB ngobukhulu.

Emva