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/

Reply via email to