API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 10th, 2016
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.49 KB | None | 0 0
raw download clone embed print report
  1. $ innobackupex --user=root --no-timestamp $PWD/backup
  2. 160910 19:27:35 innobackupex: Starting the backup operation
  3.  
  4. IMPORTANT: Please check that the backup run completes successfully.
  5. At the end of a successful backup run innobackupex
  6. prints "completed OK!".
  7.  
  8. 160910 19:27:35 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'root' (using password: NO).
  9. 160910 19:27:35 version_check Connected to MySQL server
  10. 160910 19:27:35 version_check Executing a version check against the server...
  11. 160910 19:27:35 version_check Done.
  12. 160910 19:27:35 Connecting to MySQL server host: localhost, user: root, password: not set, port: 0, socket: /var/lib/mysql/mysql.sock
  13. Using server version 5.6.32-log
  14. innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
  15. xtrabackup: uses posix_fadvise().
  16. xtrabackup: cd to /mnt/data/mysql
  17. xtrabackup: open files limit requested 0, set to 1024
  18. xtrabackup: using the following InnoDB configuration:
  19. xtrabackup: innodb_data_home_dir = .
  20. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  21. xtrabackup: innodb_log_group_home_dir = ./
  22. xtrabackup: innodb_log_files_in_group = 2
  23. xtrabackup: innodb_log_file_size = 50331648
  24. InnoDB: Number of pools: 1
  25. 160910 19:27:42 >> log scanned up to (86118369257)
  26. xtrabackup: Generating a list of tablespaces
  27. InnoDB: Allocated tablespace ID 16 for oregakangaetasaikyounodb/item, old maximum was 0
  28. 160910 19:27:42 [01] Copying ./ibdata1 to /root/backup/ibdata1
  29. 160910 19:27:46 >> log scanned up to (86191978094)
  30. 160910 19:27:48 >> log scanned up to (86246281883)
  31. 160910 19:27:50 >> log scanned up to (86270984764)
  32. 160910 19:27:52 >> log scanned up to (86320396365)
  33. 160910 19:27:55 >> log scanned up to (86359671351)
  34. 160910 19:27:57 >> log scanned up to (86415522368)
  35. 160910 19:28:00 >> log scanned up to (86466187858)
  36. 160910 19:45:12 Executing FLUSH TABLES WITH READ LOCK...
  37. 160910 19:45:12 Starting to backup non-InnoDB tables and files
  38. 160910 19:45:12 [01] Copying ./oregakangaetasaikyounodb/item.frm to /root/backup/oregakangaetasaikyounodb/item.frm
  39. 160910 19:45:12 [01] ...done
  40. 160910 19:45:12 [01] Copying ./oregakangaetasaikyounodb/db.opt to /root/backup/oregakangaetasaikyounodb/db.opt
  41. 160910 19:45:12 [01] ...done
  42. 160910 19:45:12 [01] Copying ./orenodb/item.frm to /root/backup/orenodb/item.frm
  43. 160910 19:45:12 [01] ...done
  44. 160910 19:45:12 [01] Copying ./orenodb/db.opt to /root/backup/orenodb/db.opt
  45. 160910 19:45:12 [01] ...done
  46. 160910 19:45:12 [01] Copying ./mysql/columns_priv.frm to /root/backup/mysql/columns_priv.frm
  47. 160910 19:45:12 [01] ...done
  48. 160910 19:45:12 [01] Copying ./mysql/ndb_binlog_index.frm to /root/backup/mysql/ndb_binlog_index.frm
  49. 160910 19:45:12 [01] ...done
  50. 160910 19:45:12 [01] Copying ./mysql/event.frm to /root/backup/mysql/event.frm
  51. 160910 19:45:12 [01] ...done
  52. 160910 19:45:12 [01] Copying ./mysql/proxies_priv.frm to /root/backup/mysql/proxies_priv.frm
  53. 160910 19:45:12 [01] ...done
  54. 160910 19:45:12 [01] Copying ./mysql/ndb_binlog_index.MYD to /root/backup/mysql/ndb_binlog_index.MYD
  55. 160910 19:45:12 [01] ...done
  56. 160910 19:45:12 [01] Copying ./mysql/time_zone.MYI to /root/backup/mysql/time_zone.MYI
  57. 160910 19:45:12 [01] ...done
  58. 160910 19:45:12 [01] Copying ./mysql/time_zone_leap_second.MYD to /root/backup/mysql/time_zone_leap_second.MYD
  59. 160910 19:45:12 [01] ...done
  60. 160910 19:45:12 [01] Copying ./mysql/help_category.frm to /root/backup/mysql/help_category.frm
  61. 160910 19:45:12 [01] ...done
  62. 160910 19:45:12 [01] Copying ./mysql/plugin.frm to /root/backup/mysql/plugin.frm
  63. 160910 19:45:12 [01] ...done
  64. 160910 19:45:12 [01] Copying ./mysql/help_keyword.MYD to /root/backup/mysql/help_keyword.MYD
  65. 160910 19:45:12 [01] ...done
  66. 160910 19:45:12 [01] Copying ./mysql/time_zone.MYD to /root/backup/mysql/time_zone.MYD
  67. 160910 19:45:12 [01] ...done
  68. 160910 19:45:12 [01] Copying ./mysql/servers.MYI to /root/backup/mysql/servers.MYI
  69. 160910 19:45:12 [01] ...done
  70. 160910 19:45:13 [01] Copying ./mysql/plugin.MYD to /root/backup/mysql/plugin.MYD
  71. 160910 19:45:13 [01] ...done
  72. 160910 19:45:13 [01] Copying ./mysql/tables_priv.MYD to /root/backup/mysql/tables_priv.MYD
  73. 160910 19:45:13 [01] ...done
  74. 160910 19:45:13 [01] Copying ./mysql/slow_log.CSM to /root/backup/mysql/slow_log.CSM
  75. 160910 19:45:13 [01] ...done
  76. 160910 19:45:13 [01] Copying ./mysql/procs_priv.MYI to /root/backup/mysql/procs_priv.MYI
  77. 160910 19:45:13 [01] ...done
  78. 160910 19:45:13 [01] Copying ./mysql/event.MYI to /root/backup/mysql/event.MYI
  79. 160910 19:45:13 [01] ...done
  80. 160910 19:45:13 [01] Copying ./mysql/time_zone_leap_second.MYI to /root/backup/mysql/time_zone_leap_second.MYI
  81. 160910 19:45:13 [01] ...done
  82. 160910 19:45:13 [01] Copying ./mysql/user.frm to /root/backup/mysql/user.frm
  83. 160910 19:45:13 [01] ...done
  84. 160910 19:45:13 [01] Copying ./mysql/help_relation.frm to /root/backup/mysql/help_relation.frm
  85. 160910 19:45:13 [01] ...done
  86. 160910 19:45:13 [01] Copying ./mysql/db.frm to /root/backup/mysql/db.frm
  87. 160910 19:45:13 [01] ...done
  88. 160910 19:45:13 [01] Copying ./mysql/help_category.MYD to /root/backup/mysql/help_category.MYD
  89. 160910 19:45:13 [01] ...done
  90. 160910 19:45:13 [01] Copying ./mysql/slow_log.frm to /root/backup/mysql/slow_log.frm
  91. 160910 19:45:13 [01] ...done
  92. 160910 19:45:13 [01] Copying ./mysql/proxies_priv.MYI to /root/backup/mysql/proxies_priv.MYI
  93. 160910 19:45:13 [01] ...done
  94. 160910 19:45:13 [01] Copying ./mysql/time_zone_transition_type.MYD to /root/backup/mysql/time_zone_transition_type.MYD
  95. 160910 19:45:13 [01] ...done
  96. 160910 19:45:13 [01] Copying ./mysql/slave_worker_info.frm to /root/backup/mysql/slave_worker_info.frm
  97. 160910 19:45:13 [01] ...done
  98. 160910 19:45:13 [01] Copying ./mysql/ndb_binlog_index.MYI to /root/backup/mysql/ndb_binlog_index.MYI
  99. 160910 19:45:13 [01] ...done
  100. 160910 19:45:13 [01] Copying ./mysql/time_zone_name.frm to /root/backup/mysql/time_zone_name.frm
  101. 160910 19:45:13 [01] ...done
  102. 160910 19:45:13 [01] Copying ./mysql/help_topic.MYI to /root/backup/mysql/help_topic.MYI
  103. 160910 19:45:13 [01] ...done
  104. 160910 19:45:13 [01] Copying ./mysql/help_topic.MYD to /root/backup/mysql/help_topic.MYD
  105. 160910 19:45:13 [01] ...done
  106. 160910 19:45:13 [01] Copying ./mysql/time_zone_leap_second.frm to /root/backup/mysql/time_zone_leap_second.frm
  107. 160910 19:45:13 [01] ...done
  108. 160910 19:45:13 [01] Copying ./mysql/tables_priv.MYI to /root/backup/mysql/tables_priv.MYI
  109. 160910 19:45:13 [01] ...done
  110. 160910 19:45:13 [01] Copying ./mysql/tables_priv.frm to /root/backup/mysql/tables_priv.frm
  111. 160910 19:45:13 [01] ...done
  112. 160910 19:45:13 [01] Copying ./mysql/time_zone_name.MYD to /root/backup/mysql/time_zone_name.MYD
  113. 160910 19:45:13 [01] ...done
  114. 160910 19:45:13 [01] Copying ./mysql/slow_log.CSV to /root/backup/mysql/slow_log.CSV
  115. 160910 19:45:13 [01] ...done
  116. 160910 19:45:13 [01] Copying ./mysql/help_relation.MYI to /root/backup/mysql/help_relation.MYI
  117. 160910 19:45:13 [01] ...done
  118. 160910 19:45:13 [01] Copying ./mysql/time_zone_transition_type.frm to /root/backup/mysql/time_zone_transition_type.frm
  119. 160910 19:45:13 [01] ...done
  120. 160910 19:45:13 [01] Copying ./mysql/db.MYD to /root/backup/mysql/db.MYD
  121. 160910 19:45:13 [01] ...done
  122. 160910 19:45:13 [01] Copying ./mysql/time_zone_transition_type.MYI to /root/backup/mysql/time_zone_transition_type.MYI
  123. 160910 19:45:13 [01] ...done
  124. 160910 19:45:13 [01] Copying ./mysql/slave_master_info.frm to /root/backup/mysql/slave_master_info.frm
  125. 160910 19:45:13 [01] ...done
  126. 160910 19:45:13 [01] Copying ./mysql/plugin.MYI to /root/backup/mysql/plugin.MYI
  127. 160910 19:45:13 [01] ...done
  128. 160910 19:45:13 [01] Copying ./mysql/general_log.CSM to /root/backup/mysql/general_log.CSM
  129. 160910 19:45:13 [01] ...done
  130. 160910 19:45:13 [01] Copying ./mysql/func.MYI to /root/backup/mysql/func.MYI
  131. 160910 19:45:13 [01] ...done
  132. 160910 19:45:13 [01] Copying ./mysql/time_zone_transition.MYD to /root/backup/mysql/time_zone_transition.MYD
  133. 160910 19:45:13 [01] ...done
  134. 160910 19:45:13 [01] Copying ./mysql/help_keyword.frm to /root/backup/mysql/help_keyword.frm
  135. 160910 19:45:13 [01] ...done
  136. 160910 19:45:13 [01] Copying ./mysql/help_topic.frm to /root/backup/mysql/help_topic.frm
  137. 160910 19:45:13 [01] ...done
  138. 160910 19:45:13 [01] Copying ./mysql/procs_priv.MYD to /root/backup/mysql/procs_priv.MYD
  139. 160910 19:45:13 [01] ...done
  140. 160910 19:45:13 [01] Copying ./mysql/event.MYD to /root/backup/mysql/event.MYD
  141. 160910 19:45:13 [01] ...done
  142. 160910 19:45:13 [01] Copying ./mysql/innodb_index_stats.frm to /root/backup/mysql/innodb_index_stats.frm
  143. 160910 19:45:13 [01] ...done
  144. 160910 19:45:13 [01] Copying ./mysql/time_zone.frm to /root/backup/mysql/time_zone.frm
  145. 160910 19:45:13 [01] ...done
  146. 160910 19:45:13 [01] Copying ./mysql/servers.MYD to /root/backup/mysql/servers.MYD
  147. 160910 19:45:13 [01] ...done
  148. 160910 19:45:13 [01] Copying ./mysql/proc.MYI to /root/backup/mysql/proc.MYI
  149. 160910 19:45:13 [01] ...done
  150. 160910 19:45:13 [01] Copying ./mysql/help_relation.MYD to /root/backup/mysql/help_relation.MYD
  151. 160910 19:45:13 [01] ...done
  152. 160910 19:45:13 [01] Copying ./mysql/func.MYD to /root/backup/mysql/func.MYD
  153. 160910 19:45:13 [01] ...done
  154. 160910 19:45:13 [01] Copying ./mysql/general_log.CSV to /root/backup/mysql/general_log.CSV
  155. 160910 19:45:13 [01] ...done
  156. 160910 19:45:13 [01] Copying ./mysql/proc.frm to /root/backup/mysql/proc.frm
  157. 160910 19:45:13 [01] ...done
  158. 160910 19:45:13 [01] Copying ./mysql/user.MYD to /root/backup/mysql/user.MYD
  159. 160910 19:45:13 [01] ...done
  160. 160910 19:45:13 [01] Copying ./mysql/func.frm to /root/backup/mysql/func.frm
  161. 160910 19:45:13 [01] ...done
  162. 160910 19:45:13 [01] Copying ./mysql/servers.frm to /root/backup/mysql/servers.frm
  163. 160910 19:45:13 [01] ...done
  164. 160910 19:45:13 [01] Copying ./mysql/help_keyword.MYI to /root/backup/mysql/help_keyword.MYI
  165. 160910 19:45:13 [01] ...done
  166. 160910 19:45:13 [01] Copying ./mysql/proxies_priv.MYD to /root/backup/mysql/proxies_priv.MYD
  167. 160910 19:45:13 [01] ...done
  168. 160910 19:45:13 [01] Copying ./mysql/time_zone_name.MYI to /root/backup/mysql/time_zone_name.MYI
  169. 160910 19:45:13 [01] ...done
  170. 160910 19:45:13 [01] Copying ./mysql/proc.MYD to /root/backup/mysql/proc.MYD
  171. 160910 19:45:13 [01] ...done
  172. 160910 19:45:13 [01] Copying ./mysql/time_zone_transition.MYI to /root/backup/mysql/time_zone_transition.MYI
  173. 160910 19:45:13 [01] ...done
  174. 160910 19:45:13 [01] Copying ./mysql/time_zone_transition.frm to /root/backup/mysql/time_zone_transition.frm
  175. 160910 19:45:13 [01] ...done
  176. 160910 19:45:13 [01] Copying ./mysql/user.MYI to /root/backup/mysql/user.MYI
  177. 160910 19:45:13 [01] ...done
  178. 160910 19:45:13 [01] Copying ./mysql/procs_priv.frm to /root/backup/mysql/procs_priv.frm
  179. 160910 19:45:13 [01] ...done
  180. 160910 19:45:13 [01] Copying ./mysql/general_log.frm to /root/backup/mysql/general_log.frm
  181. 160910 19:45:13 [01] ...done
  182. 160910 19:45:13 [01] Copying ./mysql/columns_priv.MYD to /root/backup/mysql/columns_priv.MYD
  183. 160910 19:45:13 [01] ...done
  184. 160910 19:45:13 [01] Copying ./mysql/help_category.MYI to /root/backup/mysql/help_category.MYI
  185. 160910 19:45:13 [01] ...done
  186. 160910 19:45:13 [01] Copying ./mysql/innodb_table_stats.frm to /root/backup/mysql/innodb_table_stats.frm
  187. 160910 19:45:13 [01] ...done
  188. 160910 19:45:13 [01] Copying ./mysql/slave_relay_log_info.frm to /root/backup/mysql/slave_relay_log_info.frm
  189. 160910 19:45:13 [01] ...done
  190. 160910 19:45:13 [01] Copying ./mysql/db.MYI to /root/backup/mysql/db.MYI
  191. 160910 19:45:13 [01] ...done
  192. 160910 19:45:13 [01] Copying ./mysql/columns_priv.MYI to /root/backup/mysql/columns_priv.MYI
  193. 160910 19:45:13 [01] ...done
  194. 160910 19:45:13 [01] Copying ./oregakangaetakuraudoikouyounodb/item.frm to /root/backup/oregakangaetakuraudoikouyounodb/item.frm
  195. 160910 19:45:13 [01] ...done
  196. 160910 19:45:13 [01] Copying ./oregakangaetakuraudoikouyounodb/db.opt to /root/backup/oregakangaetakuraudoikouyounodb/db.opt
  197. 160910 19:45:13 [01] ...done
  198. 160910 19:45:13 [01] Copying ./performance_schema/accounts.frm to /root/backup/performance_schema/accounts.frm
  199. 160910 19:45:13 [01] ...done
  200. 160910 19:45:13 [01] Copying ./performance_schema/setup_instruments.frm to /root/backup/performance_schema/setup_instruments.frm
  201. 160910 19:45:13 [01] ...done
  202. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /root/backup/performance_schema/events_waits_summary_global_by_event_name.frm
  203. 160910 19:45:13 [01] ...done
  204. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /root/backup/performance_schema/events_statements_summary_global_by_event_name.frm
  205. 160910 19:45:13 [01] ...done
  206. 160910 19:45:13 [01] Copying ./performance_schema/cond_instances.frm to /root/backup/performance_schema/cond_instances.frm
  207. 160910 19:45:13 [01] ...done
  208. 160910 19:45:13 [01] Copying ./performance_schema/session_connect_attrs.frm to /root/backup/performance_schema/session_connect_attrs.frm
  209. 160910 19:45:13 [01] ...done
  210. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_history_long.frm to /root/backup/performance_schema/events_statements_history_long.frm
  211. 160910 19:45:13 [01] ...done
  212. 160910 19:45:13 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /root/backup/performance_schema/table_lock_waits_summary_by_table.frm
  213. 160910 19:45:13 [01] ...done
  214. 160910 19:45:13 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /root/backup/performance_schema/table_io_waits_summary_by_index_usage.frm
  215. 160910 19:45:13 [01] ...done
  216. 160910 19:45:13 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /root/backup/performance_schema/table_io_waits_summary_by_table.frm
  217. 160910 19:45:13 [01] ...done
  218. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /root/backup/performance_schema/events_waits_summary_by_user_by_event_name.frm
  219. 160910 19:45:13 [01] ...done
  220. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_history.frm to /root/backup/performance_schema/events_waits_history.frm
  221. 160910 19:45:13 [01] ...done
  222. 160910 19:45:13 [01] Copying ./performance_schema/host_cache.frm to /root/backup/performance_schema/host_cache.frm
  223. 160910 19:45:13 [01] ...done
  224. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /root/backup/performance_schema/events_waits_summary_by_thread_by_event_name.frm
  225. 160910 19:45:13 [01] ...done
  226. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /root/backup/performance_schema/events_waits_summary_by_account_by_event_name.frm
  227. 160910 19:45:13 [01] ...done
  228. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /root/backup/performance_schema/events_stages_summary_global_by_event_name.frm
  229. 160910 19:45:13 [01] ...done
  230. 160910 19:45:13 [01] Copying ./performance_schema/socket_instances.frm to /root/backup/performance_schema/socket_instances.frm
  231. 160910 19:45:13 [01] ...done
  232. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /root/backup/performance_schema/events_statements_summary_by_host_by_event_name.frm
  233. 160910 19:45:13 [01] ...done
  234. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_history.frm to /root/backup/performance_schema/events_statements_history.frm
  235. 160910 19:45:13 [01] ...done
  236. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /root/backup/performance_schema/events_waits_summary_by_host_by_event_name.frm
  237. 160910 19:45:13 [01] ...done
  238. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_history_long.frm to /root/backup/performance_schema/events_waits_history_long.frm
  239. 160910 19:45:13 [01] ...done
  240. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /root/backup/performance_schema/events_statements_summary_by_user_by_event_name.frm
  241. 160910 19:45:13 [01] ...done
  242. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /root/backup/performance_schema/events_stages_summary_by_account_by_event_name.frm
  243. 160910 19:45:13 [01] ...done
  244. 160910 19:45:13 [01] Copying ./performance_schema/file_instances.frm to /root/backup/performance_schema/file_instances.frm
  245. 160910 19:45:13 [01] ...done
  246. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_current.frm to /root/backup/performance_schema/events_waits_current.frm
  247. 160910 19:45:13 [01] ...done
  248. 160910 19:45:13 [01] Copying ./performance_schema/mutex_instances.frm to /root/backup/performance_schema/mutex_instances.frm
  249. 160910 19:45:13 [01] ...done
  250. 160910 19:45:13 [01] Copying ./performance_schema/rwlock_instances.frm to /root/backup/performance_schema/rwlock_instances.frm
  251. 160910 19:45:13 [01] ...done
  252. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_history_long.frm to /root/backup/performance_schema/events_stages_history_long.frm
  253. 160910 19:45:13 [01] ...done
  254. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /root/backup/performance_schema/events_statements_summary_by_digest.frm
  255. 160910 19:45:13 [01] ...done
  256. 160910 19:45:13 [01] Copying ./performance_schema/users.frm to /root/backup/performance_schema/users.frm
  257. 160910 19:45:13 [01] ...done
  258. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /root/backup/performance_schema/events_statements_summary_by_thread_by_event_name.frm
  259. 160910 19:45:13 [01] ...done
  260. 160910 19:45:13 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /root/backup/performance_schema/file_summary_by_event_name.frm
  261. 160910 19:45:13 [01] ...done
  262. 160910 19:45:13 [01] Copying ./performance_schema/file_summary_by_instance.frm to /root/backup/performance_schema/file_summary_by_instance.frm
  263. 160910 19:45:13 [01] ...done
  264. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /root/backup/performance_schema/events_stages_summary_by_thread_by_event_name.frm
  265. 160910 19:45:13 [01] ...done
  266. 160910 19:45:13 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /root/backup/performance_schema/session_account_connect_attrs.frm
  267. 160910 19:45:13 [01] ...done
  268. 160910 19:45:13 [01] Copying ./performance_schema/threads.frm to /root/backup/performance_schema/threads.frm
  269. 160910 19:45:13 [01] ...done
  270. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /root/backup/performance_schema/events_stages_summary_by_host_by_event_name.frm
  271. 160910 19:45:13 [01] ...done
  272. 160910 19:45:13 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /root/backup/performance_schema/objects_summary_global_by_type.frm
  273. 160910 19:45:13 [01] ...done
  274. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_current.frm to /root/backup/performance_schema/events_stages_current.frm
  275. 160910 19:45:13 [01] ...done
  276. 160910 19:45:13 [01] Copying ./performance_schema/setup_objects.frm to /root/backup/performance_schema/setup_objects.frm
  277. 160910 19:45:13 [01] ...done
  278. 160910 19:45:13 [01] Copying ./performance_schema/hosts.frm to /root/backup/performance_schema/hosts.frm
  279. 160910 19:45:13 [01] ...done
  280. 160910 19:45:13 [01] Copying ./performance_schema/performance_timers.frm to /root/backup/performance_schema/performance_timers.frm
  281. 160910 19:45:13 [01] ...done
  282. 160910 19:45:13 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /root/backup/performance_schema/events_waits_summary_by_instance.frm
  283. 160910 19:45:13 [01] ...done
  284. 160910 19:45:13 [01] Copying ./performance_schema/setup_actors.frm to /root/backup/performance_schema/setup_actors.frm
  285. 160910 19:45:13 [01] ...done
  286. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /root/backup/performance_schema/events_stages_summary_by_user_by_event_name.frm
  287. 160910 19:45:13 [01] ...done
  288. 160910 19:45:13 [01] Copying ./performance_schema/setup_consumers.frm to /root/backup/performance_schema/setup_consumers.frm
  289. 160910 19:45:13 [01] ...done
  290. 160910 19:45:13 [01] Copying ./performance_schema/setup_timers.frm to /root/backup/performance_schema/setup_timers.frm
  291. 160910 19:45:13 [01] ...done
  292. 160910 19:45:13 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /root/backup/performance_schema/socket_summary_by_event_name.frm
  293. 160910 19:45:13 [01] ...done
  294. 160910 19:45:13 [01] Copying ./performance_schema/db.opt to /root/backup/performance_schema/db.opt
  295. 160910 19:45:13 [01] ...done
  296. 160910 19:45:13 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /root/backup/performance_schema/socket_summary_by_instance.frm
  297. 160910 19:45:13 [01] ...done
  298. 160910 19:45:13 [01] Copying ./performance_schema/events_stages_history.frm to /root/backup/performance_schema/events_stages_history.frm
  299. 160910 19:45:13 [01] ...done
  300. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_current.frm to /root/backup/performance_schema/events_statements_current.frm
  301. 160910 19:45:13 [01] ...done
  302. 160910 19:45:13 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /root/backup/performance_schema/events_statements_summary_by_account_by_event_name.frm
  303. 160910 19:45:13 [01] ...done
  304. 160910 19:45:13 Finished backing up non-InnoDB tables and files
  305. 160910 19:45:13 [00] Writing xtrabackup_binlog_info
  306. 160910 19:45:13 [00] ...done
  307. 160910 19:45:13 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
  308. xtrabackup: The latest check point (for incremental): '109440352999'
  309. xtrabackup: Stopping log copying thread.
  310. ..160910 19:45:13 >> log scanned up to (109465256896)
  311.  
  312. 160910 19:45:13 Executing UNLOCK TABLES
  313. 160910 19:45:13 All tables unlocked
  314. 160910 19:45:13 Backup created in directory '/root/backup'
  315. MySQL binlog position: filename 'mysqld-bin.000003', position '1766'
  316. 160910 19:45:13 [00] Writing backup-my.cnf
  317. 160910 19:45:13 [00] ...done
  318. 160910 19:45:13 [00] Writing xtrabackup_info
  319. 160910 19:45:13 [00] ...done
  320. xtrabackup: Transaction log of lsn (85899943219) to (109465256896) was copied.
  321. 160910 19:45:13 completed OK!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!