---
title: "Backing Up and Restoring MySQL Containers with PowerShell"
description: "How to Write a PowerShell Script with Windows Task Scheduler to Regularly Back Up MariaDB/MySQL Docker Container Databases and Automatically Sync to OneDrive."
canonical_url: "https://blog.markkulab.net/en/post/powerhsell-backup-and-mysql-contrainer"
author: "Mark Ku"
author_url: "https://blog.markkulab.net/en/author/mark-ku"
site: "Mark Ku's Tech Notes"
date_published: "2023-11-19 01:01:01 +0800"
category: "PowerShell"
tags: ["powershell", "backup", "restore", "mysql", "mariadb", "docker", "onedrive"]
language: "en"
license: "CC BY 4.0"
license_url: "https://creativecommons.org/licenses/by/4.0/"
attribution: "when reusing or quoting, credit the author and link back to the original"
---

# Backing Up and Restoring MySQL Containers with PowerShell

## Solving the Problem
Enterprises are increasingly using open-source services like headless CMS and WordPress. If data corruption occurs, recovery can be very difficult. Many of these services use MySQL. I wrote a PowerShell script that works with Windows Task Scheduler to create backups and upload them to OneDrive.

## Writing the Backup PowerShell Script - backup-mysql-contrainer.ps1
```
# MariaDB資料庫備份腳本，帶有參數化的憑證

# 數據帳密
$dbUser = "your_username" # 用您的資料庫用戶名替換
$dbPassword = "your_password" # 用您的資料庫密碼替換

# 設置備份文件夾路徑
$backupDir = "E:\mysql-backup\de-cms-maria-db"
$containerName = "de-cms-maria-db"

# 確保備份目錄存在
if (-not (Test-Path -Path $backupDir)) {
    New-Item -ItemType Directory -Path $backupDir
}

# 獲取當前日期
$date = Get-Date -Format "yyyy-MM-dd"

# 初始化流水號
$serial = 1

# 定義備份文件名
do {
    $serialPadded = "{0:D2}" -f $serial
    $backupFileName = "$date-$serialPadded-db.dump"
    $backupFilePath = Join-Path -Path $backupDir -ChildPath $backupFileName
    $serial++
} while (Test-Path -Path $backupFilePath)

# 執行Docker命令以備份資料庫
$dockerCommand = "docker exec $containerName /bin/bash -c ""mysqldump -u $dbUser -p$dbPassword --routines --triggers strapi"""
Invoke-Expression "$dockerCommand > `"$backupFilePath`""

# 刪除舊的備份，只保留最新的20個
$allBackups = Get-ChildItem -Path $backupDir -Filter "*.dump" | Sort-Object LastWriteTime -Descending
if ($allBackups.Count -gt 20) {
    $backupsToDelete = $allBackups[20..($allBackups.Count-1)]
    foreach ($backup in $backupsToDelete) {
        Remove-Item $backup.FullName
    }
}

robocopy C:\mysql-backup "C:\Users\Administrator\OneDrive - ABC Technology Corp\Database\mysql-backup\us-strapi-db" /MIR
```

## Writing the Database Restore PowerShell Script - restore-mysql-contrainer.ps1
```

# 資料庫憑證
$dbUser = "your_username" # 用您實際的資料庫用戶名替換
$dbPassword = "your_password" # 用您實際的資料庫密碼替換

# 設置備份目錄路徑
$backupDir = "E:\mysql-backup\de-cms-maria-db"
$containerName = "de-cms-maria-db"

# 確保備份目錄存在
if (-not (Test-Path -Path $backupDir)) {
    Write-Host "備份目錄不存在。退出腳本。"
    exit
}

# 選擇要恢復的備份文件
$allBackups = Get-ChildItem -Path $backupDir -Filter "*.dump" | Sort-Object LastWriteTime -Descending
if ($allBackups.Count -eq 0) {
    Write-Host "未找到備份文件。退出腳本。"
    exit
}

# 可選操作，列出所有備份並讓用戶選擇一個
Write-Host "可用的備份文件："
$allBackups | ForEach-Object { Write-Host $_.Name }

# 假設恢復最新的備份，但這可以修改
$backupToRestore = $allBackups[0].FullName
Write-Host "從此文件恢復：$backupToRestore"

# 執行Docker命令以恢復資料庫
$dockerCommand = "docker exec -i $containerName /bin/bash -c ""mysql -u $dbUser -p$dbPassword strapi"""
Invoke-Expression "`"$dockerCommand`" < `"$backupToRestore`""

Write-Host "資料庫恢復完成。"
```

---

## About this article and its author

Originally published on [Mark Ku's Tech Notes](https://blog.markkulab.net/en/post/powerhsell-backup-and-mysql-contrainer)

License: [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/) — when reusing or quoting, credit the author and link back to the original

### About the author

**[Mark Ku](https://blog.markkulab.net/en/author/mark-ku)** — Software Solution Provider

- 10+ years senior software engineer, now an AI Builder
- Focused on large-platform architecture — North-American e-commerce, AI SaaS subscription billing
- Combining AI Agents and automation to build evolvable product foundations

### Free tools built by the author

All of these are free to use:

- [Free PDF Sign Tool](https://blog.markkulab.net/en/tools/pdf-sign): Online PDF sign tool — draw, type, or upload a signature, then drag, resize, and download. Everything runs in your browser; nothing is uploaded.
- [VS Code Refactory](https://blog.markkulab.net/en/tools/refactory): Refactory is a VS Code refactoring extension: 34 actions plus a 37-rule code-smell inspection layer with a Code Health dashboard, across 18 languages, backed by 534 tests. It learns your repo's conventions: where interfaces live, where DI is registered, whether 'use client' belongs. It ranks files by git churn × complexity so you know what to fix first, and hands any smell to the Claude Code already on your machine. Free to use, and your source never leaves your computer.
- [DB-Kit Database Manager](https://blog.markkulab.net/en/tools/db-kit): DB-Kit is a lightweight, cross-platform database manager built with Tauri + Rust + React. Manage MySQL, MariaDB, PostgreSQL, SQL Server, Oracle, SQLite, MongoDB, Redis, Kafka, Elasticsearch and RabbitMQ from one consistent interface: passwords encrypted in the OS keychain, SSH tunnels, full CRUD, a visual query builder, stacked multi-statement result sets, cross-connection data transfer and compare/sync, Excel / CSV import & export, visualized execution plans, ER diagrams, scheduled backups, SQL stress testing with p50–p99 latency percentiles, a 15-rule SQL review engine, Kafka message browsing with monitoring & alerts, a bilingual UI (Traditional Chinese / English), a built-in AI assistant (natural-language SQL, AI review and tuning advice) and the dbk CLI. Free and open source (MIT), with installers for Windows, macOS and Linux.
- [VS Code Super Mermaid](https://blog.markkulab.net/en/tools/super-mermaid): Super Mermaid is a VS Code extension for beautiful Mermaid diagrams out of the box: auto-colored live preview, mouse pan & zoom, high-res PNG / SVG export, 21 templates and multiple themes. Free and open source (MIT).
- [React Super Mermaid](https://blog.markkulab.net/en/tools/react-super-mermaid): react-super-mermaid is an open-source React component library: render beautiful Mermaid diagrams with a single <MermaidViewer>, with built-in colorful / sketch themes, pan & zoom, in-diagram search, and high-res SVG / PNG export. Lightweight, SSR-safe, fully typed. Free and open source (MIT).
- [Jira / Confluence Super Mermaid](https://blog.markkulab.net/en/tools/jira-super-mermaid): An Atlassian Forge app: write Mermaid syntax directly inside a Jira issue or a Confluence page and get flowcharts, sequence diagrams, state machines and Gantt charts. 11 diagram types, SVG / PNG export, light and dark themes, full CJK support. Runs on Atlassian: your diagrams live in your own site and the app calls no third-party service. Free, coming soon to the Atlassian Marketplace.
- [Mermaid Live Preview](https://blog.markkulab.net/en/tools/mermaid-preview): Write Mermaid in your browser, see it render instantly, and share the whole diagram as a single link. No sign-up, nothing uploaded to a server, and mermaid.live share links work as-is.
- [React Intl Phone Number](https://blog.markkulab.net/en/tools/react-intl-phone-number): react-intl-phone-number is an open-source React component: framework-agnostic and antd-free, with E.164 in/out, a searchable flag / country-code dropdown, configurable validation levels (strict / mobile-strict / loose), themeable CSS, and i18n — phone logic powered by google-libphonenumber. Lightweight and fully typed. Free and open source (MIT).
- [Uptime Kuma Cluster](https://blog.markkulab.net/en/tools/uptime-kuma-cluster): Turn single-node Uptime Kuma into a highly available cluster: OpenResty + Lua smart load balancing, shared MariaDB state, health checks and automatic failover, plus cluster-management REST APIs. One Docker Compose command to start. Free and open source (MIT).
- [Special Education](https://blog.markkulab.net/en/education): Learning materials crafted for special education students

### Daily podcasts

- [Mark's Tech Insights — Daily AI News](https://blog.markkulab.net/en/category/tech-news): Daily curated AI and tech trends. Catch the latest developments via audio summaries — covering AI applications, software architecture, DevOps, and engineering practice. — RSS: https://blog.markkulab.net/feed.xml
- [AI股市蝦聊](https://blog.markkulab.net/en/category/ai-stock-chat): Every trading day, an AI-analyzed take on the Taiwan stock market, delivered as a two-host conversation covering the session and the next-day outlook. — RSS: https://blog.markkulab.net/ai-stock-chat/feed.xml
- [開源好物週報](https://blog.markkulab.net/en/category/open-source-weekly): A weekly two-host pick of free open-source tools surfaced from real Hacker News, GitHub, and Reddit buzz — what pain they solve and the fastest way to get started. — RSS: https://blog.markkulab.net/open-source-weekly/feed.xml

### Newsletter

[Subscribe to the newsletter](https://blog.markkulab.net/en/subscribe) — Be the first to know about new posts. No spam, unsubscribe anytime.