#!/usr/local/bin/raven 
 
# connect to mysql as "backup" user, which should be configured with only 
# SELECT, SHOW DATABASES, and LOCK TABLES privileges. 
'mysql://backup:@localhost/mysql' open as $mysql 
 
# list all databases. 
'SHOW DATABASES' $mysql query as $rs 
 
# loop over each database dumping it to /var/backup/mysql/<database>.sql 
$rs records each 'Database' get as $database 
	$database dup 'mysqldump -Q -u backup %s >/var/backup/mysql/%s.sql' format shell drop