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

Bradley Giesbrecht brad at pixilla.com
Mon May 4 07:11:00 PDT 2009

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"


More information about the macports-users mailing list