Thanks to the helpfull message of John, I am now able to backup and
retrieve my users from a galaxy to another without using directly the
database (by using the galaxy model and sql alchemy).
I am trying to do the same thing for workflows, libraries, datasets and
The repository is here:
Any interest/participation is welcome.
2014-11-21 17:50 GMT+01:00 John Chilton <jmchilton(a)gmail.com>:
This is a tough question - I suspect it will be difficult no matter
how you proceed. The API objects don't map 100% directly to database
objects and may not have complete coverage - but using the database
directly will require one to learn a lot of Galaxy's data model I
A middle ground - would be to just use the Galaxy code and ORM layer
without running a Galaxy server (see scripts/db_shell.py for
My gut tells me it is probably be easiest (least difficult anyway) to
target the database directly - but this could be wrong.
On Wed, Nov 19, 2014 at 6:21 AM, Rémy Dernat <remy.d1(a)gmail.com> wrote:
> I would like to create a code to backup and migrate(*) galaxy datas,
> on the api and/or with the script I did here:
> To do that, I would use the galaxy model, to retrieve everything in the
> one and recreate everything in the new one.
> However, I would like to be able to do that without my web server
> That is to say, a "cold" migration to avoid any current task to write
> additionnal things into the database. Obviously, that is a problem for
> api because this one use the web server.
> Could you give some advice to do that ? Should I recreate a code from 0 ?
> Could I use the code in the api ? Is there a way to create a code that
> use the api differently (recreate a copy of the api without the web
> Kind regards,
> (*) this is important; that means you could import data from an old
> to a recent one (or the opposite); a simple backup of files and a dump of
> the db is not enough.
> Please keep all replies on the list by using "reply all"
> in your mail client. To manage your subscriptions to this
> and other Galaxy lists, please use the interface at:
> To search Galaxy mailing lists use the unified search at: