MYSQL 線上(OnLine) 限制條件備份 (mysqldump –where)

資料來源:
https://stackoverflow.com/questions/935556/mysql-dump-by-query
http://blog.csdn.net/xin_yu_xin/article/details/7574662
https://stackoverflow.com/questions/26261670/mysqldump-with-where-clause-is-not-working

實際測試會動語法:
    mysqldump.exe -h127.0.0.1 -P3307 -uroot -pusbw -t -e -q –complete-insert –extended-insert=FALSE –default-character-set=utf8 –hex-blob v8_workstation controller_io_record –where=”537811566<= timestamp AND timestamp<=574445166″ > controller_io_record_00.sql

    mysqldump.exe -h127.0.0.1 -P3307 -uroot -pusbw -t -e -q –complete-insert –extended-insert=FALSE –default-character-set=utf8 –hex-blob v8_workstation controller_io_record –where=”546955202<= timestamp AND timestamp<=571255622″ > controller_io_record_01.sql

    pause