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 histories.
The repository is here: https://github.com/remyd1/galaxy_backup
Any interest/participation is welcome.
Best Regards Remy
2014-11-21 17:50 GMT+01:00 John Chilton firstname.lastname@example.org:
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 suspect.
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 instance).
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 email@example.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
(*) 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: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/