cPanelResources

Tutorial MySQL Backups Prerequisites

There are certain prerequisites for MySQL backups, which should be properly looked into by a qualified database and/or system administrator. Failure to do so may result in invalid or incomplete MySQL backups. Some primary examples:

  • Disk Space - Depending on where MySQL is being backed up to, it is very important that there be enough free disk space to ensure a full backup can be taken.
  • InnoDB corruption - If InnoDB corruption is occurring, then attempting to backup MySQL databases may result in further corruption and very likely unusable backups. This issue must be properly resolved prior to backing up MySQL to ensure MySQL does not fail upon subsequent MySQL upgrades or restarts.
  • Filesystem issues - If the filesystem is reporting issues, then a consistency check or repair should be done prior to backing up MySQL. Generating partially corrupted MySQL backups is a possibility.
  • Unstable server - Servers that are not stable and prone to crashing should first ensure the underlying issue be investigated and fixed before backing up MySQL. A system crash during a backup process may result in an unusable backup.

Admin Note:
=======================================================================
This cPanel staff tutorial is no longer being maintained/updated here. For the most recent/up to date version please go here: cPanel Support - MySQL Backups Prerequisites
Author
cPanelResources
Views
878
First release
Last update
Rating
0.00 star(s) 0 ratings