MySQL Forums
Forum List  »  Backup

Can't create/write to file '/var/lib/mysql/mysqldump_sql/Delimited-Text/admin_consult_p eriod.txt' (Errcode: 2) when executing 'SELECT INTO OUTFILE'
Posted by: dsdaaa fdsfds
Date: October 26, 2015 12:04AM

i want to Dumping Data in Delimited-Text Format with mysqldump,the data is from remote server,
my command is

time mysqldump --tab=/var/lib/mysql/mysqldump_sql/Delimited-Text --fields-terminated-by=, --fields-enclosed-by='"' --lines-terminated-by=0x0d0a consult --host=xxx.xxxx.xxxx.xx -u root -p

after type password,it tempt
mysqldump: Got error: 1: Can't create/write to file '/var/lib/mysql/mysqldump_sql/Delimited-Text/admin_consult_period.txt' (Errcode: 2) when executing 'SELECT INTO OUTFILE'

i have execute the directory Delimited-Text chmod 777 /var/lib/mysql/mysqldump_sql/Delimited-Text/
but the program still exists.

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't create/write to file '/var/lib/mysql/mysqldump_sql/Delimited-Text/admin_consult_p eriod.txt' (Errcode: 2) when executing 'SELECT INTO OUTFILE'
3962
October 26, 2015 12:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.