Mobile/Cell: +43 / 660 / 62 45 103http://www.linkedin.com/in/martinmarcherUID: ATU68801424
Hi Martin,
Thank you for your questions about the GBiC installer. Firstly,
please note that a license is required to obtain the GBiC software for
commercial use:
https://genome-store.ucsc.edu/
Can you explain further what you mean by "version of UCSC GB is
currently running"? Do you mean the version of the software behind the
browser, the version of the data in the tables, or the MySQL version we
are running? We update the CGI's on a roughly 3 week schedule, and we
update MySQL tables whenever we release a new dataset, which could be
every day/week/month/etc, and you can determine the MySQL version we are
running via the following command:
mysql --user=genome --host=genome-mysql.soe.ucsc.edu \ -A -e 'show variables;' hg38 | grep -w version version 5.6.26-log
Can you also explain further what you mean by 'load a migration script from version X to X+1 in "plain SQL"'? What are you migrating in this case?
You can find SQL dumps for an individual database, for example hg38, here:
http://hgdownload.cse.ucsc.edu/goldenPath/hg38/database/
One of our engineers adds that "We use MyISAM because it is simple and trivial to rsync tables directly from one running instance of the MySQL server to a second running instance of a MySQL server without any interruption on either side."
Please let us know if you have any further questions!
Thank you again for your inquiry and using the UCSC Genome Browser. If
you have any further questions, please reply to gen...@soe.ucsc.edu.
All messages sent to that address are archived on a
publicly-accessible forum. If your question includes sensitive data,
you may send it instead to genom...@soe.ucsc.edu.
Christopher Lee
UCSC Genomics Institute
--
---
You received this message because you are subscribed to the Google Groups "UCSC Genome Browser Mirror-Specific Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to genome-mirror+unsubscribe@soe.ucsc.edu.
To post to this group, send email to genome...@soe.ucsc.edu.
Visit this group at https://groups.google.com/a/soe.ucsc.edu/group/genome-mirror/.
To view this discussion on the web visit https://groups.google.com/a/soe.ucsc.edu/d/msgid/genome-mirror/CAK1mKES5rMRwSp_EKA0UNe02XkdYA-Wv63zLdBH0S9-xb1rpow%40mail.gmail.com.
For more options, visit https://groups.google.com/a/soe.ucsc.edu/d/optout.
To view this discussion on the web visit https://groups.google.com/a/soe.ucsc.edu/d/msgid/genome-mirror/CAK1mKERWdfk8nTQc-Gmda60%2BuZ5-5PTGx%2BCqdwOJPM4X1_%3DaSQ%40mail.gmail.com.