Tagged articles
mysqldump
48 articles · Page 1 of 1
This guide details MySQL scheduled backup using mysqldump commands for full, structural, and data-only exports, a Bash script that retains 31 days of rotating backups with logging, and crontab configuration for automated execution, including restore procedures and practical scheduling examples.
Bash ScriptLinuxMySQL
0 likes · 13 min read

This guide covers MySQL scheduled backups using mysqldump with practical examples for full, structural, and data-only dumps, plus a Bash script with cron to automate daily backups and retain 31 days of history.
MySQLautomationbackup
0 likes · 14 min read

This comprehensive guide walks MySQL administrators through the fundamentals of backup and recovery, covering RPO/RTO concepts, tool comparisons (mysqldump, mydumper, xtrabackup), step‑by‑step scripts for full, incremental, and binlog backups, encryption, compression, troubleshooting, and best‑practice monitoring to ensure data safety and rapid restoration.
MySQLRecoveryXtraBackup
0 likes · 35 min read

This article provides ready-to-use Bash scripts for automated backup and interactive rollback of application code and MySQL databases on traditional servers, featuring timestamped versions, automatic cleanup, pre-rollback safety snapshots, and a real-world case study achieving rollback in under three minutes.
DevOpsMySQLOperations
0 likes · 15 min read

This guide walks through practical MySQL backup and point‑in‑time recovery strategies using logical dumps with mysqldump and physical copies with Percona XtraBackup, covering configuration, command‑line examples, binlog handling, GTID/LSN concepts, incremental backups, restoration scripts, verification steps and common pitfalls for DBAs and DevOps engineers.
MySQLOperationsRecovery
0 likes · 44 min read

This article analyzes common MySQL backup pitfalls, explains the three backup dimensions and five types, compares major tools such as mysqldump, mysqlpump, mydumper, XtraBackup and cloud snapshots, and provides practical scripts, sizing recommendations, scheduling, monitoring, recovery procedures, and failure case studies for reliable production backup engineering.
MyDumperMySQLRecovery
0 likes · 52 min read

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.
MySQLRecoveryXtraBackup
0 likes · 35 min read

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 ScriptCompressionMySQL
0 likes · 9 min read

This article explains what mysqldump is, describes its backup mechanism, lists command‑line options with detailed meanings, provides example commands for exporting databases or tables, and shows how to restore data using both system and source commands.
MySQLRestorebackup
0 likes · 8 min read

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.
MySQLSQLdatabase backup
0 likes · 11 min read

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.
GZIPMySQLRestore
0 likes · 10 min read

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.
GZIPMySQLSQL
0 likes · 11 min read

This article explains the new mysqld-long-query-time option added to MySQL 8.0.30's mysqldump tool, shows how to configure it, presents comparative experiments demonstrating its effect on slow‑query logs, and provides conclusions and additional notes for practical database backup scenarios.
MySQLSQLdatabase backup
0 likes · 8 min read

This article compares various MySQL data import/export methods—including mysqldump, mydumper, SELECT OUTFILE, and MySQL Shell utilities—explaining their commands, configuration options, performance results, and best‑practice recommendations based on testing with a 10‑million‑row table.
ExportMyDumperMySQL
0 likes · 16 min read

This article explains how to use the mysqldump command to back up MySQL databases, demonstrates various backup and restore options, provides a Bash script that maintains a limited number of daily backups, and shows how to schedule the script with crontab for automated execution.
MySQLautomationbackup
0 likes · 9 min read

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.
CentOSLinuxPHP
0 likes · 4 min read

The article analyzes a replication failure where mysqldump creates duplicate primary‑key errors on a MyISAM table, explains why the --single-transaction option only guarantees consistency for InnoDB, and provides solutions such as converting tables to InnoDB or using Xtrabackup.
InnoDBMyISAMMySQL
0 likes · 15 min read

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.
MySQLlower_case_table_namesmysqldump
0 likes · 7 min read


政采云技术Dec 27, 2022 · Databases
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.
LVMMySQLXtraBackup
0 likes · 14 min read

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.
MySQLbackupbash
0 likes · 11 min read

This article explains the importance of MySQL backups, compares common logical and physical backup tools such as mysqldump, Mydumper and Percona XtraBackup, details XtraBackup's step‑by‑step workflow, lock handling options, and provides practical Q&A for reliable database backup strategies.
InnoDBMySQLPercona XtraBackup
0 likes · 18 min read

The article investigates a bug introduced in MySQL 5.7.36 where mysqldump writes the SET @@GLOBAL.GTID_PURGED statement at the end of the dump file, causing GTID and data inconsistencies that break replication, and recommends using an older mysqldump version until the issue is fixed.
GTIDMySQLReplication
0 likes · 9 min read

This article explains how to use mysqldump for various MySQL backup scenarios, provides command‑line examples for full, structure‑only, and selective backups, shows how to restore dumps, and demonstrates a Bash script combined with crontab to automate daily backups with retention management.
MySQLautomationbackup
0 likes · 11 min read

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.
MySQLautomationbackup
0 likes · 11 min read

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.
MySQLbackupbash
0 likes · 10 min read

This guide walks you through using mysqldump to back up MySQL databases, restoring backups, and creating a Bash script with crontab to automate daily backups while retaining only the most recent 31 days of dump files.
LinuxMySQLautomation
0 likes · 11 min read

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.
MySQLWindowsautomation
0 likes · 7 min read

This article explains how to list MySQL databases, perform full, multiple‑database, single‑database, and table‑specific backups using mysqldump, and restore them correctly, highlighting the differences when using the --databases option and common pitfalls.
MySQLRestoreSQL
0 likes · 4 min read

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

This article demonstrates how to perform a full backup of a MySQL 8.0 database using mysqldump, drop and recreate the database, then restore it and apply incremental recovery with mysqlbinlog by specifying start and stop positions to recover data inserted after the backup.
MySQLRecoverybackup
0 likes · 5 min read

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.
MySQLRecoveryXtraBackup
0 likes · 10 min read

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.
ERROR 1356MySQLbug
0 likes · 12 min read

This article explains why restoring MySQL backups can fail due to missing SUPER privileges, describes the DEFINER and SQL SECURITY concepts, and details how the mysqldump source code was altered for MySQL 5.7 to strip DEFINER clauses, show backup progress, and improve performance testing.
DEFINERmysqldumpperformance
0 likes · 8 min read

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.
Hot BackupMySQLRecovery
0 likes · 27 min read

The article evaluates MySQL Shell 8.0.21's new logical backup and restore method—featuring ZSTD compression, chunked parallel export, and parallel LOAD DATA import—against mysqldump, mysqlpump, and mydumper, presenting benchmark results, analysis, and practical command examples.
MySQLRestorebackup
0 likes · 11 min read

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.
Database RenameMySQLSQL
0 likes · 9 min read

The article explains MySQL logical and physical backup methods, compares online and offline backup approaches, details the advantages and disadvantages of each, and provides practical mysqldump commands and master‑slave backup techniques for reliable database protection.
Logical BackupMySQLPhysical Backup
0 likes · 8 min read

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.
MySQLlarge transactionmysqldump
0 likes · 8 min read


ITPUBJun 15, 2017 · Databases
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.
LVMMyDumperMySQL
0 likes · 10 min read

This guide walks through the most common MySQL backup methods—including mysqldump, mysqlbackup, mysqlhotcopy, and Percona XtraBackup—detailing command syntax, options, lock behavior, restoration steps, and practical examples for both logical and physical backups.
CLIMySQLbackup
0 likes · 21 min read

This article explains how attackers can abuse mysqldump to embed malicious SQL that runs system commands during import, demonstrates the exploit step‑by‑step, and provides practical mitigation measures such as using --skip-comments and revoking CREATE TABLE privileges.
Database SecuritySQL injectionbackup exploitation
0 likes · 4 min read


ITPUBOct 24, 2016 · Databases
This guide explains how to restore a MySQL database that was mistakenly dropped by using a nightly full backup together with binlog files, extracting only the needed incremental statements, filtering out DROP commands, and applying the recovered data in a safe, step‑by‑step process.
MySQLbinlogdata recovery
0 likes · 7 min read


ITPUBMay 9, 2016 · Databases
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.
LVMMyDumperMySQL
0 likes · 11 min read


ITPUBApr 5, 2016 · Databases
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.
MySQLReplicationSlave Setup
0 likes · 11 min read


ITPUBNov 9, 2015 · Databases
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.
MySQLWindowscommand-line
0 likes · 4 min read


21CTOSep 20, 2015 · Databases
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.
Binary LogLVMMySQL
0 likes · 21 min read

This comprehensive tutorial explains MySQL/MariaDB backup types, essential tools such as mysqldump, LVM snapshots, and Percona XtraBackup, and provides detailed command‑line procedures for full, incremental, and hot backups as well as reliable data restoration.
LVM snapshotMariaDBMySQL
0 likes · 12 min read

This guide explains how mysqldump works, its syntax, and practical commands for backing up all databases, specific databases or tables, exporting only DDL, handling large datasets, compressing backups, and restoring data on Linux or Windows environments.
LinuxSQLmysql backup
0 likes · 7 min read
