Thursday, July 10, 2014

How to do MySQL Community Edition tape backups

Instead of using mysqldump for taking backups from MySQL Community Edition you might want to try combining your tape backup system with pre - and postscripts which will do the as mysqldump
  1. Execute tape backup system presscript which will
    • log on as mysqlroot into mysql
    • execute 'flush tables with read lock' - command
  2. Do a file system backup or LVM snapshot of mysql /data
  3. Execute tape backup system postscript which will
    •   log on as mysqlroot into mysql
    •   execute ‘unlock tables’ -command



No comments:

Post a Comment