- Execute tape backup system presscript which will
- log on as mysqlroot into mysql
- execute 'flush tables with read lock' - command
- Do a file system backup or LVM snapshot of mysql /data
- Execute tape backup system postscript which will
- log on as mysqlroot into mysql
- execute ‘unlock tables’ -command
Showing posts with label lvm. Show all posts
Showing posts with label lvm. Show all posts
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
Labels:
backup,
lvm,
mysql,
postscript,
prescript
Location:
Espoo, Finland
Subscribe to:
Posts (Atom)