On Thu, Oct 18, 2001 at 03:45:58PM -0500, duncan wrote:
> Hello-
>
> Im trying to setup a mysql backup perl script that will dump the
> databases... I want to give it a `backup` user with a backupuser
> password... What privledges are needed by a user to dump tables?
The databases you want 'backup' to have select-only access to has
to be listed in the mysql root users 'db' table. Like:
insert into db (host,db,user,select_priv) values ('localhost','backupdb',
'backup','Y');
and flush privileges;
> the password will be in a plaintext script... and i want to keep the
> perms low to reduce the risk.
Have you looked at mysqldump that comes with mysql?
--
Thomas Eibner <http://thomas.eibner.dk/> DnsZone <http://dnszone.org/>
mod_pointer <http://stderr.net/mod_pointer>