npm install digi-dumpCreate a backup from MySQL / Maridb with configuration
```
npm install digi-dump
Example
`javascript
var digiDump = require('digi-dump');
digiDump({
host: 'localhost',
user: 'root',
password: '',
database: 'test',
dest:'./**.sql' // destination file
},function(err){
// create data.sql file;
})
`
Full Options Example :
`javascript
var digiDump = require('digiDump');
digiDump({
host: 'localhost',
user: 'root',
password: '',
database: 'test',
tables:['cars'], // include only these tables
where: {'cars': 'colors = red'},`
ifNotExist:true, // Create a table if not exist
dest:'./**.sql' // destination file,
colsToIgnore: [] // name of the columns to ignore.. (globally from the table)
},function(err){
// create data.sql file;
})
#### 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;
#### dest
Type: String
Output filename with directories Default: './data.sql';
#### socketPath
Type: String`
---------------------------------