#!/bin/bash
IP="your-ip"
PORT="3306"
USER="your-username"
PASSWORD="your-password"
DATABASE="your-database-name"
TABLE="your-table-name"
# 尝试连接到MariaDB容器并执行简单的查询
if docker exec mariadb-server mysqladmin -u $USER -p$PASSWORD ping --silent; then
echo "MariaDB service is running and responding to ping."
echo "Attempting to connect to the MariaDB container..."
# 尝试更新数据
UPDATE_STATUS=$(docker exec mariadb-server mysql -h $IP -P $PORT -u $USER -p$PASSWORD $DATABASE -e "USE $DATABASE; UPDATE $TABLE SET column_name='new_value' WHERE condition;" 2>&1)
if [ $? -eq 0 ]; then
echo "Data updated successfully."
else
echo "Failed to update data: $UPDATE_STATUS"
fi
else
echo "MariaDB service is not running or not responding to ping."
exit 1
fi