d2c9857e3683a637750c3c81d2d6d870495cac53 ccpowell Tue Jul 23 11:18:17 2019 -0700 Adding updates to docs for mysql to MariaDB changes, refs #23597 diff --git src/hg/htdocs/goldenPath/help/mysql.html src/hg/htdocs/goldenPath/help/mysql.html index 5b173ad..4d06bb4 100755 --- src/hg/htdocs/goldenPath/help/mysql.html +++ src/hg/htdocs/goldenPath/help/mysql.html @@ -15,42 +15,42 @@

We have two MariaDB databases for public access:

These servers allow MySQL access to the same set of data currently available on our public Genome Browser site. The data are synchronized weekly with the main databases on our public site. During synchronization, the MariaDB server can be intermittently out of sync with the main website for a short period of time. The weekly synchronization takes place on Monday mornings from 4:00 am to 9:00 am Pacific Time (GMT -7:00 in summer, GMT -8:00 in winter).

Connecting

-You must have MySQL client libraries installed on your computer. We recommend using the most current -version of the v5.0 MySQL -clients.

+You must have MariaDb (MySQL) client libraries installed on your computer. You can read more about MariaDB on the +MariaDB site. +

You can connect to the US MariaDB server using the command:

mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A -P 3306

Or the European MariaDB server with this command:

mysql --user=genome --host=genome-euro-mysql.soe.ucsc.edu -A -P 3306

The -A flag is optional but is recommended for speed.

-Once connected to the database, you may use a wide range of MySQL commands to query the database. +Once connected to the database, you may use a wide range of SQL commands to query the database.

Conditions of use