As far as I know, there is no reference to the path of the datafiles in the 'database' (no matter whether it is SQLite, MySQL, or PostgreSQL) - may be the Galaxy developers can confirm this? If you wanna be on the safe side, work with a sym link, and don't change the entry in the 'universe_wsgi.ini' file. Hans-Rudolf On 06/04/2014 09:14 AM, Neil.Burdett@csiro.au wrote:
Thanks Hans-Rudolf, would this also be the same case for PostgreSQL database? i.e. we can move the database/files somewhere else , change universe_wsg.ini and all would be good? There is no link from the database to where the flat files are stored?
cheers Neil ________________________________________ From: Hans-Rudolf Hotz [hrh@fmi.ch] Sent: Wednesday, June 04, 2014 5:11 PM To: Burdett, Neil (CCI, Herston - RBWH) Subject: Re: [galaxy-dev] Move galaxy/database (SQLite) to a new location
Hi Neil
First a little comment: I strongly suggest to switch over to PostgreSQL.
Keep in mind that the 'database' (in your case the SQLite database) does not contain any data. The 'database' contains just the meta data and the users data which is required to run Galaxy.
"#file_path = database/files" is the location where the data sets are stored. You can copy the contents of "~/database/files/ to a new location and make the appropriate changes in 'universe_wsgi.ini' or set up a sym link.
I hope this helps/clarifies
Regards, Hans-Rudolf
On 06/04/2014 04:49 AM, Neil.Burdett@csiro.au wrote:
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
___________________________________________________________ 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/