Friday, April 15, 2016

Xtrabackup innobackupex - restore script

 #!/bin/bash  
 service mysql stop  
 rm -r /var/lib/mysql/*  
 innobackupex --copy-back /path/to/backup  
 chown -R mysql:mysql /var/lib/mysql  
 service mysql start  
 echo "finished backup restore"  

No comments:

Post a Comment