Migrate CakePHP sessions from MySQL to Redis.

mysql-to-redis.rb

require 'rubygems'
require 'mysql'
require 'redis'

# start your engines
mysql = Mysql.new('host', 'username', 'password', 'database')
redis = Redis.new('host' => '', 'port' => , 'password' => '')

sessions = mysql.query("select * from cake_sessions where expires > '#{Time.now.to_i - 10800}' LIMIT 10")

sessions.each_hash do |session|
  # test the string
  # puts "SETEX \"PHPREDIS_SESSION:#{session['id']}\", 10800, #{session['data']}"
  
  # load each session into Redis
  redis.setex("PHPREDIS_SESSION:#{session['id']}", 10800, session['data'])
end

mysql.close