Ubuntu
mysql-dfsg-5.0 package

mysqldump gets error: 1

Asked by firefoxtester

I'm trying to run this command:

$ mysqldump -u root -pxxxxx -h localhost --fields-terminated-by=, --tab="/home/chiefinnovator/netflix_prize/try_this_at_home" --tables netflix ratings > ratings.txt

But I keep getting this error:

mysqldump: Got error: 1: Can't create/write to file '/home/chiefinnovator/netflix_prize/try_this_at_home/ratings.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

I tried changing the permissions on that folder to no avail. Do I need to do something with SELinux? Do I have SELinux? Why is this so hard.

Please help me!

Question information

Language:
English Edit question
Status:
Expired
For:
Ubuntu mysql-dfsg-5.0 Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
firefoxtester (gregpinero) said : 		#1

Here's something from my log that may provide some clues:

Jun 29 12:57:06 blackpearl kernel: [394041.754063] audit(1214758626.892:6): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/home/chiefinnovator/netflix_prize/try_this_at_home/ratings.txt" pid=15925 profile="/usr/sbin/mysqld" namespace="default"

Revision history for this message
firefoxtester (gregpinero) said : 		#2

Well outputting to /tmp works for now, but that's pretty lame I can't output to a directory of my choosing even with 777 permissions. I'd still love to know what's going on?

chiefinnovator@blackpearl:~$ sudo mysqldump -u root -pxxxxxx -h localhost --fields-terminated-by=, --tab="/tmp" --tables netflix ratings > ratings.txt

Revision history for this message
Launchpad Janitor (janitor) said : 		#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.