某局点linux iMC+MySQL数据库新安装后dbman备份失败问题分析

某局点linux iMC+MySQL数据库环境新安装完成后，首次使用dbman备份失败

dbman备份失败

某局点linux iMC+MySQL数据库环境新安装完成后，首次使用dbman备份失败

收集iMC/dbman/log下的日志信息，先查看dbman.log文件确认备份失败的时间点

2023-12-11 10:29:59 [THREAD(4024433472)] [LOG] [ManualBackupDase] begin to manual backup databases.

2023-12-11 10:29:59 [THREAD(4024433472)] [LOG] [ManualBackupDase] failed to manual backup databases.

然后查看dbman_debug.log文件确认对应时间点的报错情况

2023-12-11 10:29:59 [THREAD(4024433472)] [DEBUG] [WriteFile] Write file /opt/iMC/server/bin/../../dbman/etc/LastOperationResult.conf.

2023-12-11 10:29:59 [THREAD(4024433472)] [INFO] [CDbBackup::BackupAllDataBase] Begin to manual backup all databases. Backup directory: /opt/dbmanbak

2023-12-11 10:29:59 [THREAD(4024433472)] [INFO] [CDbBackup::BackupAllDataBase] ServerCount = 1

2023-12-11 10:29:59 [THREAD(4024433472)] [INFO] [CDbBackup::BackupAllDataBase] Path: 127.0.0.1@aclm_db_imc_aclm_db_20231211_102959_full.db

2023-12-11 10:29:59 [THREAD(4024433472)] [INFO] [runCommand] runCommand result FAIL. ret=512, errno=0, WIFEXITED(ret)=1, WEXITSTATUS(ret)=2

2023-12-11 10:29:59 [THREAD(4024433472)] [ERROR] [ReadFile] Read file /opt/iMC/dbman/bin/dbop.sql.log fail.

2023-12-11 10:29:59 [THREAD(4024433472)] [DEBUG] [CDbBackup::BackupOneLocalDBase] Exec mysql backup log:

2023-12-11 10:29:59 [THREAD(4024433472)] [INFO] [Remove] Fail to remove file: /opt/iMC/dbman/bin/dbop.sql.log

2023-12-11 10:29:59 [THREAD(4024433472)] [ERROR] [CDbBackup::BackupOneLocalDBase] Exec command fail.

2023-12-11 10:29:59 [THREAD(4024433472)] [INFO] [sendTrapAlert] Send trap success 

可以看到是执行命令行备份的过程中报错，返回512，针对MySQL数据库，可以尝试手工备份，使用如下命令在命令行中尝试手工备份数据库，查看具体的错误回显

[root@jmcIMCnew deploy]# mysqldump -uroot -pEmc2admin=   config_db > ./a.db

mysqldump: [Warning] unknown variable 'loose-local-infile=1'.

mysqldump: [ERROR] unknown option '--Single-transaction'.

根据上述错误提示可以看出是MySQL的备份时解析参数失败，查看my.cnf文件查看该参数配置问题。需要将该内容调整为S小写

输入命令vi /etc/my.cnf，打开文件并进入vi（Visual interface，一种文本编辑器）。

按下i键进入编辑模式，开始修改参数。

[mysqldump]

single-transaction

按下Esc键返回的一般模式。

在一般模式下按下：wq，保存后退出vi。