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

mysqldump -L --ignore-table doesn't ignore the table

    XMLWordPrintable

Details

    • Unexpected results
    • Q3/2025 Maintenance

    Description

       
      create table t1 (i int);
      create table t2 (i int);
       
      --exec $MYSQL_DUMP -L --compact --ignore-table=test.t1  test %
      drop table t1,t2;
      

      worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029
      create table t1 (i int);
      create table t2 (i int);
      /*M!999999\- enable the sandbox mode */ 
      /*!40101 SET @saved_cs_client     = @@character_set_client */;
      /*!40101 SET character_set_client = utf8mb4 */;
      CREATE TABLE `t1` (
        `i` int(11) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
      /*!40101 SET character_set_client = @saved_cs_client */;
      set autocommit=0;
      commit;
      /*!40101 SET @saved_cs_client     = @@character_set_client */;
      /*!40101 SET character_set_client = utf8mb4 */;
      CREATE TABLE `t2` (
        `i` int(11) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
      /*!40101 SET character_set_client = @saved_cs_client */;
      set autocommit=0;
      commit;
      drop table t1,t2;
      

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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