Dear Paul, I have full privileges on the database.
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. Thanks for your answer Okan 2 rows in set (0.00 sec) ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Okan CIMEN" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
