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.
Please help
Thanks in advance!
Lak
--------------------------------------------------------------------- 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
