Explicitly precreate as many DB structures as possible up front
https://raw.githubusercontent.com/TrinityCore/TrinityCore/master/.circleci/config.yml
See upstream Circle CI pipeline:
- run:
name: SQL checks
command: |
chmod +x contrib/check_updates.sh
dockerize -wait tcp://127.0.0.1:3306 -timeout 120s
mysql -h 127.0.0.1 -uroot < sql/create/create_mysql.sql
mysql -h 127.0.0.1 -uroot auth < sql/base/auth_database.sql
./contrib/check_updates.sh auth master auth 127.0.0.1
mysql -h 127.0.0.1 -uroot characters < sql/base/characters_database.sql
./contrib/check_updates.sh characters master characters 127.0.0.1
echo "Importing world database structure"
mysql -h 127.0.0.1 -uroot world < sql/base/dev/world_database.sql
echo "Importing hotfixes database structure"
mysql -h 127.0.0.1 -uroot hotfixes < sql/base/dev/hotfixes_database.sql
echo "Importing world database updates"
cat sql/updates/world/master/*.sql | mysql -h 127.0.0.1 -uroot world
echo "Importing hotfixes database updates"
cat sql/updates/hotfixes/master/*.sql | mysql -h 127.0.0.1 -uroot hotfixes
Edited by Nicola Worthington