Not the answer you need?
Register and ask your own question!

innobackupex not working with sql_mode=ANSI_QUOTES

meyer272commeyer272com EntrantInactive User Role Participant
The following code exists in innobackupex. The quotation marks should be changed to \' (backslash apostrophe) to make the script work with ANSI_QUOTES sql mode.
sub detect_mysql_capabilities_for_backup {
  $have_changed_page_bitmaps =
  mysql_query($_[0], 'SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS '.
  'WHERE PLUGIN_NAME LIKE "INNODB_CHANGED_PAGES"')
}

I submitted this to the Percona server bug tracker, but it was rejected because it was a bug in innobakupex. Therefore, I am entering it here.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.