I'm sure this has been covered somewhere but I haven't been able to find it on the wiki or by searching the list archives. Can I, and if I can, how do I, migrate all user accounts from a previous local Galaxy development install to a new production one (a brand new install in a separate location on the same machine), preserving account info, workflows, histories, data, etc.?
If this can be done, can it be done selectively, i.e., for only specified users?
Thanks for any help offered,
Dean A. Snyder Senior Programmer/Analyst Center for Inherited Disease Research (CIDR) Johns Hopkins School of Medicine Bayview Research Campus 333 Cassell Dr, Triad Bldg, Suite 2000 Baltimore, MD 21224 cell:717 668-3048 office:410-550-4629 www.cidr.jhmi.edu
Dean Snyder wrote:
I'm sure this has been covered somewhere but I haven't been able to find it on the wiki or by searching the list archives. Can I, and if I can, how do I, migrate all user accounts from a previous local Galaxy development install to a new production one (a brand new install in a separate location on the same machine), preserving account info, workflows, histories, data, etc.?
Hi Dean,
What type of database are you using (Postgres, MySQL, SQLite)?
--nate
If this can be done, can it be done selectively, i.e., for only specified users?
Thanks for any help offered,
Dean A. Snyder Senior Programmer/Analyst Center for Inherited Disease Research (CIDR) Johns Hopkins School of Medicine Bayview Research Campus 333 Cassell Dr, Triad Bldg, Suite 2000 Baltimore, MD 21224 cell:717 668-3048 office:410-550-4629 www.cidr.jhmi.edu
galaxy-dev mailing list galaxy-dev@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev
Nate Coraor wrote at 11:41 AM on Friday, December 17, 2010:
What type of database are you using (Postgres, MySQL, SQLite)?
SQLite, for now.
Dean A. Snyder Senior Programmer/Analyst Center for Inherited Disease Research (CIDR) Johns Hopkins School of Medicine Bayview Research Campus 333 Cassell Dr, Triad Bldg, Suite 2000 Baltimore, MD 21224 cell:717 668-3048 office:410-550-4629 www.cidr.jhmi.edu
Dean Snyder wrote:
Nate Coraor wrote at 11:41 AM on Friday, December 17, 2010:
What type of database are you using (Postgres, MySQL, SQLite)?
SQLite, for now.
I'd recommend against putting SQLite into production since it handles concurrency very poorly, and converting to another database will become more of a hassle over time.
That said, the database is a file at:
galaxy-dist/database/universe.sqlite
The data is in a directory named:
galaxy-dist/database/files/
These can be copied or moved to the new production server instance.
--nate
Dean A. Snyder Senior Programmer/Analyst Center for Inherited Disease Research (CIDR) Johns Hopkins School of Medicine Bayview Research Campus 333 Cassell Dr, Triad Bldg, Suite 2000 Baltimore, MD 21224 cell:717 668-3048 office:410-550-4629 www.cidr.jhmi.edu
galaxy-dev@lists.galaxyproject.org