mysqldump and access rights

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://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysqldump and access rights

--001636aa2c4c895011046f6b45e5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

# 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 ?
>
> re.
> wh
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=xweiyao@gmail.com
>
>

--001636aa2c4c895011046f6b45e5--

Re: mysqldump and access rights

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=gcdmg-mysql-2@m.gmane.org

Re: mysqldump and access rights

--0016364ee4e657258f046fa98fca
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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@gmail.com
>
>

--0016364ee4e657258f046fa98fca--

Re: mysqldump and access rights

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@gmail.com
>>
>>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org