Shulou(Shulou.com)06/01 Report--

Export data

Mysqldump

-u account number

-p password

Library

-- table table

-- skip-lock-tables doesn't care about locks

-w "statement (for example, id > 1, not sql statement)"

-- insert extended-insert=false one by one (poor performance, but better readability)

Import file (xxx.sql)

If the sql statement is

SELECT * FROM WeaponDecomposesLog1 WHERE `Time` > '2017-06-09'

Library pjblog

Table ForgingAddWorkerLog

-t only import table data

-w conditional judgment statement

Export

Mysqldump-u$USER pjblog-- table ForgingAddWorkerLog-p$PASSWD-h$HOST-- skip-lock-tables-t-w "Time > = '2017-06-09'" > ForgingAddWorkerLog.sql

Lead in

Mysql-u$USER-p$PASSWD-h$HOST pjblog < ForgingAddWorkerLog.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.