GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex not working with sql_mode=ANSI_QUOTES

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • innobackupex not working with sql_mode=ANSI_QUOTES

    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.
    Code:
    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.
Working...
X