工作中涉及mysql
-
编辑 删除
select xxx into outfile from shell
#!/bin/bash#Script. Name:test_seal_activity.sh#Descript. export data from seal_activity between now()-1 10:00:00 and now() 10:00:00#define export DataBAseDbName=testDB#define userName and Passwd#Dbusr...
-
编辑 删除
每天备份一次DB中table
#!/bin/bash#Script. Name:testDBdailytable.sh#Create Time:2012-06-05#define backup DBNamemyDB=testDB#define scriptdirscriptdir=`pwd`backupdir=testDBbackup/testDBDailytable#define time 2 days agoDAT...
-
编辑 删除
DB中备份每一张table script
#!/bin/bash##Descript. backup per table in the testDB##time:2012-06-05##Name:testDBfullPerTable.sh#define DB username and passwordmyDB=testDB#define testDB per table backupdirtabbakdir=/da...
