Guest User

Untitled

a guest
Feb 5th, 2013
28
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [root@hostname mysql]# mysql
  2. Welcome to the MySQL monitor.  Commands end with ; or \g.
  3. Your MySQL connection id is 11
  4. Server version: 5.5.28 Distributed by The IUS Community Project
  5.  
  6. Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
  7.  
  8. Oracle is a registered trademark of Oracle Corporation and/or its
  9. affiliates. Other names may be trademarks of their respective
  10. owners.
  11.  
  12. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  13.  
  14. mysql> create database xtrabackup_test;
  15. Query OK, 1 row affected (0.01 sec)
  16.  
  17. mysql> use xtrabackup_test;
  18. Database changed
  19. mysql> create table dummy_table (c1 int);
  20. Query OK, 0 rows affected (0.00 sec)
  21.  
  22. mysql> quit
  23. Bye
  24. [root@hostname mysql]# innobackupex /tmp/
  25.  
  26. InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
  27. and Percona Inc 2009-2012.  All Rights Reserved.
  28.  
  29. This software is published under
  30. the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
  31.  
  32. 130205 10:44:45  innobackupex: Starting mysql with options:  --unbuffered --
  33. 130205 10:44:45  innobackupex: Connected to database with mysql child process (pid=27541)
  34. 130205 10:44:51  innobackupex: Connection to database server closed
  35. IMPORTANT: Please check that the backup run completes successfully.
  36.            At the end of a successful backup run innobackupex
  37.            prints "completed OK!".
  38.  
  39. innobackupex: Using mysql  Ver 14.14 Distrib 5.5.28, for Linux (i686) using readline 5.1
  40. innobackupex: Using mysql server version Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
  41.  
  42. innobackupex: Created backup directory /tmp/2013-02-05_10-44-51
  43. 130205 10:44:51  innobackupex: Starting mysql with options:  --unbuffered --
  44. 130205 10:44:51  innobackupex: Connected to database with mysql child process (pid=27567)
  45. 130205 10:44:53  innobackupex: Connection to database server closed
  46.  
  47. 130205 10:44:53  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp/2013-02-05_10-44-51
  48. innobackupex: Waiting for ibbackup (pid=27574) to suspend
  49. innobackupex: Suspend file '/tmp/2013-02-05_10-44-51/xtrabackup_suspended'
  50.  
  51. xtrabackup_55 version 2.0.4 for Percona Server 5.5.16 Linux (i686) (revision id: 484)
  52. xtrabackup: uses posix_fadvise().
  53. xtrabackup: cd to /var/lib/mysql
  54. xtrabackup: Target instance is assumed as followings.
  55. xtrabackup:   innodb_data_home_dir = ./
  56. xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
  57. xtrabackup:   innodb_log_group_home_dir = ./
  58. xtrabackup:   innodb_log_files_in_group = 2
  59. xtrabackup:   innodb_log_file_size = 5242880
  60. >> log scanned up to (1608274)
  61. [01] Copying ./ibdata1 to /tmp/2013-02-05_10-44-51/ibdata1
  62. [01]        ...done
  63. [01] Copying ./xtrabackup_test/dummy_table.ibd to /tmp/2013-02-05_10-44-51/./xtrabackup_test/dummy_table.ibd
  64. [01]        ...done
  65.  
  66. 130205 10:44:55  innobackupex: Continuing after ibbackup has suspended
  67. 130205 10:44:55  innobackupex: Starting mysql with options:  --unbuffered --
  68. 130205 10:44:55  innobackupex: Connected to database with mysql child process (pid=27588)
  69. 130205 10:44:57  innobackupex: Starting to lock all tables...
  70. >> log scanned up to (1608274)
  71. >> log scanned up to (1608274)
  72. 130205 10:45:07  innobackupex: All tables locked and flushed to disk
  73.  
  74. 130205 10:45:07  innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
  75. innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
  76. innobackupex: subdirectories of '/var/lib/mysql'
  77. innobackupex: Backing up file '/var/lib/mysql/xtrabackup_test/dummy_table.frm'
  78. innobackupex: Backing up file '/var/lib/mysql/xtrabackup_test/db.opt'
  79. innobackupex: Backing up files '/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)
  80. innobackupex: Backing up files '/var/lib/mysql/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
  81. 130205 10:45:08  innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files
  82.  
  83. innobackupex: Resuming ibbackup
  84.  
  85. xtrabackup: The latest check point (for incremental): '1608274'
  86. xtrabackup: Stopping log copying thread.
  87. .>> log scanned up to (1608274)
  88.  
  89. xtrabackup: Transaction log of lsn (1608274) to (1608274) was copied.
  90. 130205 10:45:10  innobackupex: All tables unlocked
  91. 130205 10:45:10  innobackupex: Connection to database server closed
  92.  
  93. innobackupex: Backup created in directory '/tmp/2013-02-05_10-44-51'
  94. innobackupex: MySQL binlog position: filename '', position
  95. 130205 10:45:10  innobackupex: completed OK!
  96. [root@hostname mysql]#
  97. [root@hostname mysql]#
  98. [root@hostname mysql]#
  99. [root@hostname mysql]#
  100. [root@hostname mysql]#
  101. [root@hostname mysql]#
  102. [root@hostname mysql]#
  103. [root@hostname mysql]#
  104. [root@hostname mysql]#
  105. [root@hostname mysql]#
  106. [root@hostname mysql]# ls -alh /tmp/2013-02-05_10-4
  107. 2013-02-05_10-43-00/ 2013-02-05_10-44-51/
  108. [root@hostname mysql]# ls -alh /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
  109. -rw------- 1 root root 96K Feb  5 10:44 /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
  110. [root@hostname mysql]#
  111. [root@hostname mysql]#
  112. [root@hostname mysql]#
  113. [root@hostname mysql]#
  114. [root@hostname mysql]#
  115. [root@hostname mysql]#
  116. [root@hostname mysql]#
  117. [root@hostname mysql]# innobackupex --apply-log /tmp/2013-02-05_10-44-51/
  118.  
  119. InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
  120. and Percona Inc 2009-2012.  All Rights Reserved.
  121.  
  122. This software is published under
  123. the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
  124.  
  125. IMPORTANT: Please check that the apply-log run completes successfully.
  126.            At the end of a successful apply-log run innobackupex
  127.            prints "completed OK!".
  128.  
  129.  
  130.  
  131. 130205 10:46:03  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/tmp/2013-02-05_10-44-51/backup-my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/tmp/2013-02-05_10-44-51
  132.  
  133. xtrabackup_55 version 2.0.4 for Percona Server 5.5.16 Linux (i686) (revision id: 484)
  134. xtrabackup: cd to /tmp/2013-02-05_10-44-51
  135. xtrabackup: This target seems to be not prepared yet.
  136. xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1608274)
  137. xtrabackup: Temporary instance for recovery is set as followings.
  138. xtrabackup:   innodb_data_home_dir = ./
  139. xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
  140. xtrabackup:   innodb_log_group_home_dir = ./
  141. xtrabackup:   innodb_log_files_in_group = 1
  142. xtrabackup:   innodb_log_file_size = 2097152
  143. xtrabackup: Temporary instance for recovery is set as followings.
  144. xtrabackup:   innodb_data_home_dir = ./
  145. xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
  146. xtrabackup:   innodb_log_group_home_dir = ./
  147. xtrabackup:   innodb_log_files_in_group = 1
  148. xtrabackup:   innodb_log_file_size = 2097152
  149. xtrabackup: Starting InnoDB instance for recovery.
  150. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
  151. 130205 10:46:03 InnoDB: The InnoDB memory heap is disabled
  152. 130205 10:46:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  153. 130205 10:46:03 InnoDB: Compressed tables use zlib 1.2.3
  154. 130205 10:46:03 InnoDB: Initializing buffer pool, size = 100.0M
  155. 130205 10:46:03 InnoDB: Completed initialization of buffer pool
  156. 130205 10:46:03 InnoDB: highest supported file format is Barracuda.
  157. InnoDB: The log sequence number in ibdata files does not match
  158. InnoDB: the log sequence number in the ib_logfiles!
  159. 130205 10:46:03  InnoDB: Database was not shut down normally!
  160. InnoDB: Starting crash recovery.
  161. InnoDB: Reading tablespace information from the .ibd files...
  162. 130205 10:46:03  InnoDB: Waiting for the background threads to start
  163. 130205 10:46:04 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1608274
  164.  
  165. [notice (again)]
  166.   If you use binary log and don't use any hack of group commit,
  167.  the binary log position seems to be:
  168.  
  169. xtrabackup: starting shutdown with innodb_fast_shutdown = 1
  170. 130205 10:46:04  InnoDB: Starting shutdown...
  171. 130205 10:46:08  InnoDB: Shutdown completed; log sequence number 1609488
  172.  
  173. 130205 10:46:08  innobackupex: Restarting xtrabackup with command: xtrabackup_55  --defaults-file="/tmp/2013-02-05_10-44-51/backup-my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/tmp/2013-02-05_10-44-51
  174. for creating ib_logfile*
  175.  
  176. xtrabackup_55 version 2.0.4 for Percona Server 5.5.16 Linux (i686) (revision id: 484)
  177. xtrabackup: cd to /tmp/2013-02-05_10-44-51
  178. xtrabackup: This target seems to be already prepared.
  179. xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
  180. xtrabackup: Temporary instance for recovery is set as followings.
  181. xtrabackup:   innodb_data_home_dir = ./
  182. xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
  183. xtrabackup:   innodb_log_group_home_dir = ./
  184. xtrabackup:   innodb_log_files_in_group = 2
  185. xtrabackup:   innodb_log_file_size = 5242880
  186. xtrabackup: Temporary instance for recovery is set as followings.
  187. xtrabackup:   innodb_data_home_dir = ./
  188. xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
  189. xtrabackup:   innodb_log_group_home_dir = ./
  190. xtrabackup:   innodb_log_files_in_group = 2
  191. xtrabackup:   innodb_log_file_size = 5242880
  192. xtrabackup: Starting InnoDB instance for recovery.
  193. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
  194. 130205 10:46:08 InnoDB: The InnoDB memory heap is disabled
  195. 130205 10:46:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  196. 130205 10:46:08 InnoDB: Compressed tables use zlib 1.2.3
  197. 130205 10:46:08 InnoDB: Initializing buffer pool, size = 100.0M
  198. 130205 10:46:08 InnoDB: Completed initialization of buffer pool
  199. 130205 10:46:08  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
  200. InnoDB: Setting log file ./ib_logfile0 size to 5 MB
  201. InnoDB: Database physically writes the file full: wait...
  202. 130205 10:46:08  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
  203. InnoDB: Setting log file ./ib_logfile1 size to 5 MB
  204. InnoDB: Database physically writes the file full: wait...
  205. 130205 10:46:08 InnoDB: highest supported file format is Barracuda.
  206. InnoDB: The log sequence number in ibdata files does not match
  207. InnoDB: the log sequence number in the ib_logfiles!
  208. 130205 10:46:08  InnoDB: Database was not shut down normally!
  209. InnoDB: Starting crash recovery.
  210. InnoDB: Reading tablespace information from the .ibd files...
  211. 130205 10:46:08  InnoDB: Waiting for the background threads to start
  212. 130205 10:46:09 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1609740
  213.  
  214. [notice (again)]
  215.  If you use binary log and don't use any hack of group commit,
  216.   the binary log position seems to be:
  217.  
  218. xtrabackup: starting shutdown with innodb_fast_shutdown = 1
  219. 130205 10:46:09  InnoDB: Starting shutdown...
  220. 130205 10:46:13  InnoDB: Shutdown completed; log sequence number 1609740
  221. 130205 10:46:13  innobackupex: completed OK!
  222. [root@hostname mysql]#
  223. [root@hostname mysql]#
  224. [root@hostname mysql]#
  225. [root@hostname mysql]#
  226. [root@hostname mysql]#
  227. [root@hostname mysql]#
  228. [root@hostname mysql]# ls -alh /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
  229. -rw------- 1 root root 1.0M Feb  5 10:46 /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
  230. [root@hostname mysql]#
RAW Paste Data