Command to back up a database and restore database through innobackupex

[lzm9...@gmail.com]

通过innobackupex备份数据库和恢复数据库的命令

[Sym]

may I know what is exactly that you want to do?

On Tuesday, June 12, 2018 at 9:39:50 PM UTC+8, lzm9...@gmail.com wrote:

通过innobackupex备份数据库和恢复数据库的命令

[George Chilumbu]

[George Chilumbu]

  

 1. Create Backup using Percona Xtrabackup

 

innobackupex --user=root --password=backpassword --host=localhost /tmp/ 

 

NOTE: Lets assume the command above creates a backup called /tmp/2018-12-07_03-09-06

 

2. Prepare backup

sudo innobackupex --apply-log --use-memory=2G /tmp/2018-12-07_03-09-06

 

3. Transfer backup folder to remote slave server.

scp -rC /tmp/2018-12-07_03-09-06  remote-db-server:/tmp

   

 

4. Perform Restoration on Remote Server

service mysql stop

mv /var/lib/mysql /tmp/mysql-old

mv /tmp/2018-12-07_03-09-06 /var/lib/mysql

chmod 755 /var/lib/mysql

chown mysql:mysql -R /var/lib/mysql

 

5. Create /var/lib/mysql/grastate.dat config file

vim /var/lib/mysql/grastate.dat

sudo chown mysql:mysql -R /var/lib/mysql/grastate.dat

 

NOTE: add contents to the newly created grastate.dat file from the grastate.dat copy on the MySQL Server where the backup was originally performed.

 

 

6. Update newly created grastate.dat seqno value.

cat /var/lib/mysql/xtrabackup_galera_info  # copy seqno i.e., digit after ":" e.g, 88103385 from the results below:

9bda690c-d24d-11e6-8944-46d5e753f4b1:88103385

 

7. Start MySQL

service mysql start

[George Chilumbu]

You can also follow the post here which explains in more detail:

https://georgechilumbu.wordpress.com/2016/11/30/hello-world/