Erick, To use a different database than the sqlite that come with the Galaxy distribution all that is needed is to change the config setting, prviding the URL that points to your mysql database. See the mysql documentation for the connection URL, as the URL differs depending upon whether you database is installed locally or not. The config setting is the "database_connection" setting, and could look something like this: database_connection = mysql:///greg_test?unix_socket=/var/run/mysqld/mysqld.sock Greg Von Kuster Galaxy Development Team Erick Antezana wrote:
Hello,
I would like to use MySQL instead of sqlite to store my data. I coudn't find on the Galaxy web site a HOWTO or some guidelines to do it. I only found some lines that might need to be changed/enabled in the universe_wsgi.ini file:
#database_file = database/universe.sqlite database_connection = mysql:///galaxy #database_engine_option_echo = true #database_engine_option_echo_pool = true #database_engine_option_pool_size = 10 #database_engine_option_max_overflow = 20
Could you point out to some doc or briefly describe what I need to do in order to go for mysql?
Are there any plans to support other DBMS's (like Oracle for instance)?
thanks, Erick ------------------------------------------------------------------------
_______________________________________________ galaxy-user mailing list galaxy-user@bx.psu.edu http://mail.bx.psu.edu/cgi-bin/mailman/listinfo/galaxy-user