How to exclude table backup in mydumper

Asked by MF on 2015-10-09

imho table regex for exclusion isn't working, or I can't find how to do it.

I'm trying
mydumper -v 3 -B dbname -o /tmp -x '^(?!(dbname.user))$'

and nothing dumped (except metadata, with 2 lines: Started dump ... Finished dump).

regex for include works fine
mydumper -v 3 -B dbname -o /tmp -x '^(dbanem.user)$'

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Solved by:
Max Bubenick
Solved:
2015-10-09
Last query:
2015-10-09
Last reply:
2015-10-09
Best Max Bubenick (max-bubenick) said : #1

Hi, this is correct regex for exclusion

-x '^(?!(dbname.user$))'

That will match the exact db.tbl name.

A few more examples:

exlcude two tables

-x '^(?!(dbname.user$|dbname.tbl2$))'

exclude all tables on schema dbname starting with user, i.e. user, user2 user3

-x '^(?!(dbname.user))'

exclude all dbname schema

-x '^(?!(dbname))'

Hope that helps.
- Max

MF (fuxa-kos) said : #2

This Solved My Problem

MF (fuxa-kos) said : #3

Thanks Max Bubenick, that solved my question.