参考:http://blog.csdn.net/joeblackzqq/article/details/44968239
function getExportDbSql(db, index) -- 获取导出一个数据库实例的sql语句
local sql = string.format('mysqldump -u%s -p%s -h%s -P%d --default-character-set=utf8 --databases mu_ins_s%s > %s.s%d.mu_ins_%d.sql', db.user, db.pwd, db.host, db.port, index, db.server, index, index)
return sql
end
function createDbBackupFile(fname, dbList) -- 生成数据库导出的语句保存到文件
if not fname or not dbList then
return false
end
local f = io.open(fname, 'w')
if f then
f:write('echo @off\n\n')
for _, db in ipairs(dbList) do
for k, index in ipairs(db.indexList) do
f:write(string.format('REM %s.s%d\n', db.server, index))
f:write(string.format('%s\n\n', getExportDbSql(db, index)))
end
f:write('\n