First page Back Continue Last page Overview Graphics
Backup master files
If a file-system level backup is required, care should be taken to manually record binary log name and position via SHOW MASTER STATUS statement.
To ensure consistency between backup and binary log position, the tables should be locked via FLUSH TABLES WITH READ LOCK immediately before backup (and SHOW MASTER STATUS)
LEAVE THE CLIENT CONNECTED!!!
After backup finishes, execute UNLOCK TABLES to release the read lock