Hi Sergei, thanks for the comment. Currently tried to just add very simple change which will allow the user to specify partition name using comma separated list and a separator in table's name. For example ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@, not sure if I should parse the partition string to ensure there's no syntax error in generated query and partition names are escaped?

Maybe will add ability to do that in parallel, automatically when i'll become more familiar with the framework.

Thanks,
Slawomir.


Dnia 12 marca 2025 13:11 Sergei Golubchik <serg@mariadb.org> napisał(a):

Hi, pslawek83,

Note that mariadb-dump already supports --parallel option that can dump
many tables in parallel.

Depending on your use case you might want to extend --parallel to
automatically dump individual partitions in parallel, instead of
extending mariadb-dump to allow to specify what partition to dump.

Depends on what you need, of course, I'm just listing the options so
that you could choose what works better for you.

On Mar 12, pslawek83 via discuss wrote:
Hi Everyone, I want to add the ability to backup a single partition
using mysqldump. I have some large (500GB+) partitioned tables I want
to backup fast. So the idea is to run each partition in parallel using
mariadb-dump but AFAIK there&#39;s no option for specifying the
partition yet. Will you merge my code if I add that to mariadb-dump ?
I assume MariaDB/server/blob/main/client/mysqldump.cc is where dev for
that happens?   Thanks

Regards,
Sergei
Chief Architect, MariaDB Server
and security@mariadb.org