mirror of
https://github.com/ACEmulator/ACE
synced 2026-08-17 12:26:06 -04:00
bff8c20dce
* Add alwaysshowwelcome to default config dict * Update SQL tools for 8.0 * Rebase SQL scripts * Update scaffolding * Fix TargetType Enum * Correct TargetType again... * Use 16PY PR db for confirmation of SQL rebase testing * Undo enum shift in code
14 lines
817 B
Batchfile
14 lines
817 B
Batchfile
set /p password=<password.txt
|
|
|
|
"C:\Program Files\MySql\MySQL Server 8.0\bin\mysql.exe" -h localhost -u root -p%password% mysql < ..\Base\WorldBase.sql
|
|
|
|
REM execute Update Scripts for World Database
|
|
For /R "..\Updates\World\" %%G IN (*.sql) do (
|
|
echo Found file: %%G
|
|
"C:\Program Files\MySql\MySQL Server 8.0\bin\mysql.exe" -h localhost -u root -p%password% ace_world < %%G
|
|
)
|
|
|
|
del ..\Base\WorldBase.sql
|
|
del ..\Updates\World\*.sql
|
|
|
|
"C:\Program Files\MySql\MySQL Server 8.0\bin\mysqldump.exe" --user=root --password=%password% --databases ace_world --add-drop-database --add-drop-table --create-options --quote-names --lock-tables --dump-date --flush-privileges --set-gtid-purged=AUTO --disable-keys --tz-utc --add-locks --extended-insert --opt --no-data | sed\sed "s/ AUTO_INCREMENT=[0-9]*\b//g" > ..\Base\WorldBase.sql
|