• Website
  • App
  • Docs Home
simplebackups Docs
Docs
Search
⌘K WIN + K
  • Getting Started

    • Architecture
      • Backup Lifecycle & data flow
      • Backup workers
      • Our infrastructure
      • Connecting your worker/server
    • Features
      • Scheduling
      • Retention
      • Notifications
      • Incremental Backups
      • Backup Automation
      • Backup Webhook
      • Backup Trigger URL
      • Teams, Projects & users
      • Backup storage
      • Backup Custom Scripts
      • Backup Anomaly Detection
      • Backup Recovery & Compliance Board
    • Security & Privacy
      • Backup Encryption
      • How your data is processed
      • Uninstalling
      • How can I restrict/limit the permissions provided to SimpleBackups?
      • Data Processing Agreement
      • Data Processing Agreement DPA
    • Account & Billing
      • Trial plan
      • Free plan
      • Subscriptions
      • How to cancel my account?
      • Manage invoices and payment receipts
      • My payment failed, what should I do?
      • How to redeem a coupon?
      • How can I give access to my accountant?
      • How to grant owner access to another user?
  • Database Backup

    • MySQL Backup
      • Restore a MySQL backup
      • Guides
      • How to dump stored procedures / functions
      • How to Enable Binary Log for MySQL or MariaDB
      • How to create a Passwordless MySQL Backup
      • FAQ
      • Hot Backups in MySQL Using Percona XtraBackup
      • Restore PlanetScale / Vitess MySQL Backups
    • PostgreSQL Backup
      • Restore a PostgreSQL backup
      • Guides
      • FAQ
      • Fix for pg_restore "unsupported file header" Version Error
    • MongoDB Backup
      • Restore a MongoDB backup
      • MongoDB Backup and User Roles
      • Restore MongoDB Atlas Collection using MongoDB Compass
      • Guides
      • Backup From a Read-Replica Node
    • Redis Backup
      • Restore a Redis backup
    • DBaaS Providers
      • DigitalOcean Managed Redis
      • DigitalOcean Managed MySQL
      • DigitalOcean Managed PostgreSQL
      • DigitalOcean Managed MongoDB
      • DigitalOcean Managed database backup
      • Supabase PostgreSQL
      • Neon PostgreSQL
      • Aiven MySQL
      • Aiven PostgreSQL
      • Heroku PostgreSQL
      • Exoscale PostgreSQL
      • Vultr Database
      • OVH Database
      • Scaleway Database
      • Planetscale Database
      • Scalingo Database
      • Amazon RDS Database
      • Aiven Database
      • Scalingo Database
    • Help & Tips
      • FAQ
      • Connecting a private database
      • Docker Containers Backup
      • How to create serverless backups for managed databases?
  • Server & File Backup
    • Create a file/server backup
    • Restore a file/server backup
    • Incremental File Backups
    • Create a File backup of a DigitalOcean Spaces Object Storage bucket
  • Storage Backup
    • FAQ
    • Guides
    • Storage backup in a nutshell
    • How to preserve S3 or DigitalOcean Spaces metadata on the files/objects
  • Server & Volume Snapshot

    • Providers
      • Amazon Lightsail
      • AWS EC2
      • DigitalOcean
      • Exoscale
      • Hetzner
      • Linode
      • Scaleway
      • UpCloud
      • Vultr
      • OVH
      • Contabo
    • Resources
      • Restore a Snapshot
      • FAQ
  • SaaS App Backup

    • Apps
      • Knack
      • GitHub
      • Gitea
      • Gitlab
      • Notion
    • Resources
      • FAQ
  • Storage Providers
    • AWS S3
    • Amazon S3 Glacier
    • Azure Blob
    • Alibaba Cloud
    • Backblaze B2
    • Synology C2
    • CloudFlare R2
    • DigitalOcean Spaces
    • Dropbox
    • Exoscale
    • Egnyte
    • Rsync.net
    • Filebase
    • Google Cloud Storage
    • Google Cloud Storage (S3-compatible credentials)
    • Google Drive
    • Hetzner Storage Box
    • IDrive e2
    • Leviia
    • MinIO
    • NAS or local volume
    • SFTP Storage
    • SimpleStorage
    • Storadera
    • Storj
    • UpCloud
    • Wasabi
    • Supabase
    • IONOS
    • CEPH
  • Help, Tips & Troubleshooting

    • Connecting a Server
      • SimpleBackups IP addresses (firewall)
      • Automatically provision servers
      • Errors & Troubleshooting
    • Storing your backups
      • Errors & Troubleshooting
      • How to customize the backup storage path
      • Backup Storage FAQ
      • Connecting read-only storage bucket
      • Google Cloud Storage Updated
    • Backups & Logs
      • How to download individual files when backing up all databases?
      • How to generate an RSA PEM (asymmetric) key pair?
    • Backup Settings & Options
      • Custom backup schedule via cron
    • Others
      • curl 35 ssl error
      • The displayed Storage Usage seems incorrect, what should I do?
      • Can I connect multiple "Cloud Providers" within the same account?
      • Solving Error 2013: Lost connection to MySQL server during query when dumping table
      • Backups failing for MySQL server versions (5.7.41 and 8.0.32)
      • PostgreSQL Backup Privileges Issues
      • pg_dump: error: Error message from server: SSL SYSCALL error: EOF detected
      • mysqldump: Couldn’t execute ‘show create table table_name‘
      • Using Tailscale with Docker for Secure Database Backups
      • Couldn't execute 'FLUSH TABLES WITH READ LOCK’
  • More

    • Website
    • App
    • Docs Home
All Categories
Database Backup
Guides

Guides

Guides & how to backup your MySQL database

Find all our MySQL guides and “how to” on our blog:

SimpleBackups Blog "MySQL"
Find out about MySQL in our blog! New releases, guides and how-tos to help you manage your server, database, storage and application backups.
SimpleBackups Blog "MySQL"
https://simplebackups.com/blog/using-simplebackups/mysql
SimpleBackups Blog "MySQL"
 
Did this answer your question?
😞
😐
🤩
How can we improve this article?

Last updated on August 4, 2021

Restore a MySQL backup How to dump stored procedures / functions
  • App
  • Website

Contact Us
Contact Us