MySQL Forums
Forum List  »  Newbie

Can't start MySQL server with "local-infile" - URGENT
Posted by: m.l.sanders
Date: April 07, 2005 04:48AM

Running: MySQL 3.23.54; PHP 4.3.10; PHPMyAdmin 2.5.1
on a Cobalt RAQ550

Can't use the "Insert data from a textfile into table" facility in PHPMyAdmin, presumably because MySQL hasn't been configured so that 'local-infile=1'.

I expect that if I shutdown mysqld, and restart it like this 'mysqld start --local-infile=1' the configuration shoudl be ok.
However, the insert still doesn't work - same error - and when I check the MySQL variables (using 'mysqladmin variables') the 'local-infile' variable isn't even listed.

There is no 'my.cnf' file anywhere on the server, so I don't think mysqld is using a config file.

Please help: am I trying to start the server with the local-infile enabled incorrectly, or is there more I should be doing.

Options: ReplyQuote


Subject
Written By
Posted
Can't start MySQL server with "local-infile" - URGENT
April 07, 2005 04:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.