由于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!
- 由于my.cnf里没有配置datadir参数导致数据库无法恢复
- my.cnf配置参数介绍
- MySQL的my.cnf配置参数详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL的my.cnf配置参数详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- MySQL my.cnf参数配置优化详解
- 工商移动执法指挥系统
- 排序算法的分析总结
- 原码、反码、补码和移码其实很简单
- hdu2089 数位dp
- 栈的代码
- 由于my.cnf里没有配置datadir参数导致数据库无法恢复
- centos上部署邮件服务器
- spring 简单属性注入
- IT牛人的博客地址——收藏
- FuzzyKmeans的Mahout实现
- solr空间搜索实现附近酒店的搜索
- JAVA开源数据库连接池比较
- Android进阶之大话设计模式
- 2012年5月SAT香港真题解析