MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


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'
3811
dsdaaa fdsfds
October 26, 2015 12:04AM
Re: Can't create/write to file '/var/lib/mysql/mysqldump_sql/Delimited-Text/admin_consult _period.txt' (Errcode: 2) when executing 'SELECT INTO OUTFILE'
1512
Rick James
November 29, 2015 11:40AM


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.