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

mysqldump and access rights

2009-07-23 Thread 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 ? re. wh -- MySQL General Mailing List For list archives: http://list