Hello Roy, The Galaxy database is distinct from the one that UCSC produces. We send between the two - but you want to have the Galaxy database as your base.
To ask a question there, use the "Help" link from the main page and use the first option "Email comments ... etc." http://main.g2.bx.psu.edu/ [email protected] Jennifer --------------------------------- Jennifer Jackson UCSC Genome Bioinformatics Group http://genome.ucsc.edu/ On 2/17/10 2:07 PM, Roy Weckiewicz wrote: > Hello, > > I am trying to configure a local distribution of galaxy 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 some sort of mysqldump > or mysqlhotcopy in order to download the table schema, so that I could > upload them into my local mysql installation? If you have any information or > can help me with this problem I would greatly appreciate it. > > P.S. I've tried using Sqlite3 to dump the contents of universe.sql, but > there are numerous formatting difference that need to be addressed before it > will upload successfully into mysql. > > MYSQL: Ver 14.14 Distrib 5.1.37, for apple-darwin9.5.0 (i386) using readline > 5.1 > > _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
