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

Cannot recover a backup create with mariadb-dump

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.8.6
    • None
    • Backup
    • None
    • Virtual machine with RockyLinux 8.6

    Description

      We have a test installation with three instances of MariaDB Server 10.8.6, where all of them are multi-master replicas.
      When backing up a schema and data to the production facility, which is an identical version and also has three instances, we can't load the dump because only the tables are created but no rows are inserted.
      And it has not returned a warning and/or error messages.

      We are attaching the configuration files of the backup source service and the destination.

      The lines we executed were:

      FCenter-Central2-testing ~]# mariadb-dump -uroot -p************ -P3306 geoprescriptions > geoprescriptions.dmp
      

      srv-central-db ~]# mariadb --socket=/var/lib/mysql/mysqld0.sock geoprescriptions < geoprescriptions.dmp
      

      And the workaround we found is:

      After many unsuccessful attempts, we found that by commenting out just one line of the backup file, we could solve the problem, that line is:

      -- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
      

      and at the end of the file, to avoid error messages:

      -- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

      Finally, we are attaching the backup file with which it was finally possible to get the data into production.

      Thank you very much in advance for your effort.

      Hug,
      Carlos

      Attachments

        Activity

          People

            lstartseva Lena Startseva
            carlospi Carlos Pirez
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.