Hi, is there any migration script, bundeled with Galaxy, to assist in the sqlite to mysql migration? thanks, Erick
Hello Erick, If you are referring to moving existing data from a sqlite db to a mysql db, then Galaxy has no built-in script to do this. You'd have to use sqlite's features for exporting the data and mysql's features for importing the data. If you simply want to change your database from sqlite to mysql, then all that is necessary is the config setting, something like: # Database connection database_connection = mysql:///greg_test?unix_socket=/var/run/mysqld/mysqld.sock Greg Von Kuster Galaxy Development Team Erick Antezana wrote:
Hi,
is there any migration script, bundeled with Galaxy, to assist in the sqlite to mysql migration?
thanks, Erick ------------------------------------------------------------------------
_______________________________________________ galaxy-user mailing list galaxy-user@bx.psu.edu http://mail.bx.psu.edu/cgi-bin/mailman/listinfo/galaxy-user
participants (2)
-
Erick Antezana
-
Greg Von Kuster