One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/home/docker-templates/from-dump/build/

View File Name : import-dump-and-run.sh

#!/bin/bash

# Restore SQL dump & update shop URL
service mysql start

MYSQL_CRED="-h $DB_SERVER -P $DB_PORT -u $DB_USER -p$DB_PASSWD"
FILE="/tmp/imported"
if [ ! -f $FILE ]; then
	mysqladmin $MYSQL_CRED drop $DB_NAME --force 2> /dev/null
	mysqladmin $MYSQL_CRED create $DB_NAME --force 2> /dev/null

	for sqlFile in $DUMP_SQL_FOLDER/*
	do
		echo "\n* Importing SQL file $sqlFile ...";
		mysql $MYSQL_CRED $DB_NAME < $sqlFile
	done

	echo "\n* Update shop URL ...";
	mysql $MYSQL_CRED -e "UPDATE \`ps_shop_url\` SET \`domain\`='$PS_DOMAIN', \`domain_ssl\`='$PS_DOMAIN', \`physical_uri\`='/' WHERE \`id_shop_url\`=1;" $DB_NAME
	mysql $MYSQL_CRED -e "UPDATE \`ps_configuration\` SET \`value\`='$PS_DOMAIN' WHERE \`name\`='PS_SHOP_DOMAIN';" $DB_NAME
	mysql $MYSQL_CRED -e "UPDATE \`ps_configuration\` SET \`value\`='$PS_DOMAIN_SSL' WHERE \`name\`='PS_SHOP_DOMAIN';" $DB_NAME

	touch $FILE
fi
bash /tmp/docker_run.sh