- 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
- 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
39 users online | 39 Guests and 0 Registered
- I get error 1130 "Host is not allowed to ... (364641 views)
- Error no. 2003: Can't connect... (255046 views)
- SQLyog Version History (178533 views)
- Error no. 1045: "Connection denied..." (133619 views)
- Error No. 2005: Unknown MySQL server host... (105234 views)
- What is HTTP-tunneling? (91477 views)
- Can I use SQLyog with the WINE Windows emulator ... (87352 views)
- Error no. 1251: "Client does not support authentication..." (79047 views)
- What Is SSH and SSH-tunneling? (64381 views)
- The "DELIMITER" command does not have effect. Why is ... (57830 views)
- 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)
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.
- 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