Hi Roy, What I would suggest is to dump the sqlite database to standard sql, and then creating a new instance of galaxy that has mysql as the configured database. When you run the setup and run script, you'll have a freshly instantiated galaxy with empty mysql tables. Then you can just import the standard sql file into the mysql database. Hope this helps, Kanwei On Thu, Feb 18, 2010 at 1:27 PM, Roy Weckiewicz <roystefan@gmail.com> wrote:
Hello, I am trying to configure a local galaxy server using a MYSQL database instead of the standard sqlite3. I'm using OSX and have been attempting (unsuccessfully) to convert the sqlite database (universe.sql) to mysql format. Basically, I am in need of the database table schema for mysql. I noticed on your web page that you host a mysql server at: genome-mysql.cse.ucsc.edu -- would it be possible to do some sort of mysqldump or mysqlhotcopy in order to download the table schema, so that I could upload them into my local mysql installation?
I've tried using Sqlite3 to dump the contents of universe.sql, but there are numerous syntax differences that need to be addressed before it will load successfully into my mysql database. Do you have any suggestions on how to either migrate the database from sqlite3 to MYSQL (via script or program), or create the mysql database from scratch and just import the correct table schema?
Any help would be appreciated.
MYSQL: Ver 14.14 Distrib 5.1.37, for apple-darwin9.5.0 (i386) using readline 5.1 Python 2.5.1
Rgds,
Roy Weckiewicz.
-- Roy Weckiewicz Texas A&M University
_______________________________________________ galaxy-dev mailing list galaxy-dev@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev