Mysql Backup
Create a backup from MySQL. A modern version of mysqldump, but it's not to create a file, to output a string instead.
Installation
npm install mysql-backup
Get Start
Example
const mysqlBackup = ;
Full Options Example
var mysqlDump = ;var fs = ;
Options
host
Type: String
Url to Mysql host. Default: localhost
port
Type: String
Port to Mysql host. Default: 3306
user
Type: String
The MySQL user to authenticate as.
password
Type: String
The password of that MySQL user
database
Type: String
Name of the database to dump.
tables
Type: Array
Array of tables that you want to backup.
Leave Blank for All. Default: [] ALL
schema
Type: Boolean
Output table structure Default: true
;
data
Type: Boolean
Output table data for ALL tables Default: true
;
where
Type: Object
Where clauses to limit dumped data Example: where: {'users': 'id < 1000'}
Combine with data: false
to only dump tables with where clauses Default: null
;
ifNotExist
Type: Boolean
Create tables if not exist method Default: true
;
dropTable
Type: Boolean
Drop tables if exist Default: false
;
getDump
Type: Boolean
Return dump as a raw data on callback instead of create file Default: false
;
socketPath
Type: String
Path to a unix domain socket to connect to. When used host
and port
are ignored.
The MIT License