oops - forget to keep it on the list -------- Original Message -------- Subject: Re: [galaxy-dev] Move galaxy/database (SQLite) to a new location Date: Wed, 04 Jun 2014 09:11:00 +0200 From: Hans-Rudolf Hotz <hrh@fmi.ch> To: Neil.Burdett@csiro.au 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/