innobackupex-1.5.1备份数据库时MySQL server has gone away的解决办法-优快云博客

本文介绍了一种在使用innobackupex进行数据库备份时遇到的错误及其解决方案。该错误通常由于MySQL主动断开空闲连接导致。通过修改innobackupex文件，并设置更长的空闲等待时间来避免这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在用innobackupex备份数据库是出现以下报错信息时，主要是因为mysql主动断开了空闲连接，可以修改innobackupex文件，连接时临时增加空闲等待时间。


xtrabackup: Transaction log of lsn (73 943434069) to (73 953657096) was copied.
Pipe to mysql child process broken: ERROR 2006 (HY000) at line 15: MySQL server has gone away


    if (compare_versions($mysql_server_version, '4.0.22') == 0
        || compare_versions($mysql_server_version, '4.1.7') == 0) {
        # MySQL server version is 4.0.22 or 4.1.7
        mysql_send "COMMIT;";
        mysql_send "set interactive_timeout=28800;"; #added by gu lei
        mysql_send "set wait_timeout=28800;"; #added by gulei
        mysql_send "FLUSH TABLES WITH READ LOCK;";
    } else {
        # MySQL server version is other than 4.0.22 or 4.1.7
        mysql_send "set interactive_timeout=28800;"; #added by gu lei
        mysql_send "set wait_timeout=28800;"; #added by gu lei
        mysql_send "FLUSH TABLES WITH READ LOCK;";
        mysql_send "COMMIT;";
    }