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

add a where condition on mysqldump for partitioning

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None

      Description

      To select a single partitioning the SQL just use something like this:

      SELECT * FROM orders PARTITION (p3) ;

      but there is not a where condition that could you to hit the p3.

      the point is that mysqldump support a where condition with the option --where

      but WHERE condition can not be use to select a single partition, the use of the key and the value can be complicate and explain seems check all the partition anyway.

      The Future request is to have a where condition to be used as well on mysqldump to dump just a partition directly:

      mysqldump... --where= PARTITION (p3) ;

      something alike.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            massimo.disaro Massimo
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: