innobackupex不同备份方式的记录明细

最新推荐文章于 2022-02-18 11:47:07 发布
最新推荐文章于 2022-02-18 11:47:07 发布
阅读量1.3k 收藏
点赞数
分类专栏： Mysql-备份
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/songxixi/article/details/8730403
版权 
普通备份模式
[root@Slave02 tmp]# innobackupex  --database="inno test" --user=root --password=root  --no-lock --defaults-file=/etc/my.cnf  /data0/backup/mysql  2>/tmp/mysqlbackup.log
xtrabackup_55 version 1.6.2 for MySQL server 5.5.10 Linux (i686) (revision id: undefined)
[01] Copying ./ibdata1 
     to /data0/backup/mysql/2013-03-28_10-10-45/ibdata1
[01]        ...done
[01] Copying ./inno/mm.ibd 
     to /data0/backup/mysql/2013-03-28_10-10-45/inno/mm.ibd
[01]        ...done
[01] Copying ./inno/t.ibd 
     to /data0/backup/mysql/2013-03-28_10-10-45/inno/t.ibd
[01]        ...done
xtrabackup: The latest check point (for incremental): '893330831'
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (893330831) to (893330831) was copied.
[root@Slave02 tmp]# 
注：使用mysql的root用户将数据库testinnodb和test的备份，备份路径是/data0/backup/mysql/。备份 成功后会在该目录下将创建以时间戳为名称的备份目录。no-lock参数用于指定备份时不锁定表。2>/tmp/mysqlbackup.log是 将备份过程中的输出信息保存到/tmp/mysqlbackup.log中
[root@Slave02 tmp]# cd /data0/backup/mysql/           ---校验备份的文件
[root@Slave02 mysql]# ll
total 20
drwxr-xr-x 4 root root 4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root root   83 Mar 28 10:10 stderr
-rw-r--r-- 1 root root    0 Mar 28 10:10 stdout
[root@Slave02 mysql]# cd 2013-03-28_10-10-45/
[root@Slave02 2013-03-28_10-10-45]# ll
total 469520
-rw-r--r-- 1 root root       363 Mar 28 10:10 backup-my.cnf
-rw-r--r-- 1 root root 480247808 Mar 28 10:11 ibdata1
drwx------ 2 root root      4096 Mar 28 10:11 inno
-rw-r--r-- 1 root root         0 Mar 28 10:11 mysql-stderr
-rw-r--r-- 1 root root        76 Mar 28 10:11 mysql-stdout
drwxr-xr-x 2 root root      4096 Mar 28 10:11 test
-rw-r--r-- 1 root root        13 Mar 28 10:11 xtrabackup_binary
-rw-r--r-- 1 root root        81 Mar 28 10:11 xtrabackup_checkpoints
-rw-r--r-- 1 root root      2560 Mar 28 10:11 xtrabackup_logfile
[root@Slave02 2013-03-28_10-10-45]# cd inno/
[root@Slave02 inno]# ll
total 2096
-rw-r----- 1 mysql mysql    8554 Mar 27 14:49 mm.frm
-rw-r--r-- 1 root  root  1048576 Mar 28 10:11 mm.ibd
-rw-r----- 1 mysql mysql    8554 Mar 27 14:49 t.frm
-rw-r--r-- 1 root  root  1048576 Mar 28 10:11 t.ibd
[root@Slave02 inno]#
[root@Slave02 tmp]# cat mysqlbackup.log      ----查看备份记录的详细过程

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2011.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

130328 10:10:39  innobackupex: Starting mysql with options:  --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:10:39  innobackupex: Connected to database with mysql child process (pid=3714)
130328 10:10:45  innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql  Ver 14.14 Distrib 5.5.13, for Linux (i686) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /data0/backup/mysql/2013-03-28_10-10-45
130328 10:10:45  innobackupex: Starting mysql with options:  --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:10:45  innobackupex: Connected to database with mysql child process (pid=3742)
130328 10:10:49  innobackupex: Connection to database server closed

130328 10:10:49  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/data0/backup/mysql/2013-03-28_10-10-45
innobackupex: Waiting for ibbackup (pid=3754) to suspend
innobackupex: Suspend file '/data0/backup/mysql/2013-03-28_10-10-45/xtrabackup_suspended'

xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
xtrabackup: Target instance is assumed as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880
130328 10:10:49 InnoDB: Using Linux native AIO
130328 10:10:50  InnoDB: Warning: allocated tablespace 2, old maximum was 0
>> log scanned up to (893330831)
>> log scanned up to (893330831)
>> log scanned up to (893330831)

130328 10:11:03  innobackupex: Continuing after ibbackup has suspended
130328 10:11:03  innobackupex: Starting mysql with options:  --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:11:04  innobackupex: Connected to database with mysql child process (pid=3770)
>> log scanned up to (893330831)

130328 10:11:08  innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/usr/local/mysql/data'
innobackupex: Backing up file '/usr/local/mysql/data/inno/mm.frm'
innobackupex: Backing up file '/usr/local/mysql/data/inno/t.frm'
innobackupex: Backing up files '/usr/local/mysql/data/test/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (19 files)
130328 10:11:08  innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files

innobackupex: Resuming ibbackup

>> log scanned up to (893330831)
130328 10:11:09  innobackupex: Connection to database server closed

innobackupex: Backup created in directory '/data0/backup/mysql/2013-03-28_10-10-45'
130328 10:11:09  innobackupex: completed OK!
[root@Slave02 tmp]# 
压缩备份；
[root@Slave02 inno]# innobackupex  --database="inno test" --user=root --password
=root  --no-lock --defaults-file=/etc/my.cnf --stream=tar  /data0/backup/mysql  
2>/tmp/mysqlbackup.log|zip>/data0/backup/mysql/mike.tar.gz
  adding: - (deflated 63%)
You have new mail in /var/spool/mail/root
[root@Slave02 inno]# 
[root@Slave02 mysql]# ls
2013-03-28_10-10-45  mike.tar.gz  stderr  stdout  xtrabackup_binary
[root@Slave02 mysql]# ll
total 176004
drwxr-xr-x 4 root root      4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root root 180012554 Mar 28 11:03 mike.tar.gz
-rw-r--r-- 1 root root        83 Mar 28 10:10 stderr
-rw-r--r-- 1 root root         0 Mar 28 10:10 stdout
-rw-r--r-- 1 root root        13 Mar 28 11:03 xtrabackup_binary
[root@Slave02 mysql]# ll -la
total 176020
drwxr-xr-x 3 root root      4096 Mar 28 11:03 .
drwxr-xr-x 3 root root      4096 Mar 28 09:48 ..
drwxr-xr-x 4 root root      4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root root 180012554 Mar 28 11:03 mike.tar.gz
-rw-r--r-- 1 root root        83 Mar 28 10:10 stderr
-rw-r--r-- 1 root root         0 Mar 28 10:10 stdout
-rw-r--r-- 1 root root        13 Mar 28 11:03 xtrabackup_binary
[root@Slave02 mysql]# 

恢复过程；
[root@Slave02 mysql]# ll
total 176004
drwxr-xr-x 4 root root      4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root root 180012554 Mar 28 11:03 mike.tar.gz
-rw-r--r-- 1 root root        83 Mar 28 10:10 stderr
-rw-r--r-- 1 root root         0 Mar 28 10:10 stdout
-rw-r--r-- 1 root root        13 Mar 28 11:03 xtrabackup_binary
[root@Slave02 mysql]# rm -rf /usr/local/mysql/data/inno/
[root@Slave02 mysql]# rm -rf /usr/local/mysql/data/test/
[root@Slave02 mysql]# ls -la /usr/local/mysql/data/
total 481180
drwxr-xr-x  6 mysql mysql      4096 Mar 28 11:24 .
drwxr-xr-x 13 mysql mysql      4096 Dec 10 11:40 ..
drwx------  2 mysql mysql      4096 Jan 24 17:04 book
-rw-rw----  1 mysql mysql 480247808 Mar 27 14:50 ibdata1
-rw-rw----  1 mysql mysql   5242880 Mar 28 09:35 ib_logfile0
-rw-rw----  1 mysql mysql   5242880 Jan 24 17:04 ib_logfile1
-rw-r--r--  1 mysql mysql     91820 Nov 27 10:33 log.1
drwxr-xr-x  2 mysql mysql      4096 Dec 10 11:29 mysql
-rw-rw----  1 mysql mysql      1879 Mar 27 14:02 mysql-bin.000001
-rw-rw----  1 mysql mysql       126 Mar 27 14:04 mysql-bin.000002
-rw-rw----  1 mysql mysql       126 Mar 27 14:07 mysql-bin.000003
-rw-rw----  1 mysql mysql      1766 Mar 27 14:21 mysql-bin.000004
-rw-rw----  1 mysql mysql       493 Mar 27 14:49 mysql-bin.000005
-rw-rw----  1 mysql mysql       107 Mar 27 14:49 mysql-bin.000006
-rw-rw----  1 mysql mysql       107 Mar 28 09:35 mysql-bin.000007
-rw-rw----  1 mysql mysql       133 Mar 28 09:35 mysql-bin.index
-rw-r--r--  1 mysql mysql     33243 Nov 27 10:24 mysqld_multi.log
-rw-r--r--  1 mysql mysql         5 Nov 27 10:28 mysql.pid
drwxr-xr-x  2 mysql mysql      4096 Dec 10 11:29 performance_schema
drwx------  2 mysql mysql      4096 Jan 23 14:07 prod
-rw-rw----  1 mysql mysql    145643 Mar 28 09:35 Slave02.err
-rw-rw----  1 mysql mysql         5 Mar 28 09:35 Slave02.pid
-rw-r--r--  1 mysql mysql   1041603 Jan 25 09:25 slow.log
[root@Slave02 mysql]# ls
2013-03-28_10-10-45  mike.tar.gz  stderr  stdout  xtrabackup_binary
[root@Slave02 mysql]# tar xvzfi mike.tar.gz 
backup-my.cnf
ibdata1
inno/mm.ibd
inno/t.ibd
inno/mm.frm
inno/t.frm
test/t.MYI
test/mm.MYD
test/a.MYD
test/mm.MYI
test/t1.frm
test/t_coverindex.frm
test/mm.frm
test/big_string.frm
test/a.frm
test/big_string.MYD
test/a.MYI
test/t1.MYD
test/t1.MYI
test/t.frm
test/t2.MYD
test/t.MYD
test/t2.MYI
test/t2.frm
test/big_string.MYI
xtrabackup_logfile
xtrabackup_checkpoints
[root@Slave02 mysql]# 
[root@Slave02 mysql]# innobackupex  --apply-log --user=root --password=root --de
faults-file=/etc/my.cnf  --no-lock /data0/backup/mysql/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2011.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

IMPORTANT: Please check that the apply-log run completes successfully.
           At the end of a successful apply-log run innobackupex
           prints "completed OK!".



130328 11:33:57  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/etc/my.cnf" --prepare --target-dir=/data0/backup/mysql

xtrabackup_55 version 1.6.2 for MySQL server 5.5.10 Linux (i686) (revision id: undefined)
xtrabackup: cd to /data0/backup/mysql
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(893330831)
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 2097152
130328 11:33:57 InnoDB: Using Linux native AIO
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
130328 11:33:57 InnoDB: The InnoDB memory heap is disabled
130328 11:33:57 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130328 11:33:57 InnoDB: Compressed tables use zlib 1.2.3
130328 11:33:57 InnoDB: Using Linux native AIO
130328 11:33:57 InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead
130328 11:33:57 InnoDB: Initializing buffer pool, size = 100.0M
130328 11:33:57 InnoDB: Completed initialization of buffer pool
130328 11:33:57 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130328 11:33:57  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Last MySQL binlog file position 0 474, file name ./mysql-bin.000005
130328 11:33:57  InnoDB: Waiting for the background threads to start
130328 11:33:58 InnoDB: 1.1.5 started; log sequence number 893330831

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 474, file name ./mysql-bin.000005

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
130328 11:33:58  InnoDB: Starting shutdown...
130328 11:33:59  InnoDB: Shutdown completed; log sequence number 893331069

130328 11:33:59  innobackupex: Restarting xtrabackup with command: xtrabackup_55  --defaults-file="/etc/my.cnf" --prepare --target-dir=/data0/backup/mysql
for creating ib_logfile*

xtrabackup_55 version 1.6.2 for MySQL server 5.5.10 Linux (i686) (revision id: undefined)
xtrabackup: cd to /data0/backup/mysql
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880
130328 11:33:59 InnoDB: Using Linux native AIO
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
130328 11:33:59 InnoDB: The InnoDB memory heap is disabled
130328 11:33:59 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130328 11:33:59 InnoDB: Compressed tables use zlib 1.2.3
130328 11:33:59 InnoDB: Using Linux native AIO
130328 11:33:59 InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead
130328 11:33:59 InnoDB: Initializing buffer pool, size = 100.0M
130328 11:33:59 InnoDB: Completed initialization of buffer pool
130328 11:33:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130328 11:33:59  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130328 11:33:59 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130328 11:33:59  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Last MySQL binlog file position 0 474, file name ./mysql-bin.000005
130328 11:33:59  InnoDB: Waiting for the background threads to start
130328 11:34:00 InnoDB: 1.1.5 started; log sequence number 893331468

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 474, file name ./mysql-bin.000005

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
130328 11:34:00  InnoDB: Starting shutdown...
130328 11:34:01  InnoDB: Shutdown completed; log sequence number 893331468
130328 11:34:01  innobackupex: completed OK!
[root@Slave02 mysql]# 
[root@Slave02 mysql]# cp -r inno/ /usr/local/mysql/data/
[root@Slave02 mysql]# cp -r test/ /usr/local/mysql/data/
[root@Slave02 mysql]# ls
2013-03-28_10-10-45  inno         xtrabackup_binlog_pos_innodb
backup-my.cnf        mike.tar.gz  xtrabackup_checkpoints
ibdata1              stderr       xtrabackup_logfile
ib_logfile0          stdout
ib_logfile1          test
[root@Slave02 mysql]# ll
total 657824
drwxr-xr-x 4 root  root       4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root  root        303 Mar 28 11:02 backup-my.cnf
-rw-rw---- 1 mysql mysql 480247808 Mar 28 11:45 ibdata1
-rw-r--r-- 1 root  root    5242880 Mar 28 11:45 ib_logfile0
-rw-r--r-- 1 root  root    5242880 Mar 28 11:45 ib_logfile1
drwxr-xr-x 2 root  root       4096 Mar 28 11:44 inno
-rw-r--r-- 1 root  root  180012554 Mar 28 11:03 mike.tar.gz
-rw-r--r-- 1 root  root         93 Mar 28 13:30 stderr
-rw-r--r-- 1 root  root          0 Mar 28 13:30 stdout
drwxr-xr-x 2 root  root       4096 Mar 28 11:44 test
-rw-r--r-- 1 root  root         23 Mar 28 11:45 xtrabackup_binlog_pos_innodb
-rw-r--r-- 1 root  root         81 Mar 28 11:45 xtrabackup_checkpoints
-rw-r--r-- 1 root  root    2097152 Mar 28 11:45 xtrabackup_logfile
[root@Slave02 mysql]# ls -la /usr/local/mysql/data/
total 481188
drwxr-xr-x  8 mysql mysql      4096 Mar 28 13:52 .
drwxr-xr-x 13 mysql mysql      4096 Dec 10 11:40 ..
drwx------  2 mysql mysql      4096 Jan 24 17:04 book
-rw-rw----  1 mysql mysql 480247808 Mar 28 13:00 ibdata1
-rw-rw----  1 mysql mysql   5242880 Mar 28 13:00 ib_logfile0
-rw-rw----  1 mysql mysql   5242880 Jan 24 17:04 ib_logfile1
drwxr-xr-x  2 root  root       4096 Mar 28 13:51 inno
-rw-r--r--  1 mysql mysql     91820 Nov 27 10:33 log.1
drwxr-xr-x  2 mysql mysql      4096 Dec 10 11:29 mysql
-rw-rw----  1 mysql mysql      1879 Mar 27 14:02 mysql-bin.000001
-rw-rw----  1 mysql mysql       126 Mar 27 14:04 mysql-bin.000002
-rw-rw----  1 mysql mysql       126 Mar 27 14:07 mysql-bin.000003
-rw-rw----  1 mysql mysql      1766 Mar 27 14:21 mysql-bin.000004
-rw-rw----  1 mysql mysql       493 Mar 27 14:49 mysql-bin.000005
-rw-rw----  1 mysql mysql       107 Mar 27 14:49 mysql-bin.000006
-rw-rw----  1 mysql mysql       126 Mar 28 13:00 mysql-bin.000007
-rw-rw----  1 mysql mysql       133 Mar 28 09:35 mysql-bin.index
-rw-r--r--  1 mysql mysql     33243 Nov 27 10:24 mysqld_multi.log
-rw-r--r--  1 mysql mysql         5 Nov 27 10:28 mysql.pid
drwxr-xr-x  2 mysql mysql      4096 Dec 10 11:29 performance_schema
drwx------  2 mysql mysql      4096 Jan 23 14:07 prod
-rw-rw----  1 mysql mysql    146109 Mar 28 13:00 Slave02.err
-rw-r--r--  1 mysql mysql   1041603 Jan 25 09:25 slow.log
drwxr-xr-x  2 root  root       4096 Mar 28 13:52 test
[root@Slave02 mysql]# 
[root@Slave02 mysql]# 
[root@Slave02 mysql]# chown -R mysql:mysql /usr/local/mysql/data
[root@Slave02 mysql]# ls -la /usr/local/mysql/data/
total 481188
drwxr-xr-x  8 mysql mysql      4096 Mar 28 13:52 .
drwxr-xr-x 13 mysql mysql      4096 Dec 10 11:40 ..
drwx------  2 mysql mysql      4096 Jan 24 17:04 book
-rw-rw----  1 mysql mysql 480247808 Mar 28 13:00 ibdata1
-rw-rw----  1 mysql mysql   5242880 Mar 28 13:00 ib_logfile0
-rw-rw----  1 mysql mysql   5242880 Jan 24 17:04 ib_logfile1
drwxr-xr-x  2 mysql mysql      4096 Mar 28 13:51 inno
-rw-r--r--  1 mysql mysql     91820 Nov 27 10:33 log.1
drwxr-xr-x  2 mysql mysql      4096 Dec 10 11:29 mysql
-rw-rw----  1 mysql mysql      1879 Mar 27 14:02 mysql-bin.000001
-rw-rw----  1 mysql mysql       126 Mar 27 14:04 mysql-bin.000002
-rw-rw----  1 mysql mysql       126 Mar 27 14:07 mysql-bin.000003
-rw-rw----  1 mysql mysql      1766 Mar 27 14:21 mysql-bin.000004
-rw-rw----  1 mysql mysql       493 Mar 27 14:49 mysql-bin.000005
-rw-rw----  1 mysql mysql       107 Mar 27 14:49 mysql-bin.000006
-rw-rw----  1 mysql mysql       126 Mar 28 13:00 mysql-bin.000007
-rw-rw----  1 mysql mysql       133 Mar 28 09:35 mysql-bin.index
-rw-r--r--  1 mysql mysql     33243 Nov 27 10:24 mysqld_multi.log
-rw-r--r--  1 mysql mysql         5 Nov 27 10:28 mysql.pid
drwxr-xr-x  2 mysql mysql      4096 Dec 10 11:29 performance_schema
drwx------  2 mysql mysql      4096 Jan 23 14:07 prod
-rw-rw----  1 mysql mysql    146109 Mar 28 13:00 Slave02.err
-rw-r--r--  1 mysql mysql   1041603 Jan 25 09:25 slow.log
drwxr-xr-x  2 mysql mysql      4096 Mar 28 13:52 test
[root@Slave02 mysql]# service mysqld restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL..                                           [  OK  ]
[root@Slave02 mysql]# service mysqld restart
Shutting down MySQL.                                       [  OK  ]
Starting MySQL..                                           [  OK  ]
[root@Slave02 mysql]# mysql -uroot -proot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.13-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use inno
Database changed
mysql> show tables;
+----------------+
| Tables_in_inno |
+----------------+
| mm             |
| t              |
+----------------+
2 rows in set (0.00 sec)

mysql> select * from mm;
+------+
| a    |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
| 9999 |
+------+
5 rows in set (0.02 sec)

mysql>


太阳上有风
关注
专栏目录
xtrabackup的备份配置异常问题解析
疯狂的石头
01-21 4039
在配置xtrabackup的时候经常出现一些比较怪异的问题所在，比如提示相关的datadir不存在，但是在我们的my.cnf已经存在了，仍然报类似相关的错误信息了！这里我对于不同版本的安装在不同系统不敢苟同，但是在高版本当中很多的相关参数配置方法已经内部做好，无需在手工进行编译配置，以下是我在centos5.5系统上配置xtrabackup1.6.2的相关步骤，以及异常的相关解决方法，仅此提供参考
解决还原数据库备份文件，版本不一致失败情况
qq_14853875的博客
05-29 6100
还原数据库备份文件，版本不一致失败情况，选择master执行下面代码可以解决 RESTORE DATABASE newDataBase FROM DISK = 'F:\old.bak' --bak文件路径 with replace, MOVE 'old' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DA...
mysql hang_mysql hang
weixin_39532466的博客
01-19 223
MySQL 和 Innobackup 不定期卡住的秘密最近很长时间，陆续有不少朋友跟我说他们的MySQL经常重启，卡住，然后结了一堆报错信息。正好，自己之前也遇到过大批量的MySQL hang和innobackupex备份卡住的问题，一直没时间写，现在就分享下自己遇到的问题，希望后面的人可以避免好了，直接上图实战症状MySQL hangI...文章兰春2018-12-101155浏览量【整理】组建...
HANA 数据库备份hang住的解决办法
苦行僧的妖孽日常
10-09 924
记录一次解决HANA数据库备份hang住的过程。参考SAP的2个NOTE：2452735 和 2827950
xtrabackup之Innobackupex全备恢复
weixin_33975951的博客
06-26 77
一、当前环境 [mysql@hadoop1 ~]$ mysql --defaults-file=/mysql/mysqldata/3306/my.cnf -uroot -p123456 -P3306 mysql> show variables like 'version'; +---------------+------------+ | Variable_name | Valu...
每日每笔交易明细记录Excel表格.pdf
11-16
每日每笔交易明细记录Excel表格.pdf
简洁月考勤记录明细表excel表格模板
最新发布
07-24
考勤表，Excel模版，简洁月考勤记录明细表excel表格模板
记录管理明细表.doc
02-12
各有关部门(单位)表示记录分散在组织的不同部门，便于各部门直接管理和使用，同时也要求有统一的存取和备份策略来保证数据安全。 7. **保存年限**：10年的保存年限是一个常见的规定，可能与行业的法规要求、企业的...
kettle统计重复记录个数及明细
08-08
在"Kettle统计重复记录个数及明细"这个场景中，我们的任务是识别和分析数据集中重复的记录。这通常涉及到数据清洗和预处理阶段，以便确保数据质量并为后续的分析或报告提供准确的信息。 1. **统计重复记录个数**： ...
股东出资明细表.--股东出资明细表
04-15
股东出资明细表.--股东出资明细表
xtrabackup备份mysql实战_mysql备份实战-Xtrabackup工具备份 ...
weixin_36064512的博客
01-19 144
Xtrabackup简介Xtrabackup是由percona提供的mysql数据库备份工具，据官方介绍，这也是世界上惟一一款开源的能够对innodb和xtradb数据库进行热备的工具，是商业备份工具InnoDB Hotbackup的一个很好的替代品。特点：(1)备份过程快速、可靠；(2)备份过程不会打断正在执行的事务；(3)能够基于压缩等功能节约磁盘空间和流量；(4)自动实现备份检验；(5)还原...
Xtrabackup产品innobackupex命令
chenliang
07-21 392
文章目录第1章 innobackupex命令的参数整理1.1 innobackupex命令的参数1.2 [备份阶段]的参数1.3 [解压阶段]的参数1.4 [准备阶段]的参数1.5 [恢复阶段]的参数第2章 innobackupex【备份阶段】【解压阶段】的实践2.1 当前数据库环境2.2 测试数据的准备2.3 全部备份案例理解2.3.1 备份整个实例12.3.2 备份整个实例22.3.3 备份整个实例32.4 部分备份案例理解2.4.1 备份单个业务库2.4.2 备份多个业务库 第1章 innobacku
记录用Navicat Premium还原备份全过程及遇到的问题
热门推荐
rhino
08-21 1万+
这里出现了错误 invalid default value for ‘insert time’ 在该数据库执行以下sql后，再次还原就没有问题了。 SET @@GLOBAL .sql_mode = “ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUT...
使用innobackupex做全备——mysql物理备份基础
liuzhilong的博客
08-13 370
什么是innobackupex innobackupex是xtrabackup工具的命令之一，可以对innoDB，XtraDB，MyISAM等存储类型的库进行备份，non-blocking backup tool。 innobackupex的帮助文档： WARNING: The innobackupex program is deprecated. Please switch to xtrabackup. innobackupex程序已经过时了，应尽量使用xtrabacku...
Xtrabackup进行备份所需的权限
灯火觅阑珊
09-09 2206
通常进行数据库备份，无论是数据库的还是操作系统的，都使用root用户来备份，由于这两者都是在各自系统里拥有最高权限，所以在这种情况下很少会关注使用xtrabackup究竟需要哪些必要的权限。 有一种情况是，在OS和DB用户及权限严格控制的生产环境下，通常都无法使用各自系统的root用户，但是目前需要使用xtrabackup来做一个全库备份，那么需要授予备份用户哪些权限呢？ Linux层面： 对于要...
mysql 还原数据库 事务_MySQL数据库的三种备份恢复方式
weixin_35112750的博客
01-19 537
数据库的备份与恢复也是系统运维工程师必备的技能之一，下面介绍几种mysql数据库备份工具及其实现。一、mysqldump备份恢复实例二、为数据文件所在逻辑卷创建快照卷的方式进行备份恢复实例三、使用Xtrabackup进行增量备份和恢复实例mysqldump：可以把整个数据库装载到一个单独的文本文件中。这个文件包含有所有重建您的数据库所需要的SQL命令。这个命令取得所有的模式，并且将其转换成DDL语...
使用xtrabackup备份后，有时候 apply-log 后，2个文件的位移点不一致的解答
weixin_33695450的博客
07-29 782
使用xtrabackup备份后，有时候 apply-log 后，2个文件的位移点不一致的解答：如下实例：[root@vpc /root/3306 ]# cat xtrabackup_binlog_infomysql-bin.0000421241756bc2f04-7556-11e8-b3b6-000c29ba98ce:1-2047 ...
DB12自动备份出错异步传输失败
phantom_cy的博客
02-18 875
事务代码DBT12 问题：自动备份失败提示：[2000008]异步文件传输期间出错(io_getevents)， rc=28:设备上没有剩余空间。 [447] backup could not be completed, [2000008] Error during asynchronous file transfer (io_getevents), rc=28: No space left on device; $fileCallback$=[W] , buffer= 0x00007fbfda6840
innobackupex mysql备份及恢复（全量和增量）
u010066807的博客
02-17 5357
环境：Ubuntu 12.04.5 LTS mysql 5.5.47 备份路径 /backup/安装 apt-get install percona-xtrabackup一、 全量备份root@iZu1dc59z8tZ:/var/lib# innobackupex --defaults-file=/etc/mysql/my.cnf --user=root --password=123123 /b
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值