Muva nje ngithole indlela ehlanzekile yokufinyelela uhlelo lwefayela nokuthola ulwazi olubalulekile, njengokuba khona kwamafayela namafolda noma okuqukethwe kwawo. Lokhu kungaba usizo kakhulu esikhundleni somsebenzi we-PHP ` file_exists` , njengoba ulwazi mayelana nokuba khona kwamafayela lungasetshenziswa embuzweni ukuze kuqhutshekwe nemisebenzi yokuhlunga nokuhlanganisa.
Uma nje umsebenzisi wedathabheyisi ohambisanayo enamalungelo e-FILE , umyalo ungasetshenziswa
SELECT LOAD_FILE(*PFAD ZUR DATEI*)
Ngesikhathi sombuzo ungabheki kuphela ukuthi ngabe ifayili likhona yini, kepha futhi funda okuqukethwe kwalo.
Kuzinhlelo zeWindows kufanele kuqashelwe ukuthi ukubuyela emuva endleleni eya kufayela kufanele kumakwe ngokufanele (isibonelo: C: \\ Windows \\ System32 \\ drivers \\ etc \\ hosts). Isici sokuphepha akufanele futhi singanakwa ngokuphelele, ngoba lapho kunikezwa ilungelo le-FILE, ukufinyelela ku-database ngokuzenzakalela kusho ukufinyelela kulo lonke uhlelo lwefayela.
Ukuqinisekisa ukuthi akubuyiswa kuphela amanani we-NULL, kufanele kuqinisekiswe ukuthi umsebenzisi osebenzisa i-MySQL uwafundile amalungelo.
Ukufinyelela kumafayili amakhulu, impahla yomhlaba "i-max_allowed_packet", esethelwe ku-1 MB, kufanele inyuswe.
mysql -u... -p... set global max_allowed_packet = 1024 * 1024 * 512; exit;
Manje usungakwazi (ngemuva kokuqalisa kabusha iseva) ukufinyelela amafayela afinyelela ku-512 MB ngosayizi.