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."
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 s
FYI
After digging out some documentation ( RFM indeed ) it is all so simple in
DBD::mysql ...
As of version 3.23.49 LOCAL within LOAD DATA _may_ be disabled in the
_client_ library. By adding an option to the DSN-string within the connect
statement the function is re-enabled at the client side too
"adrian GREEMAN" <[EMAIL PROTECTED]> wrote:
> I have also read the manual section on this {as I should have
> done] to try and understand it
> and how to enable reading a local file - the discussion section
> seems confusing and confused.
>
> I tried following what others have done and
> modified
"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 wit
adrian GREEMAN wrote:
> I have also read the manual section on this {as I should have
> done] to try and understand it
> and how to enable reading a local file - the discussion section
> seems confusing and confused.
>
> I tried following what others have done and
> modified the ini file with set-v
Thanks for the advice - and your patience in giving it to me.
The recommended changes in the ini file worked (but only along
with removing the word local from the "load data local infile"
instruction) [since I have a localhost Apache server as testing
environment]
thanks again to those more knowle
I have also read the manual section on this {as I should have
done] to try and understand it
and how to enable reading a local file - the discussion section
seems confusing and confused.
I tried following what others have done and
modified the ini file with set-variable=local-infile=0
and with set
Please excuse a relative amateur worrying a problem.
I got a nice reply from Victoria Reznichenko yesterday on a
difficulty loading data from a text file. She said 4.0.12 had a
bug and, I as understood her answer, I should therefore enable
"load local infile".
Instead I uninstalled 4.0.12 and loa