Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29989

binlog_do_db option breaks importing sql dumps

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.8.6
    • Fix Version/s: 10.8, 10.9, 10.10
    • Component/s: Server
    • Labels:
    • Environment:
      Debian GNU/Linux 10 (buster)

      Description

      If you have binlog enabled and binlog_do_db set to some table and then make a mariadb-dump and import the dump to some database different of the one set in binlog_do_db, then all the Innodb tables in that database have no records.

      I'm attaching a bash script to demonstrate the problem.
      The result from all counts should e 1, but when binlog_do_db is set the result for the innodb table changes.

      That behaviour wasn't observed in 10.5 versions. It appeared after upgrade to 10.8.
      Cannot report for the versions in between, unfortunately.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            lukav Anton Avramov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.