This is really a Rails question, I suppose, but in context its a Radiant problem
John graciously supplied us with a script <tt>script/set-up_database</tt> that preloaded some templates, snippets and pages. Its not quite a Rake task, but ... it does load content from YAML files. Now Rake out of the box can dump and load the schema and dump the database structure to a SQL file. But what I need to do is dump a Sqlite3 database and restore a MySQL database. Its like this: I've put together a small site for a local club (aka non-profit) which has about 100 members. The idea is that the 'board' can keep it up to date since the kid who volunteered to run the site for them has fallen down on the job. I've run up a demo on my laptop and they are happy with that. I now have to put up the live site on an ISP. This means dumping the content of the database on my laptop (Sq lite3) and restoring it on the ISPs server (MySQL) I'm a little surprised that Rails doesn't have this. Or am I mistaken? What I've found on the web tells me it isn't. I did find code that has different patches for Sqlite, MySQL and Postgress, but doesn't work with Sqlite3. http://www.realityforge.org/articles/2005/12/14/dumping-database-to-yaml-fixtures http://www.realityforge.org/files/dump_fixtures.rake http://www.bigbold.com/snippets/posts/show/3393 Am I missing something 'cos I'm not a RoR coder? I would have thought this a common and obvious task. -- Never criticise somebody until you have walked a mile in their shoes. That way, they're a mile away, and you have their shoes. _______________________________________________ Radiant mailing list Post: Radiant@lists.radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
