bash livck-db-dump.sh

livck-db-dump.sh

#!/bin/bash

# Name of the database service defined in the docker-compose.yml
DB_SERVICE="database"

# Destination directory for the MySQL dump file
EXPORT_DIR="/opt/livck"

# Name of the database to export
DATABASE_NAME="livck-cp"

# Path to the .env file
ENV_FILE="/opt/livck/.env"

# Load the environment variables from the .env file
export $(grep -v '^#' "$ENV_FILE" | xargs -d '\n')

docker-compose exec "$DB_SERVICE" sh -c "apt-get update && apt-get install -y mysql-client"

# Dump the MySQL database from the container
docker-compose exec -T "$DB_SERVICE" sh -c "mysqldump --single-transaction -u\"$DB_USERNAME\" -p\"$DB_PASSWORD\" --databases \"$DATABASE_NAME\" --no-tablespaces --skip-column-statistics" > "$EXPORT_DIR/db_dump.sql"

echo "MySQL database dumped successfully: $EXPORT_DIR/db_dump.sql"