Is there a recommended way of creating a new database from within
rails? (or is the recommended way not to do it?)
In my application I wish to be able to create a new database structure
for each user who signs up, but there doesn't seem to be a way of doing
this using ActiveRecord.
At present I can create it by establishing a new connection to the
dbh = Mysql.real_connect(...)
then doing something like this
dbh.query("create database " + database_name)
which works fine with my windows machine (with mysql-win gem installed)
but not my linux server.
Any advice is greatly appreciated.