restore-radio-browser.sh
1wget https://backups.radio-browser.info/latest.sql.gz
2
3gzip -d latest.sql.gz
4
5sed -i '/CREATE ALGORITHM=/,/;/d' latest.sql
6
7docker run \
8 -e MYSQL_DATABASE=radiobrowser -e MYSQL_ALLOW_EMPTY_PASSWORD=1 \
9 -p 3306:3306 -v $(pwd)/latest.sql:/docker-entrypoint-initdb.d/latest.sql \
10 mysql:latest