MySQL innodb引擎备份工具XtraBackup之二（数据库全备）
发布时间：2025-11-05 02:45:36 来源：创站工坊 作者：系统运维
复制151028 14:18:16 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the endof a successful backup run innobackupex prints "completed OK!". 151028 14:18:16 version_check Connecting to MySQL server with DSN dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sockasbakusr (using password: YES). 151028 14:18:16 version_check Connected to MySQL server 151028 14:18:16 version_check Executing a version check against the server... 151028 14:18:16 version_check Done. 151028 14:18:16 Connecting to MySQL server host: localhost,擎备 user: bakusr, password: set, port: 0, socket: /var/lib/mysql/mysql.sock Using server version 5.6.25-73.1 innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, setto 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:12M;ibdata2:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 151028 14:18:16 >> log scanned up to (13254527) xtrabackup: Generating a list of tablespaces 151028 14:18:16 [01] Copying ./ibdata1 to /data/mysql/backup/full/2015-10-28_14-18-16/ibdata1 151028 14:18:17 [01] ...done 151028 14:18:17 [01] Copying ./ibdata2 to /data/mysql/backup/full/2015-10-28_14-18-16/ibdata2 151028 14:18:17 >> log scanned up to (13254527) 151028 14:18:17 [01] ...done 151028 14:18:17 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t2.ibd 151028 14:18:17 [01] ...done 151028 14:18:17 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t1.ibd 151028 14:18:18 [01] ...done 151028 14:18:18 >> log scanned up to (13254527) 151028 14:18:18 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t3.ibd 151028 14:18:18 [01] ...done 151028 14:18:18 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_worker_info.ibd 151028 14:18:18 [01] ...done 151028 14:18:18 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_master_info.ibd 151028 14:18:18 [01] ...done 151028 14:18:18 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_relay_log_info.ibd 151028 14:18:18 [01] ...done 151028 14:18:18 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/innodb_index_stats.ibd 151028 14:18:19 [01] ...done 151028 14:18:19 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/innodb_table_stats.ibd 151028 14:18:19 [01] ...done ...... 151028 14:21:39 Executing UNLOCK BINLOG 151028 14:21:39 Executing UNLOCK TABLES 151028 14:21:39 All tables unlocked 151028 14:21:39 Backup created in directory /data/mysql/backup/full/2015-10-28_14-21-20 151028 14:21:39 [00] Writing backup-my.cnf 151028 14:21:39 [00] ...done 151028 14:21:39 [00] Writing xtrabackup_info 151028 14:21:39 [00] ...done xtrabackup: Transaction log of lsn (13254537) to (13254537) was copied. 151028 14:21:39 completed OK! 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.
- 动态渲染教程（让你的电脑运行更快更流畅，轻松应对各种任务）
- 苹果8.11系统的创新与卓越（探索苹果8.11系统带来的新特性和改进）
- 盯盯拍M6的优劣势及购买建议（解析盯盯拍M6相机的性能和用户评价，为你选择提供参考）
- X20手机综合评测（性能强劲、拍照出众，X20手机是你不容错过的选择！）
- 如何使用魅蓝备份恢复出厂设置（简单操作教程帮您轻松恢复手机出厂设置）
- 用AI钢笔工具绘制流畅键盘线条的艺术（通过AI钢笔工具，轻松绘制出流畅、精确的键盘线条）
- 鹰眼王头灯（探索黑暗世界，成就你的冒险之旅）
- 乐2手机评测——性价比之王（以乐2手机怎么样啊，全面解析乐2的优势与不足）
- 电脑更新CF错误代码的解决方法（掌握解决CF错误代码的技巧，让游戏畅快进行）
- X1C2013（经典款式再度焕发活力，引领商务笔记本新潮流）
- vivoY79手机值得买吗？（vivoY79手机性能、价格、摄像头等方面的评估）
- OppoR9（展现创新技术与卓越性能的尖端设备）
- 普耐尔智能手表（探索普耐尔智能手表的全新功能与创新设计）
- 蓝色光标代理FB的优势与应用（解锁封锁区域，畅享无限社交）
- 页面设置方法与文章布局技巧（提高文章可读性的关键步骤和注意事项）
- 2016年餐饮行业发展情况（回顾过去，展望未来，洞察行业趋势）
- 华硕350m-a主板的性能与功能分析（一款稳定可靠的主板选择）
- 小白必备，一键重装系统U盘教程（轻松解决系统重装难题，让你的电脑焕然一新）
- Win10系统如何关闭自动更新（停用Win10系统的自动更新功能以保持更大控制权）
- 盒装风扇的优势和适用场景（打造清凉环境，盒装风扇带来的五大便利）
随便看看
企商汇香港云服务器源码库亿华云IT技术网益华科技源码下载IT资讯网服务器租用益强资讯优选编程之道IT资讯网益强数据堂码力社益强科技智能时代益强科技益华科技亿华云技术快报亿华灵动益强智囊团创站工坊科技前瞻思维库极客编程汇智坊益华IT技术论坛益强编程堂益强编程舍亿华科技亿华云计算云站无忧亿华智慧云极客码头益强IT技术网运维纵横亿华互联益华科技云智核码上建站多维IT资讯
- Copyright © 2025 Powered by MySQL innodb引擎备份工具XtraBackup之二（数据库全备）,创站工坊 滇ICP备2023006006号-44sitemap