Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 161104 10:42:43 innobackupex: Starting the backup operation
- IMPORTANT: Please check that the backup run completes successfully.
- At the end of a successful backup run innobackupex
- prints "completed OK!".
- 161104 10:42:44 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/data/DingoScratch_S1/mysql/mysql.sock' as 'dottey' (using password: YES).
- 161104 10:42:44 version_check Connected to MySQL server
- 161104 10:42:44 version_check Executing a version check against the server...
- 161104 10:42:44 version_check Done.
- 161104 10:42:44 Connecting to MySQL server host: localhost, user: dottey, password: set, port: 0, socket: /data/DingoScratch_S1/mysql/mysql.sock
- Using server version 5.5.37-cll-lve
- innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
- xtrabackup: uses posix_fadvise().
- xtrabackup: cd to /data/DingoScratch_S1/mysql
- xtrabackup: open files limit requested 0, set to 1024
- xtrabackup: using the following InnoDB configuration:
- 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
- InnoDB: Number of pools: 1
- 161104 10:42:44 >> log scanned up to (1072270639)
- xtrabackup: Generating a list of tablespaces
- 161104 10:42:44 [01] Copying ./ibdata1 to /var/backup/dottey-scratch/2016-11-04_10-42-43/ibdata1
- 161104 10:42:45 >> log scanned up to (1072270639)
- 161104 10:42:46 >> log scanned up to (1072270639)
- 161104 10:42:47 >> log scanned up to (1072270639)
- 161104 10:42:48 >> log scanned up to (1072270639)
- 161104 10:42:49 >> log scanned up to (1072270639)
- 161104 10:42:50 >> log scanned up to (1072270639)
- 161104 10:42:51 >> log scanned up to (1072270639)
- 161104 10:42:52 >> log scanned up to (1072270639)
- 161104 10:42:53 >> log scanned up to (1072270639)
- 161104 10:42:54 >> log scanned up to (1072270639)
- 161104 10:42:54 [01] ...done
- 161104 10:42:55 >> log scanned up to (1072270639)
- 161104 10:42:55 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
- 161104 10:42:55 Executing FLUSH TABLES WITH READ LOCK...
- 161104 10:42:55 Starting to backup non-InnoDB tables and files
- 161104 10:42:55 [01] Copying ./performance_schema/setup_consumers.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/setup_consumers.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/events_waits_summary_by_thread_by_event_name.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/db.opt to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/db.opt
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/events_waits_summary_global_by_event_name.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/cond_instances.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/cond_instances.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/setup_timers.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/setup_timers.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/file_summary_by_instance.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/file_summary_by_instance.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/events_waits_summary_by_instance.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/file_summary_by_event_name.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/rwlock_instances.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/rwlock_instances.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/threads.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/threads.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/events_waits_current.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/events_waits_current.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/performance_timers.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/performance_timers.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/events_waits_history.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/events_waits_history.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/file_instances.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/file_instances.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/setup_instruments.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/setup_instruments.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/mutex_instances.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/mutex_instances.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./performance_schema/events_waits_history_long.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/performance_schema/events_waits_history_long.frm
- 161104 10:42:55 [01] ...done
- ***** Redcated "Copying" statements with no errors *****
- 161104 10:42:55 [01] Copying ./mysql/proc.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/proc.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/columns_priv.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/columns_priv.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/servers.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/servers.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_name.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_name.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/host.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/host.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_topic.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_topic.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/proc.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/proc.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_category.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_category.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_topic.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_topic.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/procs_priv.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/procs_priv.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/func.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/func.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_relation.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_relation.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/columns_priv.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/columns_priv.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/ndb_binlog_index.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/ndb_binlog_index.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/plugin.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/plugin.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_transition_type.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/db.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/db.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/servers.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/servers.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/host.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/host.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/func.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/func.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_leap_second.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_leap_second.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_relation.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_relation.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/proc.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/proc.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/ndb_binlog_index.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/ndb_binlog_index.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_category.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_category.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/event.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/event.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/slow_log.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/slow_log.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/general_log.CSV to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/general_log.CSV
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/tables_priv.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/tables_priv.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_keyword.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_keyword.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/proxies_priv.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/proxies_priv.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_keyword.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_keyword.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_relation.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_relation.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/db.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/db.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/procs_priv.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/procs_priv.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_topic.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_topic.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_keyword.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_keyword.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/event.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/event.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/tables_priv.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/tables_priv.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/proxies_priv.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/proxies_priv.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/proxies_priv.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/proxies_priv.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/plugin.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/plugin.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/user.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/user.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_transition.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_transition.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_leap_second.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/host.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/host.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_transition_type.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_transition_type.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_name.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_name.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_leap_second.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/db.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/db.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/servers.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/servers.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/plugin.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/plugin.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/event.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/event.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_name.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_name.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/procs_priv.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/procs_priv.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/func.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/func.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/user.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/user.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/general_log.CSM to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/general_log.CSM
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_transition.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_transition.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/columns_priv.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/columns_priv.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_transition.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_transition.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/ndb_binlog_index.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/ndb_binlog_index.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/help_category.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/help_category.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/general_log.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/general_log.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/user.frm to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/user.frm
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/tables_priv.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/tables_priv.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone.MYD to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone.MYD
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/slow_log.CSV to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/slow_log.CSV
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/slow_log.CSM to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/slow_log.CSM
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/backup/dottey-scratch/2016-11-04_10-42-43/mysql/time_zone_transition_type.MYI
- 161104 10:42:55 [01] ...done
- 161104 10:42:55 [00] Writing test/db.opt
- 161104 10:42:55 [00] ...done
- 161104 10:42:55 Finished backing up non-InnoDB tables and files
- 161104 10:42:55 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
- xtrabackup: The latest check point (for incremental): '1072270639'
- xtrabackup: Stopping log copying thread.
- .161104 10:42:55 >> log scanned up to (1072270639)
- 161104 10:42:56 Executing UNLOCK TABLES
- 161104 10:42:56 All tables unlocked
- 161104 10:42:56 Backup created in directory '/var/backup/dottey-scratch/2016-11-04_10-42-43'
- 161104 10:42:56 [00] Writing backup-my.cnf
- 161104 10:42:56 [00] ...done
- 161104 10:42:56 [00] Writing xtrabackup_info
- 161104 10:42:56 [00] ...done
- xtrabackup: Transaction log of lsn (1072270639) to (1072270639) was copied.
- 161104 10:42:56 completed OK!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement