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

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