MySQL 1148 error
trying to you the 'load data infile' technique used in the mySQL tutorial, my windows XP machine returns an error 1148 (command not supported by this version).
What I am trying to do is 'import' a .txt file with table data as the tutorial shows.
I want to learn mySQL from the monitor and not through a GUI, so I would like to find a way to do this.
this has been a feature since version 3.23.49, see Security issues with LOAD DATA LOCAL
you have two choices:
either start mysql with the option --local-infile=1
e.g. c:\mysql\bin> mysql --local-infile=1
or add these lines to your 'my.cnf' file:
hope this helps :)