Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
14 users online | 14 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (460355 views)
- Error no. 2003: Can't connect... (375978 views)
- SQLyog Version History (229184 views)
- Error no. 1045: "Connection denied..." (190258 views)
- Error No. 2005: Unknown MySQL server host... (172278 views)
- Error no. 1251: "Client does not support authentication..." (160697 views)
- Can I use SQLyog with the WINE Windows emulator ... (152354 views)
- What is HTTP-tunneling? (127297 views)
- What Is SSH and SSH-tunneling? (98649 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (96595 views)
Latest FAQs
- SQLyog Version History (2014-06-08 10:22)
- I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
- About CHUNKs and BULKs (2014-01-09 11:53)
- SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
- Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)
Sticky FAQs
ID #1181
Data get truncated when importing a large CSV-file.
SQLyog is is able to import data CSV files to MySQL using two different techniques:
1) using the Microsoft ODBC Text driver (that ships with every windows verson) for connecting to the file.
2) using MySQL "LOAD DATA LOCAL INFILE ..." syntax
The ODBC Text driver has limitations with very large data sets/files:
1) Tables are limited to a maximum of 255 fields/columns.
2) Field/column names are limited to 64 characters, and field/column widths are limited to 32,766 characters.
3) Records/rows are limited to 65,000 bytes in total.
Please refer to: msdn.microsoft.com/en-us/library/ms716438%28VS.85%29.aspx
If your file has data exceeding either of the above-mentioned limitations we cannot import all data from the file as we simply do not receive all the data from the ODBC-driver.
Consider the options instead then:
1) Avoid CSV-files. Try to import directly from the application who generated the CSV-files instead. It is possible if an ODBC-driver for that application (or its datastore) exists.
2) Import data using LOAD DATA syntax. The disadvantage with this option is that the table structure must be created manually in advance.
Categories for this entry
Tags: -
Related entries:
- SQLyog Version History
- I have problems with importing CSV data
- Introduction to the 'SQLyog Job Agent' (SJA)
- How do connection names resolve to ip's?
- How do I execute a job with SJA with a single mouse-click?
You can comment this FAQ