At 17:24 +0200 3/30/02, Okan CIMEN wrote:
>Dear Paul,
>
>I have full privileges on the database.
FILE is a global privilege, not a database-specific privilege.
>
>mysql> show grants for username -> ;
>+---------------------------------------------------------------------------
>------------------------------+
>| Grants for username@%
>|
>+---------------------------------------------------------------------------
>------------------------------+
>| GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY PASSWORD
>'5d60c9f55c18d05c' WITH GRANT OPTION |
>| GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'%' WITH GRANT OPTION
>|
>+---------------------------------------------------------------------------
>------------------------------+
>
>And when I run the mysqldump, it creates the table structure files on my
>box, not at the server.
Right. Those are the *.sql file. The data files (*.txt files) are
created on the server -- which is why you need the FILE privilege.
Yes, this is confusing, but that's how mysqldump behaves.
>Thanks for your answer
>Okan
>
>
>2 rows in set (0.00 sec)
>
>----- Original Message -----
>From: "Paul DuBois" <paul@stripped>
>To: "Okan CIMEN" <okan.cimen@stripped>; <mysql@stripped>
>Sent: Saturday, March 30, 2002 4:42 PM
>Subject: Re: mysqldump problem
>
>
>> At 16:21 +0200 3/30/02, Okan CIMEN wrote:
>> >Hello,
>> >
>> >When I try to get the remote dump of a database, I get the table
>structure
>> >without any failure but it is not able to get the table data. Has anyone
>of
>> >you came over to this problem before?
>> >Here is what I have tried:
>>
>> -T requires that you have the FILE privilege, and you probably don't
>> -T isn't that useful for a remote server, anyway. The *.txt files are
>> written on the server host, not the client host.
>>
>> >
>> >H:\>c:\mysql\bin\mysqldump -T "c:\mysql\batch\dump\new_dump" -f -l -v -u
>> >username -ppassword -h 192.168.51.120 databasename
>> >-- Connecting to 192.168.51.120...
>> >-- Retrieving table structure for table employee...
>> >-- Sending SELECT query...
>> >c:\mysql\bin\mysqldump: Got error: 1: Can't create/write to file
>> >'c:\mysql\batch\dump\new_dump\employee.txt' (Errcode: 2) when executing
>> >'SELECT INTO OUTFILE'
>> >......
>> >......
>> >
>> >Regards
>> >Okan
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <mysql-thread104618@stripped>
>> To unsubscribe, e-mail <mysql-unsubscribe-okan=cimen.org@stripped>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread104619@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
