Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.


Ispirer SQLWays Database Migration Software

Importing data to MySQL 4.0.x using the LOCAL DATA INFILE command (LOCAL keyword - The used command is not allowed with this MySQL version)

There are some specific issues regarding using the LOCAL keyword in LOAD DATA INFILE command in MySQL 4.0.x. The LOCAL keyword allows loading data from the client, otherwise the data must be located on the server.

In MySQL 4.0.x LOCAL will only work if MySQL server was started with --local-infile=1.

In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): "The used command is not allowed with this MySQL version".


Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.