auto backup derby database in rails

Question

I am using gem 'activerecord-jdbc-adapter'. In my database.yml i am giving

adapter: jdbcderby

I want to take the auto backup of database after each hour. I did not find any way to take the derby database dump.

Kindly help me in taking derby database dump in rails. Thanks

Answer 1

I think you are looking for this

dblook -d 'jdbc:derby://127.0.0.1:3000/db/development;' -t users -o dump.sql