BestHub
Sign in
Tagged articles
42 articles
Page 1 of 1
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2026 · Databases

Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices

This comprehensive guide explains why MySQL backup is essential, defines RPO/RTO, compares logical and physical tools, provides ready‑to‑run scripts for full, incremental, binlog, encryption and compression backups, details step‑by‑step recovery procedures, troubleshooting tips and monitoring recommendations for reliable database protection.

AutomationBackupDatabase Administration
0 likes · 35 min read
Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices
Raymond Ops
Raymond Ops
Jul 1, 2025 · Databases

Master MySQL Backups: Commands for Single DB, Multiple DBs, Compression & Restoration

This guide explains how to use mysqldump to back up individual databases, multiple databases, all databases, specific tables, and how to compress backups, include drop statements, export only schema, and restore data using both interactive and non‑interactive MySQL commands, plus an automated backup script.

Bash scriptDatabase BackupRestore
0 likes · 9 min read
Master MySQL Backups: Commands for Single DB, Multiple DBs, Compression & Restoration
Raymond Ops
Raymond Ops
Mar 7, 2025 · Databases

Master MySQL Backups: Commands for Single, Multiple, and All Databases

This guide explains how to use mysqldump to back up a single MySQL database, multiple databases, or all databases, includes options for specific tables, compression with gzip, adding drop statements, exporting only schema, and provides restore procedures and a sample automated backup script.

Database BackupSQLmysql
0 likes · 11 min read
Master MySQL Backups: Commands for Single, Multiple, and All Databases
MaGe Linux Operations
MaGe Linux Operations
Dec 3, 2024 · Databases

Master MySQL Backups: Commands, Scripts, and Best Practices

This guide explains how to back up single or multiple MySQL databases, entire server instances, specific tables, or only schema, using mysqldump with options like -B, gzip compression, add‑drop flags, and provides restore procedures and an automated backup script.

Database BackupGzipRestore
0 likes · 10 min read
Master MySQL Backups: Commands, Scripts, and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Jun 16, 2024 · Databases

Master MySQL Backups: Commands, Scripts, and Best Practices

This guide details how to use mysqldump and related commands to back up single or multiple MySQL databases, specific tables, compress backups, include drop statements, export only schema, and automate the process with scripts and cron jobs, plus instructions for restoring data.

GzipSQLmysql
0 likes · 11 min read
Master MySQL Backups: Commands, Scripts, and Best Practices
php Courses
php Courses
Jul 30, 2023 · Operations

How to Schedule Automatic Backups for PHP Websites on CentOS

This guide explains three practical methods—using crontab, rsync, and mysqldump—to set up scheduled backups of PHP website files and databases on a CentOS server, ensuring data protection through automated daily or periodic tasks.

BackupCentOSLinux
0 likes · 4 min read
How to Schedule Automatic Backups for PHP Websites on CentOS
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 9, 2023 · Databases

MySQL mysqldump Failure Caused by lower_case_table_names and Missing .frm Files: Diagnosis, Simulation, and Remedies

The article analyzes a MySQL mysqldump failure where tables appear missing due to the lower_case_table_names setting, reproduces the issue through a controlled experiment, and provides practical solutions and operational recommendations for handling case‑sensitivity during database migrations.

lower_case_table_namesmysqlmysqldump
0 likes · 7 min read
MySQL mysqldump Failure Caused by lower_case_table_names and Missing .frm Files: Diagnosis, Simulation, and Remedies
政采云技术
政采云技术
Dec 27, 2022 · Databases

Comprehensive Guide to MySQL Backup Types, Tools, and Procedures

This article provides an in‑depth overview of MySQL backup classifications—including hot, warm, and cold backups—explains physical versus logical backup methods, compares built‑in and third‑party tools such as mysqldump, mysqlhotcopy, LVM snapshots, XtraBackup, and presents step‑by‑step command examples for each approach.

BackupData RecoveryLVM
0 likes · 14 min read
Comprehensive Guide to MySQL Backup Types, Tools, and Procedures
Architect's Guide
Architect's Guide
Mar 2, 2022 · Databases

How to Perform Scheduled MySQL Backups Using mysqldump and Cron

This article explains various methods for scheduled MySQL backups, covering mysqldump command usage, example backup commands for whole or specific databases, a Bash script to retain a fixed number of backups, and configuring cron jobs to automate the backup and restoration processes.

BackupBashDatabase Administration
0 likes · 11 min read
How to Perform Scheduled MySQL Backups Using mysqldump and Cron
Top Architect
Top Architect
Nov 8, 2021 · Databases

MySQL Scheduled Backup and Restoration Using mysqldump and Crontab

This article explains how to use the mysqldump command to back up MySQL databases, provides various command examples for full or partial backups, demonstrates a Bash script for automated daily backups with log management, and shows how to schedule these tasks using crontab.

AutomationBackupBash
0 likes · 11 min read
MySQL Scheduled Backup and Restoration Using mysqldump and Crontab
Programmer DD
Programmer DD
Oct 10, 2021 · Databases

Master MySQL Backups with mysqldump, Bash Scripts, and Cron

This guide details how to protect MySQL databases from errors and crashes by using mysqldump for manual dumps, creating Bash scripts for automated daily backups, and scheduling them with Linux cron, including command examples, restoration methods, and crontab syntax for reliable periodic backups.

BackupBashmysql
0 likes · 10 min read
Master MySQL Backups with mysqldump, Bash Scripts, and Cron
The Dominant Programmer
The Dominant Programmer
Jul 26, 2021 · Operations

How to Schedule MySQL Backups on Windows with a BAT Script

This guide shows how to use a Windows batch file together with MySQL's mysqldump tool to create scheduled backups of one or multiple databases, including command options, full‑path execution, loop timing, and a ping‑based pause to avoid interference.

AutomationWindowsbatch script
0 likes · 7 min read
How to Schedule MySQL Backups on Windows with a BAT Script
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 11, 2021 · Databases

Analysis and Resolution of MySQL Slave Replication Deadlock Caused by Global Read Lock

The article investigates a MySQL replication issue where a continuously rising master‑slave lag was traced to a global read lock held by mysqldump, leading to a deadlock between the SQL thread and the stop‑slave operation, and explains how killing the lock‑waiting thread restores normal replication.

deadlockmysqldumpperformance_schema
0 likes · 8 min read
Analysis and Resolution of MySQL Slave Replication Deadlock Caused by Global Read Lock
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Dec 21, 2020 · Databases

MySQL Backup and Recovery: Strategies, Tools, and Best Practices

This article explains the importance of MySQL backup and recovery, outlines common failure scenarios, recommends backup architectures and verification processes, reviews popular logical and physical backup tools such as mysqldump, mydumper, and xtrabackup, and shares practical case studies and best‑practice guidelines.

BackupDatabase AdministrationRecovery
0 likes · 10 min read
MySQL Backup and Recovery: Strategies, Tools, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 12, 2020 · Databases

MySQL sys Schema ERROR 1356 Bug When Using mysqldump --all-databases and How to Fix It

The article investigates the MySQL 5.7 sys schema ERROR 1356 caused by mysqldump --all-databases dropping mysql.proc, explains why the bug occurs, cites official documentation and bug reports, and provides four practical solutions including mysql_upgrade, separate sys backups, using --databases, and rebuilding from mysql‑sys.

Database BackupERROR 1356bug
0 likes · 12 min read
MySQL sys Schema ERROR 1356 Bug When Using mysqldump --all-databases and How to Fix It
Laravel Tech Community
Laravel Tech Community
Sep 5, 2020 · Databases

MySQL Database Backup and Recovery

The article explains why MySQL databases need regular backup, describes common data‑loss scenarios, classifies backup types (hot, cold, warm) and methods (logical, physical), lists popular tools, and provides detailed command‑line examples for backing up, restoring, migrating, and exporting data.

BackupData MigrationHot Backup
0 likes · 27 min read
MySQL Database Backup and Recovery
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 17, 2020 · Databases

How to Safely Rename a MySQL Database

This article explains several reliable techniques for renaming a MySQL database—including full export/import with mysqldump, bulk table‑rename operations, and legacy binlog‑based approaches—while providing concrete command‑line examples, performance measurements, and step‑by‑step instructions for each method.

BackupDatabase RenameSQL
0 likes · 9 min read
How to Safely Rename a MySQL Database
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2019 · Databases

Controlling mysqldump Insert Batch Size with --net-buffer-length to Avoid Large Transactions

This article explains how mysqldump’s --net-buffer-length option can be used to split INSERT statements into manageable batches, defines large transactions, shows performance testing with different buffer sizes, and concludes that the default settings already avoid large transactions and provide acceptable import performance.

Performance Testinglarge transactionmysql
0 likes · 8 min read
Controlling mysqldump Insert Batch Size with --net-buffer-length to Avoid Large Transactions
ITPUB
ITPUB
Jun 15, 2017 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup Strategies

This guide explains MySQL backup fundamentals, comparing cold backups, LVM snapshot backups, logical tools like mysqldump and mydumper, and physical solutions such as Percona Xtrabackup, detailing each method’s workflow, advantages, limitations, and how to achieve consistent recovery points and times.

BackupLVMmydumper
0 likes · 10 min read
Mastering MySQL Backups: From Cold Copies to Xtrabackup Strategies
ITPUB
ITPUB
May 9, 2016 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond

This article explains MySQL backup fundamentals, compares cold, snapshot, logical (mysqldump, mydumper) and physical (Xtrabackup) methods, outlines their workflows, pros and cons, and discusses lock‑related performance impacts and Percona's backup‑lock improvements.

BackupLVMdatabases
0 likes · 11 min read
Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond
ITPUB
ITPUB
Apr 5, 2016 · Databases

Add a MySQL Slave Without Downtime Using mysqldump or XtraBackup

This guide walks through adding a third MySQL replica to an existing master‑slave setup without restarting the service, comparing a logical mysqldump backup method with the faster physical XtraBackup approach and providing step‑by‑step commands and configuration details.

Database BackupReplicationSlave Setup
0 likes · 11 min read
Add a MySQL Slave Without Downtime Using mysqldump or XtraBackup
ITPUB
ITPUB
Nov 9, 2015 · Databases

Exporting and Importing MySQL Databases from the Windows Command Line

This guide walks you through using the MySQL command‑line tools on Windows to export a database with mysqldump, troubleshoot common errors, and restore the data with the mysql client and source command, covering path setup, syntax nuances, and file locations.

Database BackupWindowscommand-line
0 likes · 4 min read
Exporting and Importing MySQL Databases from the Windows Command Line
21CTO
21CTO
Sep 20, 2015 · Databases

Master MySQL Backup & Recovery: Mysqldump, LVM Snapshots, and Xtrabackup Explained

This tutorial walks through three MySQL backup and recovery strategies—using mysqldump with binary logs, LVM snapshots with binary logs, and Percona Xtrabackup—detailing environment setup, command syntax, incremental procedures, and restoration steps to ensure data safety and minimal downtime.

BackupLVMRecovery
0 likes · 21 min read
Master MySQL Backup & Recovery: Mysqldump, LVM Snapshots, and Xtrabackup Explained