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
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
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
# 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