#!/usr/bin/env ruby### Ruby database backup script# (c) 2005 Seb Ruiz <me@sebruiz.net># Released under the GPL v2 licensedef getFilename( input )    puts input    date = `date +%Y%m%d`    i = 1    input = input + "." + date    original = input    # don't overwrite a previously written backup    loop do        file = File.dirname( File.expand_path( __FILE__ ) ) + "/" + input        if not FileTest.exist?( file )            return input        end        i = i + 1        newName = original + "." + i        input = newname    endendif $*.empty?() or $*[0] == "--help"    puts( "Usage: backupDatabase.rb saveLocation" )    puts()    puts( "Backup your Amarok database!" )    exit( 1 )enddestination = $*[0] + "/"unless FileTest.directory?( destination )    system("dcop", "amarok", "playlist", "popupMessage", "Error: Save destination must be a directory")    exit( 1 )endunless FileTest.writable_real?( destination )    system("dcop", "amarok", "playlist", "popupMessage", "Error: Destination directory not writeable.")    exit( 1 )endfilename = ""database = `dcop amarok script readConfig DatabaseEngine`.chomp!()case database    when "0" # sqlite        filename = "collection.db"        filename = getFilename( filename )        dest = destination + "/" + filename        puts dest        `cp ~/.kde/share/apps/amarok/collection.db #{dest}`    when "1" # mysql        filename = "amarokdb.mysql"        filename = getFilename( filename )        dest = destination + "/" + filename        puts dest        db   = `dcop amarok script readConfig MySqlDbName`.chomp!()        user = `dcop amarok script readConfig MySqlUser`.chomp!()        pass = `dcop amarok script readConfig MySqlPassword`.chomp!()        system("mysqldump", "-u", user, "-p", pass, db, "-r", dest);    when "2" # postgres        system("dcop", "amarok", "playlist", "popupMessage", "Sorry, postgresql database backups have not been implemented.")        exit( 1 )endsystem("dcop", "amarok", "playlist", "popupMessage", "Database backup saved to: #{destination}/#{filename}")