I've just added the yaml_db plugin[1] to trunk:

<http://dev.rousette.org.uk/changeset/880>

At least with SQLite3 (I haven't tested with MySQL) it works very  
nicely for dumping the schema and database contents to a yaml file,  
then loading the schema and contents again into a db. The authors say  
that you can use it to port your database contents from one adapter to  
another (mysql to SQLite3, for example), but I haven't tried that.

Note that it was throwing errors until I commented out a block at the  
end specific to PostgreSQL dbs. If you are using Postgres, you need to  
comment those lines.

I think it would be good to leverage this plugin for the YAML export  
function in the web UI, which would then make it easy for people to  
(via the command line) import the resulting data.yml file to recreate  
their db or move between adapters.

[1] http://opensource.heroku.com/

cheers,
bsag

-- 
but she's a girl - the weblog of a female geek
http://www.rousette.org.uk
[EMAIL PROTECTED]
_______________________________________________
Tracks-discuss mailing list
[email protected]
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

Reply via email to