Re: mysqldump and access rights

2009-07-27 Thread walter harms
ok, i see now the resultings files are owned by mysql. every file has the same user granted, but the wrong one since i can not chown user.group * as normal user. So far i see it is the same problem as with "select into outfile" Is there a fancy trick for mysqldump so i will create the correspondi

Re: mysqldump and access rights

2009-07-26 Thread peng yao
you also can do this:#sudo -u mysql "mysqldump command" or #su - mysql -c "mysqldump command" 2009/7/24 walter harms > > > muhammad subair schrieb: > > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote: > > > >> Hi list, > >> i use mysqldump --tab to create database dumps. this will prod

Re: mysqldump and access rights

2009-07-24 Thread walter harms
muhammad subair schrieb: > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote: > >> Hi list, >> i use mysqldump --tab to create database dumps. this will produce txt and >> sql files. >> the resulting sql files is owned by the user but the resulting datafile is >> owned by mysql.mysql >> is

Re: mysqldump and access rights

2009-07-23 Thread peng yao
# chown mysql.mysql datafile 2009/7/23 walter harms > Hi list, > i use mysqldump --tab to create database dumps. this will produce txt and > sql files. > the resulting sql files is owned by the user but the resulting datafile is > owned by mysql.mysql > is there any way to change that ? > > r