From: walter harms Date: July 27 2009 10:46am Subject: Re: mysqldump and access rights List-Archive: http://lists.mysql.com/mysql/218294 Message-Id: <4A6D858B.6070205@bfs.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 corresponding select statements ? re, wh peng yao schrieb: > 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 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 >>>> >>>> - >>> >>> Hi, you can use this in Linux >>> >>> *# chown user:user /path/to/file.txt* >>> >> hi, >> yes i am aware of that but it would be more helpful for me if >> mysqldump uses the "right" ownership in the first place. >> >> re, >> wh >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=xweiyao@stripped >> >> >