run-db.sh

#!/bin/bash
# Script to build and run MySQL database container
# Usage: ./run-db.sh

set -e

CONTAINER_NAME="agent_platform_mysql"
IMAGE_NAME="agent-platform-mysql"

echo "🔨 Building MySQL image..."
docker build -t $IMAGE_NAME .

echo "Stopping existing container (if exists)..."
docker stop $CONTAINER_NAME 2>/dev/null || true
docker rm $CONTAINER_NAME 2>/dev/null || true

echo "Starting MySQL container..."
docker run -d \
  --name $CONTAINER_NAME \
  -p 3306:3306 \
  -v mysql_data:/var/lib/mysql \
  $IMAGE_NAME

echo "MySQL container started!"
echo ""
echo "Container name: $CONTAINER_NAME"
echo "Port: 3306"
echo "Root password: password"
echo "Database: agent_platform"
echo ""
echo "Useful commands:"
echo "  docker stop $CONTAINER_NAME    - Stop the container"
echo "  docker start $CONTAINER_NAME   - Start the container"
echo "  docker logs $CONTAINER_NAME    - View logs"
echo "  docker rm $CONTAINER_NAME      - Remove container (after stop)"