Using MySQL Workbench

Download MySQL workbench from the Oracle website

(version 8.0.0.22 and 23 currently don’t work on MacOS select go here for selecting version)

• Click on the plus symbol, next to MySQL Connection.
  • Enter a name for your connection
  • Enter the hostname: kalahariresearch.org
  • Enter your username
  • Click Test connection and enter your password provided
• The connection will be saved and you can use the database schemas you have been provided with.

Using R

Initiating MySQL server connection

install.packages("RMariaDB") 				# Install the package
library(RMariaDB)   					# Open library
krtdb <- dbConnect(MariaDB(), 				# Create connection to database
	user = ‘yourdistributedusername',		# Login details be distributed on request
	password = 'distributed2you', 
	dbname = ‘Meerkatdatabase’, 
	host = ‘databases.kalahariresearch.org')

Fetching data into dataset

dbListTables(mydb)					# Lists available tables
dbListFields(mydb, 'table_name') 			# Lists available fields in selected Table

qrydata <- dbSendQuery(krtdb, "SELECT * FROM Meerkatdatabase ") 
	# Runs Query on remote server
gps_data <- fetch(qrydata, n = -1)                       	# Fetches results and saves as dataset
	# n = -1 fetches all records queried