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.burd...@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 [h...@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.burd...@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/
___________________________________________________________
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/
