List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 30 2002 4:47pm
Subject:Re: mysqldump problem
View as plain text  
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

Thread
mysqldump problemOkan CIMEN30 Mar
  • Re: mysqldump problemPaul DuBois30 Mar
    • RE: mysqldump problemkaps31 Mar
  • Re: mysqldump problemOkan CIMEN30 Mar
    • Re: mysqldump problemPaul DuBois30 Mar
RE: mysqldump problemEgor Egorov1 Apr