⚡ Only 300 spots remaining • Closes in 2d 14h 32m
Secure your data. This workflow runs on a daily schedule, executes a shell command to dump your database (or uses a dedicated node), and uploads the resulting file to your private AWS S3 bucket for long-term storage and disaster recovery.
This workflow is pre-configured and ready for deployment. Simply import the JSON template into your n8n instance and configure your credentials.
This is an exclusive blueprint. Copy the JSON below to use it.
PRO TIP
Always test your workflow in a development environment before pushing to production.
{
"nodes": [
{
"parameters": {
"hour": 3
},
"name": "Every Day at 3AM",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"command": "mysqldump -u root -pPASSWORD my_database > /tmp/backup.sql"
},
"name": "Run Dump",
"type": "n8n-nodes-base.executeCommand",
"typeVersion": 1,
"position": [
450,
300
]
},
{
"parameters": {
"operation": "upload",
"bucket": "my-database-backups",
"fileName": "={{'backup-' + new Date().toISOString().split('T')[0] + '.sql'}}",
"fileContent": "=/tmp/backup.sql"
},
"name": "Upload to S3",
"type": "n8n-nodes-base.s3",
"typeVersion": 1,
"position": [
650,
300
]
}
],
"connections": {
"Every Day at 3AM": {
"main": [
[
{
"node": "Run Dump",
"type": "main",
"index": 0
}
]
]
},
"Run Dump": {
"main": [
[
{
"node": "Upload to S3",
"type": "main",
"index": 0
}
]
]
}
}
}To use this, copy the JSON above and paste it directly onto your n8n canvas.
Join the elite marketers who have offloaded their entire backend to n8n. Get direct support and custom builds in our private forum.