Re: [webmin-l] MySQL limits for specific users + backup

[Jamie C. <jca...@we...>]

On Mon, 2005-09-12 at 20:16, Terry Allen wrote:
> Hi again,
> 	It's been a while since I needed to make any specific 
> changes, but I have a client who needs to make a scheduled backup of 
> their MySQL database, which I have set up & also back them up at 
> will. I think my easiest option is to use Webmin to do this, however, 
> I haven't been able to figure out how to achive the end result I need 
> & wonder if anyone could assist with this (or tell me if it can't be 
> done using Webmin)
> 	I created a webmin user who only has access to the MySQL 
> module, plus I have set the user so nothing can be changed etc... on 
> the database - what I need is this:
> 
> When the user logs in to the MySQL module, I would like them to have 
> only a 'backup database' button available, nothing else, so I can 
> preset the name for the backup, as well as the location & they only 
> need to click the 'backup' button to back their database up.

You might be better off doing this with a button in the Custom Commands
module. It could run something like :

mysqldump -U fred -phispassword databasename >output.sql

> 	Secondly, what do I need to add to the backup command so it 
> is exported as a .csv file? I could see no option to do this within 
> Webmin, so perhaps it isn't currently possible, or maybe I need to 
> add a flag.
> 	Any ideas would be greatly appreciated.

As far as I know, mysql doesn't support a CSV backup format. You'd have
to write a little Perl script to generate something like that..

 - Jamie