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 <wha...@bfs.de> > >> >> muhammad subair schrieb: >>> On Thu, Jul 23, 2009 at 10:10 PM, walter harms <wha...@bfs.de> 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=xwei...@gmail.com >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
