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" <[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 --------------------------------------------------------------------- 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
