hello!
I hope someone out there is able to help me - this problem has got me tearing my hair out!
I've been trying to upload a very big, comma-delimited .txt file into a table. However, i keep getting this error message at the end:
1148 - The used command is not allowed with this MySQL version
I've done a million searches trying to find out how to fix this but as i'm a complete newbie i'm not quite managing to understand exactly what it is that i need to do. I have installed sql on my computer successfully i think (i get the green traffic light at the bottom of my screen). and i know everyone keeps saying i need to put local-infile=1 into my my.ini file so i've done that, but i still get the error message. At the moment my my.ini file looks like this:
#This File was made using the WinMySQLAdmin 1.4 Tool
#13/08/2004 12:51:33
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
local-infile=1
basedir=C:/mysql
#bind-address=169.254.101.152
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
local-infile=1
Server=C:/mysql/bin/mysqld-nt.exe
user=myusername
password=mypassword
I don't suppose there's anyone out there who could imagine they're talking to a 5 year old and explain to me in very basic language what i need to do to get past this bloody message? please help me! i'm going insane!!!!
lizzyd
