Greetings,
I have an *extremely* annoying problem with MySQL in that whenever I try to use DISTINCT or GROUP BY in a SELECT statement I get an error saying:
ERROR 1: Can't create/write to file '/Users/nick/Library/mysqltemp/#sqlc9_18f_0.MYI' (Errcode: 13)
As you can see, I've changed the temp directory for MySQL from its default, but this hasn't changed a thing.
Any suggestions would be *MUCH* appreciated!
Thanks in advance,
Nick Mason
I have an *extremely* annoying problem with MySQL in that whenever I try to use DISTINCT or GROUP BY in a SELECT statement I get an error saying:
ERROR 1: Can't create/write to file '/Users/nick/Library/mysqltemp/#sqlc9_18f_0.MYI' (Errcode: 13)
As you can see, I've changed the temp directory for MySQL from its default, but this hasn't changed a thing.
Any suggestions would be *MUCH* appreciated!
Thanks in advance,
Nick Mason