[MDEV-17987] allow mysqldump to dump a set of tables from different schemas Created: 2018-12-12 Updated: 2019-03-04 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Claudio Nanni | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | beginner-friendly | ||
| Description |
|
If you want to dump a subset of schemas/tables to create a 'light' Slave, there's no way to dump consistently the tables in one shot and even more problematic to have one single GTID valid for all to start from. It would be good to have a syntax like: {{ mysqldump ...... --tables <db1>.<tableA> <db2>.<tableB> }} Currently one workaround is to apply(and remove) replicate filters for the segments between dumps. T1: dump SchemaA tables (pseudo code, actual command is CHANGE MASTER/START SLAVE .... UNTIL)
Quite more complicated than a simple unique consistent and one gtid-ed dump. |