实用的脚本

Mysql备份：

#!/bin/bash

# MySQL root用户密码
MYSQL_ROOT_PASSWORD='your_root_password'

# 备份文件存储的目录
BACKUP_DIR="/path/to/your/backup/directory"
DATE=$(date +%Y%m%d%H%M)

# 确保备份目录存在
mkdir -p $BACKUP_DIR

# 获取并备份每个数据库
databases=`mysql -u root -p$MYSQL_ROOT_PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        mysqldump -u root -p$MYSQL_ROOT_PASSWORD --databases $db > $BACKUP_DIR/$db-$DATE.sql
    fi
done