由于my.cnf里没有配置datadir参数导致数据库无法恢复

来源:互联网 发布:PHP api创建窗口 编辑:程序博客网 时间:2024/05/16 23:54

[root@localhostlib]# innobackupex --user=root --password=123456 --copy-back/root/2015-07-14_15-17-32/

 

InnoDBBackup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy

andPercona LLC and/or its affiliates 2009-2013. All Rights Reserved.

 

Thissoftware is published under

the GNUGENERAL PUBLIC LICENSE Version 2, June 1991.

 

Get thelatest version of Percona XtraBackup, documentation, and help resources:

http://www.percona.com/xb/p

 

15071416:42:04  innobackupex: Starting thecopy-back operation

 

IMPORTANT:Please check that the copy-back run completes successfully.

           At the end of a successful copy-back runinnobackupex

           prints "completed OK!".

 

innobackupex:got a fatal error with the following stacktrace: at /usr/bin/innobackupex line4545

        main::get_option('datadir') called at/usr/bin/innobackupex line 2450

        main::copy_back(0) called at/usr/bin/innobackupex line 1578

innobackupex: Error: no 'datadir' option in group 'mysqld' inserver configuration file '' at/usr/bin/innobackupexline 4545.

解决方法:

         此报错是由于/etc/my.cnf里面没有定义datadir变量,只需在此配置文件中添加即可

[root@localhost mysql]# vim /etc/my.cnf

[mysqld]

datadir=/usr/local/mysql/data

~

 [root@localhostmysql]# innobackupex --user=root --password=123456 --copy-back/root/2015-07-14_15-17-32/



InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.


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


Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p


150714 16:48:44  innobackupex: Starting the copy-back operation


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


innobackupex: Starting to copy files in '/root/2015-07-14_15-17-32'
innobackupex: back to original data directory '/usr/local/mysql/data'
innobackupex: Copying '/root/2015-07-14_15-17-32/xtrabackup_binlog_pos_innodb' to '/usr/local/mysql/data/xtrabackup_binlog_pos_innodb'
innobackupex: Copying '/root/2015-07-14_15-17-32/xtrabackup_info' to '/usr/local/mysql/data/xtrabackup_info'
innobackupex: Creating directory '/usr/local/mysql/data/@0024database2'
innobackupex: Copying '/root/2015-07-14_15-17-32/@0024database2/db.opt' to '/usr/local/mysql/data/@0024database2/db.opt'
innobackupex: Creating directory '/usr/local/mysql/data/test'
innobackupex: Copying '/root/2015-07-14_15-17-32/test/db.opt' to '/usr/local/mysql/data/test/db.opt'
innobackupex: Creating directory '/usr/local/mysql/data/tiankedb'
innobackupex: Copying '/root/2015-07-14_15-17-32/tiankedb/db.opt' to '/usr/local/mysql/data/tiankedb/db.opt'
innobackupex: Copying '/root/2015-07-14_15-17-32/tiankedb/tianke.frm' to '/usr/local/mysql/data/tiankedb/tianke.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/tiankedb/tianke.ibd' to '/usr/local/mysql/data/tiankedb/tianke.ibd'
innobackupex: Creating directory '/usr/local/mysql/data/jiaowu'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/totor.frm' to '/usr/local/mysql/data/jiaowu/totor.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/scores.ibd' to '/usr/local/mysql/data/jiaowu/scores.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students1.frm' to '/usr/local/mysql/data/jiaowu/students1.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sutdents2.ibd' to '/usr/local/mysql/data/jiaowu/sutdents2.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sutdents2.frm' to '/usr/local/mysql/data/jiaowu/sutdents2.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/totor.ibd' to '/usr/local/mysql/data/jiaowu/totor.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students1.ibd' to '/usr/local/mysql/data/jiaowu/students1.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/db.opt' to '/usr/local/mysql/data/jiaowu/db.opt'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students.ibd' to '/usr/local/mysql/data/jiaowu/students.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors1.ibd' to '/usr/local/mysql/data/jiaowu/tutors1.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors.frm' to '/usr/local/mysql/data/jiaowu/tutors.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors1.frm' to '/usr/local/mysql/data/jiaowu/tutors1.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students.frm' to '/usr/local/mysql/data/jiaowu/students.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors.ibd' to '/usr/local/mysql/data/jiaowu/tutors.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/courses.frm' to '/usr/local/mysql/data/jiaowu/courses.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sct.frm' to '/usr/local/mysql/data/jiaowu/sct.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sct2.ibd' to '/usr/local/mysql/data/jiaowu/sct2.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/courses.ibd' to '/usr/local/mysql/data/jiaowu/courses.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sct1.frm' to '/usr/local/mysql/data/jiaowu/sct1.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sct2.frm' to '/usr/local/mysql/data/jiaowu/sct2.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/scores.frm' to '/usr/local/mysql/data/jiaowu/scores.frm'
innobackupex: Creating directory '/usr/local/mysql/data/@0024database1'
innobackupex: Copying '/root/2015-07-14_15-17-32/@0024database1/db.opt' to '/usr/local/mysql/data/@0024database1/db.opt'
innobackupex: Creating directory '/usr/local/mysql/data/mysql'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/test.ibd' to '/usr/local/mysql/data/mysql/test.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_leap_second.MYI' to '/usr/local/mysql/data/mysql/time_zone_leap_second.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/servers.MYD' to '/usr/local/mysql/data/mysql/servers.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/db.MYD' to '/usr/local/mysql/data/mysql/db.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slow_log.frm' to '/usr/local/mysql/data/mysql/slow_log.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/testcourses.frm' to '/usr/local/mysql/data/mysql/testcourses.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/ndb_binlog_index.MYD' to '/usr/local/mysql/data/mysql/ndb_binlog_index.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone.MYD' to '/usr/local/mysql/data/mysql/time_zone.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/func.frm' to '/usr/local/mysql/data/mysql/func.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/plugin.MYI' to '/usr/local/mysql/data/mysql/plugin.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slave_relay_log_info.frm' to '/usr/local/mysql/data/mysql/slave_relay_log_info.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/event.frm' to '/usr/local/mysql/data/mysql/event.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_category.MYD' to '/usr/local/mysql/data/mysql/help_category.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/procs_priv.MYI' to '/usr/local/mysql/data/mysql/procs_priv.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone.MYI' to '/usr/local/mysql/data/mysql/time_zone.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/event.MYD' to '/usr/local/mysql/data/mysql/event.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/proc.MYI' to '/usr/local/mysql/data/mysql/proc.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/event.MYI' to '/usr/local/mysql/data/mysql/event.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/test2courese.frm' to '/usr/local/mysql/data/mysql/test2courese.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_name.MYI' to '/usr/local/mysql/data/mysql/time_zone_name.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/columns_priv.frm' to '/usr/local/mysql/data/mysql/columns_priv.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/ndb_binlog_index.frm' to '/usr/local/mysql/data/mysql/ndb_binlog_index.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/procs_priv.frm' to '/usr/local/mysql/data/mysql/procs_priv.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/general_log.CSV' to '/usr/local/mysql/data/mysql/general_log.CSV'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/test.frm' to '/usr/local/mysql/data/mysql/test.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_leap_second.MYD' to '/usr/local/mysql/data/mysql/time_zone_leap_second.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_category.MYI' to '/usr/local/mysql/data/mysql/help_category.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/user.MYI' to '/usr/local/mysql/data/mysql/user.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone.frm' to '/usr/local/mysql/data/mysql/time_zone.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/innodb_index_stats.ibd' to '/usr/local/mysql/data/mysql/innodb_index_stats.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_transition.frm' to '/usr/local/mysql/data/mysql/time_zone_transition.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slave_master_info.ibd' to '/usr/local/mysql/data/mysql/slave_master_info.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/tables_priv.MYI' to '/usr/local/mysql/data/mysql/tables_priv.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_relation.MYI' to '/usr/local/mysql/data/mysql/help_relation.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/columns_priv.MYI' to '/usr/local/mysql/data/mysql/columns_priv.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_topic.MYI' to '/usr/local/mysql/data/mysql/help_topic.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_keyword.MYD' to '/usr/local/mysql/data/mysql/help_keyword.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/student.ibd' to '/usr/local/mysql/data/mysql/student.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_topic.MYD' to '/usr/local/mysql/data/mysql/help_topic.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_name.MYD' to '/usr/local/mysql/data/mysql/time_zone_name.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/func.MYD' to '/usr/local/mysql/data/mysql/func.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/student.frm' to '/usr/local/mysql/data/mysql/student.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/innodb_table_stats.ibd' to '/usr/local/mysql/data/mysql/innodb_table_stats.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/servers.frm' to '/usr/local/mysql/data/mysql/servers.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_topic.frm' to '/usr/local/mysql/data/mysql/help_topic.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/ndb_binlog_index.MYI' to '/usr/local/mysql/data/mysql/ndb_binlog_index.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/innodb_index_stats.frm' to '/usr/local/mysql/data/mysql/innodb_index_stats.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slave_relay_log_info.ibd' to '/usr/local/mysql/data/mysql/slave_relay_log_info.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/general_log.frm' to '/usr/local/mysql/data/mysql/general_log.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/proxies_priv.MYI' to '/usr/local/mysql/data/mysql/proxies_priv.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/plugin.MYD' to '/usr/local/mysql/data/mysql/plugin.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slow_log.CSV' to '/usr/local/mysql/data/mysql/slow_log.CSV'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_keyword.MYI' to '/usr/local/mysql/data/mysql/help_keyword.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/servers.MYI' to '/usr/local/mysql/data/mysql/servers.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_relation.MYD' to '/usr/local/mysql/data/mysql/help_relation.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_transition_type.frm' to '/usr/local/mysql/data/mysql/time_zone_transition_type.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slave_worker_info.frm' to '/usr/local/mysql/data/mysql/slave_worker_info.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/proc.frm' to '/usr/local/mysql/data/mysql/proc.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/testcourses.ibd' to '/usr/local/mysql/data/mysql/testcourses.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/user.frm' to '/usr/local/mysql/data/mysql/user.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/plugin.frm' to '/usr/local/mysql/data/mysql/plugin.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_category.frm' to '/usr/local/mysql/data/mysql/help_category.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/test2courese.MYI' to '/usr/local/mysql/data/mysql/test2courese.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/func.MYI' to '/usr/local/mysql/data/mysql/func.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_transition_type.MYI' to '/usr/local/mysql/data/mysql/time_zone_transition_type.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_relation.frm' to '/usr/local/mysql/data/mysql/help_relation.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/proxies_priv.MYD' to '/usr/local/mysql/data/mysql/proxies_priv.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_transition.MYD' to '/usr/local/mysql/data/mysql/time_zone_transition.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slow_log.CSM' to '/usr/local/mysql/data/mysql/slow_log.CSM'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_leap_second.frm' to '/usr/local/mysql/data/mysql/time_zone_leap_second.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/columns_priv.MYD' to '/usr/local/mysql/data/mysql/columns_priv.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/proxies_priv.frm' to '/usr/local/mysql/data/mysql/proxies_priv.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/proc.MYD' to '/usr/local/mysql/data/mysql/proc.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/user.MYD' to '/usr/local/mysql/data/mysql/user.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/innodb_table_stats.frm' to '/usr/local/mysql/data/mysql/innodb_table_stats.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slave_worker_info.ibd' to '/usr/local/mysql/data/mysql/slave_worker_info.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/tables_priv.MYD' to '/usr/local/mysql/data/mysql/tables_priv.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_transition.MYI' to '/usr/local/mysql/data/mysql/time_zone_transition.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_transition_type.MYD' to '/usr/local/mysql/data/mysql/time_zone_transition_type.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/general_log.CSM' to '/usr/local/mysql/data/mysql/general_log.CSM'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/db.MYI' to '/usr/local/mysql/data/mysql/db.MYI'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/slave_master_info.frm' to '/usr/local/mysql/data/mysql/slave_master_info.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/courses.frm' to '/usr/local/mysql/data/mysql/courses.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/time_zone_name.frm' to '/usr/local/mysql/data/mysql/time_zone_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/courses.ibd' to '/usr/local/mysql/data/mysql/courses.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/test2courese.MYD' to '/usr/local/mysql/data/mysql/test2courese.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/help_keyword.frm' to '/usr/local/mysql/data/mysql/help_keyword.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/tables_priv.frm' to '/usr/local/mysql/data/mysql/tables_priv.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/procs_priv.MYD' to '/usr/local/mysql/data/mysql/procs_priv.MYD'
innobackupex: Copying '/root/2015-07-14_15-17-32/mysql/db.frm' to '/usr/local/mysql/data/mysql/db.frm'
innobackupex: Creating directory '/usr/local/mysql/data/edb'
innobackupex: Copying '/root/2015-07-14_15-17-32/edb/db.opt' to '/usr/local/mysql/data/edb/db.opt'
innobackupex: Creating directory '/usr/local/mysql/data/performance_schema'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/setup_timers.frm' to '/usr/local/mysql/data/performance_schema/setup_timers.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/socket_summary_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/socket_summary_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_history.frm' to '/usr/local/mysql/data/performance_schema/events_statements_history.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/setup_objects.frm' to '/usr/local/mysql/data/performance_schema/setup_objects.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_summary_global_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_statements_summary_global_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/cond_instances.frm' to '/usr/local/mysql/data/performance_schema/cond_instances.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_summary_by_thread_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_waits_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/file_instances.frm' to '/usr/local/mysql/data/performance_schema/file_instances.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/performance_timers.frm' to '/usr/local/mysql/data/performance_schema/performance_timers.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/mutex_instances.frm' to '/usr/local/mysql/data/performance_schema/mutex_instances.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_summary_by_user_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_stages_summary_by_user_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/setup_consumers.frm' to '/usr/local/mysql/data/performance_schema/setup_consumers.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_history_long.frm' to '/usr/local/mysql/data/performance_schema/events_statements_history_long.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/hosts.frm' to '/usr/local/mysql/data/performance_schema/hosts.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/session_account_connect_attrs.frm' to '/usr/local/mysql/data/performance_schema/session_account_connect_attrs.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_summary_by_host_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_stages_summary_by_host_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_summary_by_thread_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_stages_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_summary_global_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_stages_summary_global_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_summary_by_host_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_waits_summary_by_host_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/setup_instruments.frm' to '/usr/local/mysql/data/performance_schema/setup_instruments.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/objects_summary_global_by_type.frm' to '/usr/local/mysql/data/performance_schema/objects_summary_global_by_type.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_current.frm' to '/usr/local/mysql/data/performance_schema/events_stages_current.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_history_long.frm' to '/usr/local/mysql/data/performance_schema/events_waits_history_long.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_history_long.frm' to '/usr/local/mysql/data/performance_schema/events_stages_history_long.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_summary_by_account_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_statements_summary_by_account_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/rwlock_instances.frm' to '/usr/local/mysql/data/performance_schema/rwlock_instances.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/socket_summary_by_instance.frm' to '/usr/local/mysql/data/performance_schema/socket_summary_by_instance.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_current.frm' to '/usr/local/mysql/data/performance_schema/events_statements_current.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_summary_by_thread_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_statements_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/users.frm' to '/usr/local/mysql/data/performance_schema/users.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/db.opt' to '/usr/local/mysql/data/performance_schema/db.opt'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_current.frm' to '/usr/local/mysql/data/performance_schema/events_waits_current.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/setup_actors.frm' to '/usr/local/mysql/data/performance_schema/setup_actors.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_summary_by_user_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_statements_summary_by_user_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/threads.frm' to '/usr/local/mysql/data/performance_schema/threads.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/accounts.frm' to '/usr/local/mysql/data/performance_schema/accounts.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_history.frm' to '/usr/local/mysql/data/performance_schema/events_stages_history.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/file_summary_by_instance.frm' to '/usr/local/mysql/data/performance_schema/file_summary_by_instance.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_summary_global_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_waits_summary_global_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_summary_by_user_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_waits_summary_by_user_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/file_summary_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/file_summary_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_summary_by_instance.frm' to '/usr/local/mysql/data/performance_schema/events_waits_summary_by_instance.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/session_connect_attrs.frm' to '/usr/local/mysql/data/performance_schema/session_connect_attrs.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/table_lock_waits_summary_by_table.frm' to '/usr/local/mysql/data/performance_schema/table_lock_waits_summary_by_table.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_stages_summary_by_account_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_stages_summary_by_account_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_summary_by_digest.frm' to '/usr/local/mysql/data/performance_schema/events_statements_summary_by_digest.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/table_io_waits_summary_by_index_usage.frm' to '/usr/local/mysql/data/performance_schema/table_io_waits_summary_by_index_usage.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_history.frm' to '/usr/local/mysql/data/performance_schema/events_waits_history.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/socket_instances.frm' to '/usr/local/mysql/data/performance_schema/socket_instances.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_statements_summary_by_host_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_statements_summary_by_host_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/events_waits_summary_by_account_by_event_name.frm' to '/usr/local/mysql/data/performance_schema/events_waits_summary_by_account_by_event_name.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/host_cache.frm' to '/usr/local/mysql/data/performance_schema/host_cache.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/performance_schema/table_io_waits_summary_by_table.frm' to '/usr/local/mysql/data/performance_schema/table_io_waits_summary_by_table.frm'
innobackupex: Creating directory '/usr/local/mysql/data/students'
innobackupex: Copying '/root/2015-07-14_15-17-32/students/db.opt' to '/usr/local/mysql/data/students/db.opt'


innobackupex: Starting to copy InnoDB system tablespace
innobackupex: in '/root/2015-07-14_15-17-32'
innobackupex: back to original InnoDB data directory '/usr/local/mysql/data'
innobackupex: Copying '/root/2015-07-14_15-17-32/ibdata1' to '/usr/local/mysql/data/ibdata1'


innobackupex: Starting to copy InnoDB undo tablespaces
innobackupex: in '/root/2015-07-14_15-17-32'
innobackupex: back to '/usr/local/mysql/data'


innobackupex: Starting to copy InnoDB log files
innobackupex: in '/root/2015-07-14_15-17-32'
innobackupex: back to original InnoDB log directory '/usr/local/mysql/data'
innobackupex: Copying '/root/2015-07-14_15-17-32/ib_logfile0' to '/usr/local/mysql/data/ib_logfile0'
innobackupex: Copying '/root/2015-07-14_15-17-32/ib_logfile1' to '/usr/local/mysql/data/ib_logfile1'
innobackupex: Finished copying back files.


150714 16:48:45  innobackupex: completed OK!

0 0
原创粉丝点击