I've been trying to import text files into MySQL, but I can't get it to work. I'm new to MySQL and am still getting familiar with it, so perhaps I'm missing something. I'm using the LOAD DATA LOCAL command but I keep getting error 1148 "The used command is not allowed with this MySQL version." Now from reading the information in the docs section (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD DATA LOCAL is sometimes disabled for security reasons, and that there are two ways around this. I've tried both ways but it doesn't seem to work. I tried using the command --enable-local-infile but apparently that's only compatible with version 3.23.48 and before, and we have 3.23.49. Is there something else I should do? Can anyone help me please? Thanks so much!
Christy Roberts Technical Project Lead iMIRADOR.com Inc. St. John's, Newfoundland Tel: 709.737.4485 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
