etl (version 0.4.2)

src_mysql_cnf: Connect to local MySQL Server using ~/.my.cnf

Description

Connect to local MySQL Server using ~/.my.cnf

Usage

src_mysql_cnf(dbname = "test", groups = "rs-dbi", ...)

Arguments

dbname

name of the local database you wish to connect to. Default is test, as in RMariaDB::mariadbHasDefault().

groups

section of ~/.my.cnf file. Default is rs-dbi as in RMariaDB::mariadbHasDefault()

...

arguments passed to dplyr::src_mysql()

See Also

dplyr::src_mysql(), RMariaDB::mariadbHasDefault()

Examples

if (require(RMariaDB) && mariadbHasDefault()) {
  # connect to test database using rs-dbi
  db <- src_mysql_cnf()
  class(db)
  db
  # connect to another server using the 'client' group
  src_mysql_cnf(groups = "client")
}