About backup ALL -- may be this can be made as stored procedure?
with logic
BACKUP_ALL()
curs = SHOW DATABASES
for each db in curs
USE DATABASE db_name
BACKUP
this is pseudo - code.
Great minds think alike
This is EXACTLY what I did, which ultimately ended up in sheer despair subsequently followed by a posting here in this thread.
Aforementioned "USE DATABASE" is simply not working when targeting registered but closed databases!
As there is no known way (for me) to open targeted databases from SQL (which is, BTW, the only way to implement the stored procedure on the server, right?), it effectively became a show stopper...
Maybe we can add parameter db_name to BACKUP DATATABASE db_name[\quote]
This would save the day, yes, but it must be able to work on closed databases as well. And the same goes for DIAGNOSE, DEFRAGMENT, REINDEX and COMPACT. These are typical tasks best suited to be implemented as an event owned by a Master but targeting everything else (i.e. whole database collection residing on a server administered by a Master).
PS: corrected botched formatting of my previous entry again, third time a charm?