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;";
}
I modified /usr/bin/ innobackupex- 1.5.1 like this:
if (compare_ versions( $mysql_ server_ version, '4.0.22') == 0 versions( $mysql_ server_ version, '4.1.7') == 0) { timeout= 28800;" ; #added by gu lei 28800;" ; #added by gulei timeout= 28800;" ; #added by gu lei 28800;" ; #added by gu lei
|| compare_
# MySQL server version is 4.0.22 or 4.1.7
mysql_send "COMMIT;";
mysql_send "set interactive_
mysql_send "set wait_timeout=
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_
mysql_send "set wait_timeout=
mysql_send "FLUSH TABLES WITH READ LOCK;";
mysql_send "COMMIT;";
}
Xtrabackup is successfully now.