Home / ubuntu / Questions / 622177
Accepted
Anonymous Platypus
Asked: 2015-05-11 21:59:43 +0800 CST

Unable to dump mysql tables to local

  • 772

I was trying to dump my mysql table using the below command

mysqldump --tab=/home/username/Desktop/basic/ --user myusername -p mysql user;

But it returned an error saying

mysqldump: Got error: 1: Can't create/write to file '/home/username/Desktop/basic/user.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

I use Ubuntu 14.04. I have tried to disable apparmor as explained here. But still the error exists. Any other solutions?

Edit

I get the .sql file but not the .txt file

14.04

1 Answers

  1. Best Answer

    First make sure that mysql can write to /home/username/Desktop/basic/; if you're planning to do multiple dumps in the same directory, a pretty clean way to do it would be to set the ownership of the folder to mysql and to set the SGID permission on the folder (thanks to muru for this suggestion): this way mysqldump will be able to write to the folder, but new files will inherit the the group from the parent directory; this has the advantage of leaving to your user read, write, and execute permissions on the dumps. 

    sudo chown mysql /home/username/Desktop/basic/ && sudo chmod g+s /home/username/Desktop/basic/

    Additionally, make sure that there isn't any file named user.sql or user.txt present in the target directory before issuing the command; if either mysql can't write to the target directory or a file with the same name of one of the expected output files exists before issuing the command, mysqldump is going to fail.

    • 2