At 16:21 +0200 3/30/02, Okan CIMEN wrote:
>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'