dumpSQL: Import session-based SQL files in a MySQL database

Description Usage Arguments Details Author(s) See Also Examples

View source: R/sqldump.R

Description

This function imports session-based SQL files into a MySQL database.

Usage

1
2
dumpSQL(path_to_data, type = c("general", "forum", "unanonymizable",
  "hash_mapping"), user = "root", password = "root", verbose = FALSE)

Arguments

path_to_data

Folder with data files in it

type

Which dataset should be stored?

user

Username for MySQL database. Defaults to 'root'

password

Password for MySQL database. Defaults to 'root'

verbose

Print verbose intermediate messages? Defaults to FALSE

Details

This function requires a running MySQL database (see: https://www.mysql.com/)

Author(s)

Jasper Ginn

See Also

mongodump

Examples

1
2
3
4
5
## Not run: 
# Dump forum SQL file for federalism course
dumpSQL("/home/jasper/Documents/MOOC-DATA/Data_Dumps/federalism-001","forum",verbose = TRUE)

## End(Not run)

LU-C4i/R-package-MOOCs documentation built on May 7, 2019, 12:38 p.m.