Import External Data Size Limit?

[bkelley]

Hi Peter, I have a number of .CSV files that I need to import into my MYSql databases (all into the same employees table). They are large 4-6 GB; is there a limit on the “Import External Data” function file size? Is that the tool that you would suggest is best for this task?

thanks,

Brian

[Khushboo]

Hi Bkelley,

There are two tools through which you can import CSV Files in SQLyog:

1)Import External Data

i) Go to Powertools –> “Import External Data”

ii)Select Type of Source as “CSV” give CSV folder path

“is there a limit on the “Import External Data” function file size?”

No, there is no limit on file size in Import External Data. You can import large files in GB.

2)Import CSV data using LOAD LOCAL

Select a Table –> Right Click –> Import CSV using LOAD LOCAL … “

Here also you can import large CSV files.

You can use any of these two tools to import large CSV Files to a table.

Please See the screenshots and read these FAQs:

http://webyog.com/faq/content/17/110/en/i-have-a-large-%23-of-csv-files-can-sqlyog-import-them-all-in-one-operation.html

http://webyog.com/faq/content/28/73/en/i-have-problems-with-importing-csv-data.html

Regards,

Khushboo

[peterlaursen]

Note that if you have the file in the same folder you can actually import them all with one job with 'Import External Data Tool'.  But you will need to change some settings from default values.

[Author]

Posts