Jim McAtee wrote:
Is it recommended to create a MySQL user for doing backups? Running
mysqldump from a script, the username and password will have to be
embedded in plain text.
If I were to create a MySQL user expressly for doing nightly backups
what are the minimum permissions needed?
You don't need to create a special MySQL user for backups. If you like,
you can create a Linux account that only you know the password to, and
then make sure the backup scripts is only readable by you ( root will
also be able to read it ). Or just run the backup script as root, and
then root can only read it ( you have to set the correct permissions
here too of course ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
