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

Create utility to parse frm files and print their DDL (Full-time project - potential part-time)

    XMLWordPrintable

Details

    Description

      It would be useful if MariaDB had a utility that was able to parse frm files and print the DDL associated with the table.

      For example, it would be useful for users who performed a partial backup with Mariabackup:

      https://mariadb.com/kb/en/library/partial-backup-and-restore-with-mariabackup/

      But they forgot to also backup the table DDL, so they can't restore the tables using the following process:

      https://mariadb.com/kb/en/library/innodb-file-per-table-tablespaces/#importing-transportable-tablespaces-for-non-partitioned-tables

      mysqlfrm is a tool that already exists that does similar things:

      https://github.com/mysql/mysql-utilities/blob/master/scripts/mysqlfrm.py

      But it doesn't seem very user-friendly. It needs to be able to contact the local MariaDB server, and it also needs to be able to spawn a server instance, and it seems to need to be able to create a bunch of files during this process. e.g.:

      [ec2-user@ip-172-30-0-249 ~]$ cd /tmp
      		 
      [ec2-user@ip-172-30-0-249 tmp]$ sudo mysqlfrm --server=root:@localhost:3306 /var/lib/mysql/db1/tab.frm --port=12345 --user=mysql
      		 
      # Source on localhost: ... connected.
      		 
      # Spawning server with --user=mysql.
      		 
      # Starting the spawned server on port 12345 ... done.
      		 
      # Reading .frm files
      		 
      #
      		 
      # Reading the tab.frm file.
      		 
      #
      		 
      # CREATE statement for /var/lib/mysql/db1/tab.frm:
      		 
      #
      		 
       
      		 
      CREATE TABLE `db1`.`tab` (
      		 
        `id` int(11) NOT NULL,
      		 
        `str` varchar(50) DEFAULT NULL,
      		 
        PRIMARY KEY (`id`)
      		 
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      		 
       
      		 
      #...done.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15225 Can't import .ibd file with temporal type format differing from mysql56_temporal_format

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26577 InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2) during ADD COLUMN

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28727 ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-4637 TOOLS - FRM file parser / file information

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              10 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.