mysql - 从mysql备份文件导入数据时出错

Question

Using mysqldump npm module.While import the backfile generated using this npm.Get this error.

var mysqlDump = require('mysqldump');

mysqlDump({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'test',
    tables:[], // only these tables
    dest:'./data.sql' // destination file
},function(err){
    // create data.sql file;
})

错误 ：

“11:28:40 恢复 C:\Users\xxxx\Documents\dumps\xx24052018.sql 运行：mysql.exe --defaults-file="c:\users\xxx\appdata\local\temp\tmptdzvot.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "C:\Users\xxxx\Documents\dumps\xxxx24052018.sql" 错误第 1 行的 1046 (3D000)：未选择数据库

Operation failed with exitcode 1
11:28:41 Import of C:\Users\xxxx\Documents\dumps\xxxx24052018.sql has finished with 1 errors"

标签： mysqlnode.jsnpm

Answer 1

错误说

未选择数据库

您确定所有数据库设置吗？