Pastikan --single-transaction
{
"verbose": true,
"logging": [
{
"type": "json",
"target": "/home/user/backup/daily.json.log"
},
{
"type": "mail",
"options": {
"transport": "smtp",
"recipients": "email admin",
"smtp.port":"587",
"smtp.host":"smtp.host.com",
"smtp.username":"username",
"smtp.password":"password"
}
}
],
"backups": [
{
"source": {
"type": "mysqldump", // bisa diganti extrabackup
"options": {
"databases": "nama_db",
"user": "nama_user",
"password": "password",
"extendedInsert":true,
"singleTransaction":true,
"lockTables":false,
}
},
"target": {
"dirname": "/target/backup",
"filename": "nama-file-mysql-%Y%m%d-%H%i.sql",
"compress": "bzip2"
},
"cleanup": {
"type": "Quantity",
"options": {
"amount": "12"
}
}
}
]
}