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

mysqldump dumps all data from a connect table

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.3
        • Fix Version/s: 10.0.5
        • Component/s: None
        • Environment:
          Ubuntu/Precise/LXContainer

          Description

          mysqldump should behave like with connect as with federated only dumping the structure and not the rows. 

          DROP TABLE IF EXISTS `federatedconnect`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `federatedconnect` (
  `id` int(11) NOT NULL,
  `id2` int(11) DEFAULT NULL
) ENGINE=CONNECT DEFAULT CHARSET=latin1 `TABLE_TYPE`='mysql' `TABNAME`='aha' `DBNAME`='test' `OPTION_LIST`='user=me,host=10.0.3.191';
/*!40101 SET character_set_client = @saved_cs_client */;

          Following should be ommitted

          
--
-- Dumping data for table `federatedconnect`
--

LOCK TABLES `federatedconnect` WRITE;
/*!40000 ALTER TABLE `federatedconnect` DISABLE KEYS */;
INSERT INTO `federatedconnect` VALUES .....

          As it will end in at leas dumping other servers data.
          Even recovering would get you a lot of errors.

          A Fix would be some kind of difficult. While table_type=MySQL,ODBC shoul be omitted. It is hard to handle i.e. table_type=cvs as they can be local tables in the schema too.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                bar Alexander Barkov added a comment -

                Fixed in 10.0.5

                Show
                bar Alexander Barkov added a comment - Fixed in 10.0.5

                  People

                  • Assignee:
                    bar Alexander Barkov
                    Reporter:
                    erkules erkan yanar
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: