On Friday 07 March 2003 13:30, Lakshminarayna U wrote: > I want to archive and restore a table in MySQL using SQL > statements. I have tried this by logging in as root user and could > do it fine. But when I created a new user and login as him, I am > not able to archive nor restore. I have granted him all the > rights. Is there any specific rights need to be given to the user > to archive and restore? I can't use root user in my application.
Depends on what do you want to use for table backup. To use mysqldump you need a SELECT privilege. If you want to use SELECT .. INTO OUTFILE user must have SELECT and FILE privileges. If you want to use mysqlhotcopy you should have SELECT and RELOAD privileges. -- 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
