Change the SQL backend from SQLite to MySQL. When first called on an EnsDb object, the function tries to create and save all of the data into a MySQL database. All subsequent calls will connect to the already existing MySQL database.

# S4 method for EnsDb
useMySQL(x, host = "localhost", port = 3306, user, pass)

Arguments

x

The EnsDb object.

host

Character vector specifying the host on which the MariaDB/MySQL server runs.

port

The port on which the MariaDB/MySQL server can be accessed.

user

The user name for the MariaDB/MySQL server.

pass

The password for the MariaDB/MySQL server.

Value

A EnsDb object providing access to the data stored in the MySQL backend.

Details

This functionality requires that the RMariaDB package is installed and that the user has (write) access to a running MySQL server. If the corresponding database does already exist users without write access can use this functionality.

Note

At present the function does not evaluate whether the versions between the SQLite and MariaDB/MySQL database differ.

Author

Johannes Rainer

Examples

## Load the EnsDb database (SQLite backend).
library(EnsDb.Hsapiens.v86)
edb <- EnsDb.Hsapiens.v86
## Now change the backend to MySQL; my_user and my_pass should
## be the user name and password to access the MySQL server.
if (FALSE) {
edb_mysql <- useMySQL(edb, host = "localhost", user = my_user, pass = my_pass)
}