DateTime 小贴士

关于DateTime的记录笔记:

1. DateTime.Now.ToLongDateString() =>2018年6月1日

2.DateTime.Now.ToLongTimeString()=>11:42:50

3.DateTime.Now.ToShortDateString()=>2018/6/1

4.DateTime.Now.ToShortTimeString()=>11:45

5.DateTime.Now.Date=>2018/6/1 0:00:00

C# 14位日期型字符串yyyyMMddHHmmss转变为日期格式

DateTime   dt   =   DateTime.ParseExact("20060709110901","yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture);

 

#!/bin/bash datetime=`date +%Y%m%d-%H-%M-%S` OneWeekAgo=`date -d "1 week ago" +%Y%m%d` basePath=/usr/local/mysql/backup bakFileName=mysql_backup_$datetime.sql bakFile=$basePath/$bakFileName logfile=$basePath/full_$datetime.log pid=`ps -ef | grep -v "grep" |grep -i mysqldump|awk '{print $2}'|head -n 1` if [ -z $pid ] then echo " start full backup database " >> $logfile touch $bakFile #docker run --rm -v $basePath:/backups mysql:5.7.30 \ mysqldump -uroot -p'123456' --all-databases --quick --triggers --routines --events --single-transaction --result-file=/$basePath >> $logfile 2>&1 #docker exec -i mysql sh -c "exec mysqldump -uroot -p'skycomm@5342' --all-databases --quick --triggers" >$bakFile 2>&1 mysqldump -uroot -p'123456' --anti_fraud --quick --triggers --routines --events --single-transaction --result-file=/usr/local/mysql/backup/anti_fraud >> $logfile 2>&1 mysqldump -uroot -p'123456' --skycomm_base_service --quick --triggers --routines --events --single-transaction --result-file=/usr/local/mysql/backup/skycomm_base_service >> $logfile 2>&1 mysqldump -uroot -p'123456' --performance_schema --quick --triggers --routines --events --single-transaction --result-file=/usr/local/mysql/backup/performance_schema >> $logfile 2>&1 ret=`tail -n 1 $bakFile |grep "Dump completed on"|wc -l` if [ "$ret" = 1 ] ; then echo 'delete expired backup ' $basePath/mysql_backup_$OneWeekAgo*.sql >> $logfile rm -f $basePath/mysql_backup_$OneWeekAgo*.sql rm -f $basePath/full_$OneWeekAgo*.log else echo 'backup failure ,no delete expired backup' >> $logfile fi else echo "****** mysqldump in backup database ****** " >> $logfile fi 帮我优化这个sql
04-03
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值