I've got a directory, /var/www/someProject/backup/mysql, and I want the user mysql to write to it. Each time I try to write to it with the mysql user, I get a "can't read/write" error. Yet the directory is 777 as you can see here:
drwxrwxrwx 2 aUser users 4096 2010-03-17 17:14 mysql
I also tried to chown the directory to mysql:mysql, just like the home dir of the mysql user, but no luck, that changed nothing.
What am I doing wrong here? Or is the mysql user limited to his home dir in some other way in Ubuntu? Been bugging me for days now, this problem so any help greatly appreciated.