Re: Help importing a text file via phpmyadmin
| From: | John W. Holmes | Date: | Tue, 06 Apr 2004 15:20:11 +0000 |
| Subject: | Re: Help importing a text file via phpmyadmin | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-182484@lists.php.net to get a copy of this message | ||
From: "Brian Dunning" <brian@briandunning.com>
> I'm trying to use phpmyadmin's "Insert data from a textfile into table"
> function. I've done this before many times, exactly the same way, and
> never had a problem. But today I'm getting:
>
> #1148 - The used command is not allowed with this MySQL version
>
> Is there a common cause for this error? I find little helpful info in
> the phpmyadmin documentation. Any ideas appreciated... :)
I think you need FILE permission to use LOAD DATA INFILE queries. The user
you're connecting with must not have that permission.
---John Holmes...