Reinhard X. Fürst
64acfdda6f
- Add viewport meta tag to prevent iOS zoom/scaling issues - Fix text color on iOS Safari (explicit text-gray-900 on buttons, inputs, TimePicker5) - Add session checks to /api/beos, /api/objekte, /api/wetter - Revert iframe embedding (X-Frame-Options: DENY, SameSite: lax) - docker-compose.prod.yml: fix DB_PORT=3306 for production - Add docker-compose.prod.yml, .env.prod.example, dump/import scripts Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
34 lines
975 B
Bash
Executable File
34 lines
975 B
Bash
Executable File
#!/bin/bash
|
|
# Auf dem Server ausführen, nachdem docker-compose gestartet wurde.
|
|
# Importiert logbuch_dump.sql in den laufenden logbuch_mysql-Container.
|
|
|
|
set -e
|
|
|
|
CONTAINER="logbuch_mysql"
|
|
DB="sternwarte"
|
|
DUMPFILE="${1:-logbuch_dump.sql}"
|
|
|
|
if [ ! -f "$DUMPFILE" ]; then
|
|
echo "FEHLER: Dump-Datei '$DUMPFILE' nicht gefunden." >&2
|
|
exit 1
|
|
fi
|
|
|
|
# Root-Passwort aus .env.prod lesen
|
|
ROOT_PASS=$(grep DB_ROOT_PASS .env.prod | cut -d= -f2)
|
|
if [ -z "$ROOT_PASS" ]; then
|
|
echo "FEHLER: DB_ROOT_PASS nicht in .env.prod gefunden." >&2
|
|
exit 1
|
|
fi
|
|
|
|
echo "Importiere '$DUMPFILE' in Container '$CONTAINER'..."
|
|
docker exec -i "$CONTAINER" mysql -u root -p"$ROOT_PASS" "$DB" < "$DUMPFILE"
|
|
|
|
echo "Verifikation:"
|
|
for TABLE in beos objekte logbuch logbuch_beos logbuch_objekte; do
|
|
COUNT=$(docker exec "$CONTAINER" mysql -u root -p"$ROOT_PASS" -sN \
|
|
-e "SELECT COUNT(*) FROM $TABLE;" "$DB" 2>/dev/null)
|
|
printf " %-25s %5s Zeilen\n" "$TABLE" "$COUNT"
|
|
done
|
|
|
|
echo "Import abgeschlossen."
|