dump_database: Backup a database as a sequence of SQL statements

In LearningToTalk/L2TDatabase: Helper Functions for the Learning-To-Talk 'MySQL' Database

Description

This function calls mysqldump on a database connection described in a cnf file. Consider reading the documentation of mysqldump.

Usage

dump_database(cnf_file, backup_dir, db_name = "l2t")

Arguments

cnf_file	a MySQL config file
backup_dir	location where to save the backed up table
db_name	the name of the database to connect to. Defaults to "l2t".

Details

The command-line call uses the --single-transaction flag because it doesn't need LOCKED TABLES privilege.

Value

Nothing. Information about the dump output is printed to the console

LearningToTalk/L2TDatabase documentation built on June 24, 2020, 3:45 a.m.