DM同步过程,数据库命名问题(带 - 中划线)

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:4.0 DM V1.0.6
  • 【问题描述】:DM同步上游mysql库,库名带有中划线 “-”,通过查看历史贴,在mydumper的 extra-args 参数中 增加-x 可解决:如下
    extra-args: “-s 100000 -x ‘^oms-dataex’ --no-locks”

昨天查了相关文档,但是并没有以上参数的具体含义说明:如下
https://pingcap.com/docs-cn/tidb-data-migration/stable/task-configuration-file-full/

mydumpers: # mydumper 处理单元运行配置参数
global: # 配置名称
mydumper-path: “./bin/mydumper” # mydumper binary 文件地址,默认值为 “./bin/mydumper”
threads: 4 # mydumper 从上游数据库实例导出数据的线程数量,默认值为 4
chunk-filesize: 64 # mydumper 生成的数据文件大小,默认值为 64,单位为 MB
skip-tz-utc: true # 忽略对时间类型数据进行时区转化,默认值为 true
extra-args: “–no-locks” # mydumper 的其他参数,在 v1.0.2 版本中 DM 会自动生成 table-list 配置,在其之前的版本仍然需要人工配置

所以想咨询下,extra-args 中的具体参数的具体含义(包括但不限于以下几个参数)?谢谢。
extra-args: “-s 100000 -x ‘^oms-dataex’ --no-locks”

DM 集成了mydumper 的功能,mydumper的参数可以使用 mydumper --help 命令查看下,具体如下,供参考:

[tidb@localhost ~]$ mydumper --help
Usage:
mydumper [OPTION?] multi-threaded MySQL dumping

Help Options:
-?, --help Show help options

Application Options:
-B, --database Database to dump
-T, --tables-list Comma delimited table list to dump (does not exclude regex option)
-O, --omit-from-file File containing a list of database.table entries to skip, one per line (skips before applying regex option)
-o, --outputdir Directory to output files to
-s, --statement-size Attempted size of INSERT statement in bytes, default 1000000
-r, --rows Try to split tables into chunks of this many rows. This option turns off --chunk-filesize
-F, --chunk-filesize Split tables into chunks of this output file size. This value is in MB
-c, --compress Compress output files
-e, --build-empty-files Build dump files even if no data available from table
-x, --regex Regular expression for ‘db.table’ matching
-i, --ignore-engines Comma delimited list of storage engines to ignore
-N, --insert-ignore Dump rows with INSERT IGNORE
-m, --no-schemas Do not dump table schemas with the data
-d, --no-data Do not dump table data
-G, --triggers Dump triggers
-E, --events Dump events
-R, --routines Dump stored procedures and functions
-W, --no-views Do not dump VIEWs
-k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups
–no-backup-locks Do not use Percona backup locks
–less-locking Minimize locking time on InnoDB tables.
-l, --long-query-guard Set long query timer in seconds, default 60
-K, --kill-long-queries Kill long running queries (instead of aborting)
–tidb-force-priority Change the default priority for statements executed on a TiDB server, set the value of this variable to LOW_PRIORITY, DELAYED or HIGH_PRIORITY
-D, --daemon Enable daemon mode
-I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60
-L, --logfile Log file name to use, by default stdout is used
–tz-utc SET TIME_ZONE=’+00:00’ at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.
–skip-tz-utc
–use-savepoints Use savepoints to reduce metadata locking issues, needs SUPER privilege
–success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn’t exist
–lock-all-tables Use LOCK TABLE for all, instead of FTWRL
-U, --updated-since Use Update_time to dump only tables updated in the last U days
–trx-consistency-only Transactional consistency only
–complete-insert Use complete INSERT statements that include column names
-z, --tidb-snapshot Snapshot to use for TiDB
–tidb-rowid Dump _tidb_rowid from a TiDB database
-w, --where Dump only selected records
-h, --host The host to connect to
-u, --user Username with the necessary privileges
-p, --password User password
-a, --ask-password Prompt For User password
-P, --port TCP/IP port to connect to
-S, --socket UNIX domain socket file to use for connection
-t, --threads Number of threads to use, default 4
-C, --compress-protocol Use compression on the MySQL connection
-V, --version Show the program version and exit
-v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
–defaults-file Use a specific defaults file
–ssl Connect using SSL
–key The path name to the key file
–cert The path name to the certificate file
–ca The path name to the certificate authority file
–capath The path name to a directory that contains trusted SSL CA certificates in PEM format
–cipher A list of permissible ciphers to use for SSL encryption