On Sunday 22 December 2002 05:16, Dr. Poo wrote: > On Friday 20 December 2002 08:42 am, Victoria Reznichenko wrote: > > On Thursday 19 December 2002 21:29, Arun kumar R wrote: > > > I want to run mysqldump through a batch process, in > > > order to do that what prive do i need to give to the > > > user. It will be running as a cron job, i don't want > > > to give any creation or deletion authorization. Your > > > help will be greatly appreciated. > > > > You should have SELECT privileges. > > I'm chris, HI! > > After reading this thread, i got the question of: What privileges would a > user need to have for mysqlhotcopy to work correctly.
What about checking the MySQL manual? http://www.mysql.com/doc/en/mysqlhotcopy.html "To be able to execute mysqlhotcopy you need write access to the backup directory, the SELECT privilege for the tables you are about to copy and the MySQL RELOAD privilege (to be able to execute FLUSH TABLES). " -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
