##Backup

$KCODE = "UTF8"

require '/Users/user/work/breakout/lib/breakout/mysql_backup'

b = Breakout::SpaceBackup.new(:host => 'localhost', :user => 'root', :password => '', :db => 'breakout_development')

  f = File.open("cvrT7EU8er3A9dabTJSnCg.bak", "w")
  b.dumper = Proc.new {|key, data| f.write "#{key}, #{data}\n" }
  b.find_space("New Spacetwi")
  f.close






##Restore

$KCODE = "UTF8"

require '/Users/user/work/breakout/lib/breakout/mysql_backup'

b = Breakout::SpaceBackup.new(:host => 'localhost', :user => 'root', :password => '', :db => 'breakout_development')

for space in ['cvrT7EU8er3A9dabTJSnCg']
  f = File.open("#{space}.bak")
  g = File.open("#{space}.sql", "w")
  b.sql_dumper = Proc.new {|sql| g.write "#{sql}\n" }

  b.restore do
    line = f.gets

    if line
      line.chomp!
      line.split(',', 2)
    end
  end

  f.close
  g.close
end