-D, --daemon 啟用守護(hù)進(jìn)程模式 -I, --snapshot-interval dump快照間隔時(shí)間，默認(rèn)60s，需要在daemon模式下 -L, --logfile 使用日志文件，默認(rèn)標(biāo)準(zhǔn)輸出到終端 --tz-utc 備份的時(shí)候允許備份Timestamp，這樣會導(dǎo)致不同時(shí)區(qū)的備份還原會出問題，默認(rèn)關(guān)閉，參數(shù)：--skip-tz-utc to disable. --skip-tz-utc --use-savepoints 使用savepoints來減少采集metadata所造成的鎖時(shí)間，需要SUPER權(quán)限 --success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn't exist --lock-all-tables 鎖全表，代替FLUSH TABLE WITH READ LOCK -U, --updated-since Use Update_time to dump only tables updated in the last U days --trx-consistency-only Transactional consistency only -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads 備份執(zhí)行的線程數(shù),默認(rèn)4個(gè)線程 -C, --compress-protocol 在mysql連接上使用壓縮協(xié)議 -V, --version Show the program version and exit -v, --verbose 更多輸出, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
myloader Usage: myloader [OPTION...] multi-threaded MySQL loader
Help Options: -?, --help Show help options
Application Options: -d, --directory 備份文件所在的目錄 -q, --queries-per-transaction 每個(gè)事務(wù)的query數(shù)量, 默認(rèn)1000 -o, --overwrite-tables 如果表存在則先刪除，使用該參數(shù)，需要備份時(shí)候要備份表結(jié)構(gòu)，不然還原會找不到表 -B, --database 指定需要還原的數(shù)據(jù)庫 -s, --source-db 還原的數(shù)據(jù)庫 -e, --enable-binlog 啟用二進(jìn)制日志恢復(fù)數(shù)據(jù) -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads 使用的線程數(shù)量，默認(rèn)4 -C, --compress-protocol 連接上使用壓縮協(xié)議 -V, --version Show the program version and exit -v, --verbose 更多輸出, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
