ubuntu 上shell脚本实现数据库的定时备份和删除一个月以前的数据 curdate=`date +%Y-%m-%d_%H-%M` backupdir=”/opt/backup/db” databasename=”DBName” username=”root” password=”–skip-password” # if password isn’t empty use “-pxxxxx” #the number of days to keep backups keepbac...【阅读全文】
环境:OS:centos 6db:5.6.401.修改/etc/init.d/mysqld文件,默认文件以及存在,该文件内容如下:#!/bin/sh# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB# This file is public domain and comes with NO WARRANTY of any kind# MySQL ...【阅读全文】
对于MySQL单实例数据库和master库,如果需要设置为只读状态,需要进行如下操作和设置: mysql> show global variables like "%read_only%";mysql> flush tables with read lock;mysql> set global read_only=1;mysql> show global variables like "%read_only%";mysql> unlock tables;mysql> set global read_only...【阅读全文】