I have a user on my system with a normal shell account, and a normal MySQL account that owns a database. How can this unpriviledged user back up his database using mysqlhotcopy? I've run into two problems: 1. He has to login as the MySQL root user in order to be able to execute "FLUSH TABLES". 2. The MySQL data files for that database are not readable by him. I've tried to chgrp those files to his group and chmod g+r them, which allows him to read those files. But, they spontaneously revert back to the mysql group for some reason! (Why?) And new tables created in his database have the group of mysql. Can I get around the problems from #1 and #2 somehow? I realize that I could just use "mysqldump" to back up the tables, but this takes a lot longer since my database has over 70 MB of data in it. --------------------------------------------------------------------- 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
