This is really a Rails question, I suppose, but in context its a Radiant
problem
John graciously supplied us with a script
script/set-up_database
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
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.