Neil,
From what I understand, galaxy uses sqlalchemy for all its databse operations regardless of the database engine that is actually hosting the data.
I suspect that galaxy uses a default sqlalchemy connection string by default even when you don't specify one, which points to databases/universe.sqlite. I also suspect that you can modify the location of the database by doing the following in universe_wsgi.ini
database_connection = sqlite:////absolute/path/to/foo.db
Let us know if that works.
Regards,
Bioinformatics Application Developer Agriculture and Agri-Food Canada | Agriculture et Agroalimentaire Canada KW Neatby Bldg | éd. KW Neatby 960 Carling Ave| 960, avenue Carling Ottawa, ON | Ottawa (ON) K1A 0C6 E-mail Address / Adresse courriel: Iyad.Kandalaft@agr.gc.ca Telephone | Téléphone 613- 759-1228 Facsimile | Télécopieur 613-759-1701 Government of Canada | Gouvernement du Canada
From: Neil.Burdett@csiro.au To: galaxy-dev@lists.bx.psu.edu Subject: [galaxy-dev] Move galaxy/database (SQLite) to a new location Message-ID: 25BF49C282C04548A60517FFB251C20D2F737E67@exmbx03-cdc.nexus.csiro.au Content-Type: text/plain; charset="iso-8859-1"
Hi, we have the default setup for galaxy hence using SQLite database and all data store in the same location as the galaxy install.
In Universe_wsgi.ini file there is an entry
# Dataset files are stored in this directory. #file_path = database/files
How do we go about moving the database to a new location? We don't really want to delete the data already present in the database just move it to a new location. If we modify file_path and restart wouldn't that cause further problems as some data would be in one location and other in another location. Is it even possible to move the database once it has been created and has data in it?
Thanks
Neil