Legacy MySQL Backup Methods
These methods are standard on all SQL database management systems and MySQL is no exception. Dumping SQL from a database or using binary logs has been around since the 70's. That is why they are considered legacy. These methods work good for small databases or production servers that shutdown at night where a backup can performed without interrupting users. For a modern web application that never sleeps legacy backup methods are many times not an option.
- SQL Database Dump — How Does MySQL Dump Work?
- Binary Log Backups — How Do MySQL Binary Log Backups Work?
- Lock and Copy — How Does MySQL Hot Copy Work?
Labels:
None