#!/bin/bash
# -*- coding: utf-8 -*-


# 設定 MySQL 登入資訊
MYSQL_USER="root"
MYSQL_PASSWORD="password"

# 取得所有資料庫名稱
DATABASES=$(mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)")

# 迭代每個資料庫，進行匯出並壓縮
for DB in $DATABASES; do
  mysqldump -u$MYSQL_USER -p$MYSQL_PASSWORD --opt $DB > "$DB.sql"
  zip -r "$DB.zip" "$DB.sql"
  rm "$DB.sql"
done

# Python3
pip3 freeze > requirements.txt

# Python2
pip freeze > requirements.txt

conda env export -n <environment-name> > env.yml

#0 74.44 W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/focal/InRelease  Temporary failure resolving 'archive.ubuntu.com'
#0 74.44 W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/focal-updates/InRelease  Temporary failure resolving 'archive.ubuntu.com'
#0 74.44 W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/focal-backports/InRelease  Temporary failure resolving 'archive.ubuntu.com'
#0 74.44 W: Failed to fetch http://security.ubuntu.com/ubuntu/dists/focal-security/InRelease  Temporary failure resolving 'security.ubuntu.com'

docker build --network=host  . -t your-image-name

apt-get install git-lfs

curl -s https://packagecloud.io/install/repositories/github/git-lfs/script.deb.sh | sudo bash

git lfs install

yum -y install yum-cron
systemctl start yum-cron
systemctl enable yum-cron

update_cmd = default

update_cmd = security

apt-get install cron-apt

MAILON="always"