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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
