dumptable: Copy the content of a database table to a compressed SQL dump...

In stix-global/eutradeflows: Download bilateral trade flow data from Eurostat Comext

Description

This funcion uses the following shell utilities: the mysqldump program to dump a database table. the 7zr program to compress the resulting .sql text file into a .sql.7z file. If mysqldump and 7zr are not available on your system, this function will not work.

Usage

dumptable(databasename, tablename, dumpfolder = "/mnt/sdb/data_raw/sqldump/")

Arguments

databasename	character name of the database
tablename	character name of the table
dumpfolder	character path where the .sql.7z file will be saved, defaults to a folder on the server, which might not exist on your system.

See Also

loadtabledump

Examples

## Not run:  # Dump a database table
dumptable("tradeflows", "raw_comext_monthly_201709")

## End(Not run)

stix-global/eutradeflows documentation built on Nov. 13, 2020, 9:23 p.m.