Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Forum
Planet
All »
Home
Log In
Question: Db Migration Scripts?
0
gravatar for Erick Antezana
9.4 years ago by
Erick Antezana • 570
Erick Antezana • 570 wrote:
Hi, is there any migration script, bundeled with Galaxy, to assist in the sqlite to mysql migration? thanks, Erick
galaxy • 510 views
ADD COMMENT • link •
modified 9.4 years ago by Greg Von Kuster • 840 • written 9.4 years ago by Erick Antezana • 570
0
gravatar for Greg Von Kuster
9.4 years ago by
Greg Von Kuster • 840
Greg Von Kuster • 840 wrote:
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
ADD COMMENT • link written 9.4 years ago by Greg Von Kuster • 840
Please log in to add an answer.

Similar posts • Search »

Content
Help
Access
Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 182 users visited in the last hour