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

Back up table data by ID interval every day

#! / bin/bash

Date-d yesterday + "DATE Y-%m-%d H:%M:%S" > > / Mysql_Data/t_collection/ID.log

/ usr/bin/mysql-uroot-- password= "admin"-D userbehavior-e "select max (ID) from tasking;" | grep-v 'max (ID)' > > / Mysql_Data/t_collection/ID.log

Today= `tail-n 1 / Mysql_Data/t_collection/ ID. Log`

Yesterday= `tail-n 3 / Mysql_Data/t_collection/ID.log | grep-v 'DATE' | grep-v $today`

Sql= "use userbehavior;\ n

Select * from t_collection where ID > $yesterday and ID3899999999 and ID

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.