(MySQL Error 1148) Enabling "LOAD DATA" queries...?

[Bradley Giesbrecht]

On May 3, 2009, at 5:43 PM, lists at mgreg.com wrote:

> Hi All,
>
> I'm having an issue with my install of "mysql5-devel @5.1.34".  I'm  
> trying to perform a "LOAD DATA" query, but I keep getting the  
> following:
>
> 		ERROR 1148 (42000): The used command is not allowed with this  
> MySQL version
>
> I've seen threads on enabling it, but I'm not sure where the  
> configuration files for the macports version of mysql lies, nor am I  
> sure about the best way to go about enabling it.
>
>
> Any ideas?

I use the mysql "source" function to source sql files. This may not  
work for you but I like this approach better for other reasons.

mysql> source "path/to/file.sql"


//Brad