C:UsersAdministrator.DD-20150603YWTL>mysqldump -uroot -paa123 -h10.0.0.101 table1 user -t -c --set-gtid-purged=OFF --single-transaction | gzip>/
/backup//userBack//crm_2016-08-02_2016-08-03.sql.gz
PHP中文网2017-04-18 09:43:44
Does the windows command line have the concept of |pipeline? Is there a gzip command?
Windows doesn’t consider compression. Of course there are methods. I’m not familiar with it. You must compress it and search for solutions on GOOGLE
mysqldump -ubackup -p123456 -h 192.168.1.2 backup_test > D:\bak\bakcup.sql