如何增加 LOAD DATA INFILE 查询的最大上传文件大小? [英] How to increase maximum upload file size of LOAD DATA INFILE query?

问题描述

我正在使用加载数据查询将文本文件加载到数据库中.将文件大小上传到 2GB 没有问题但我无法上传超过 2GB 的文件.我的查询如下

I am loading a text file into database using load data query. There is no problem uploading the file size upto 2GB But i couldn't upload the files more then 2 GB. My query is given below

LOAD DATA INFILE 'mytempfile' INTO TABLE feeds

如何在 mysql 中增加我的最大上传文件大小?请指教..

How can i increase my maximum upload file size in mysql? Please advise..

推荐答案

我得到了答案.我可以将大尺寸的 zip 文件拆分为小尺寸的多文件.如果我们加载大文件数据库转储问题发生.它对我很好.干杯.

I got a answer. i can split big size of zip files into small size of multi files. if we load large size of file database dump problem occurred. its working great with me. Cheers.

这篇关于如何增加 LOAD DATA INFILE 查询的最大上传文件大小?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！