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.