"adrian GREEMAN" <[EMAIL PROTECTED]> wrote: > When I try to import a text file with new data for an existing > table I get the error "1148 - the used command is not allowed > with this MySQL version."
If you use LOAD DATA LOCAL you should enabled it with local-infile option. > > I have tried with both PHPMyAdmin2.3 and with MySQLFront 2.5. > Both these GUI programmes have an "import from text file" command > which I have used successfully several times to add entries to > this table before - running just this MySQL version. I have > structured the data in the text file in just the same format as > previously. > > Both these programmes are connecting to the database successfully > now and will display the contents of the existing table data and > strcutre of the database etc (despite an earlier connection > problem which seems to have been solved spontaneously). > > But both now deliver exactly this error message (and therefore I > assume it is MySQL and not the interface programmes which is > doing it). I cannot see that I am doing anything different. > > I have MySQL 4.0.12 on Windows ME PC with a local Apache server > and PHP. There was a bug in v4.0.12 for Windows: binary packages were compiled without --enable-local-infile. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
