Mysql Troubleshooting Scenarios

advent2025 apache bash c caddy clickhouse csv data processing disk volumes dns docker envoy etcd git golang gunicorn hack haproxy harbor hashicorp vault helm java jenkins json kubernetes linux-other mysql nginx node.js php podman postgres prometheus python rabbitmq redis sql sqlite ssh ssl supervisord systemd

realistic / interviews new pro business

Mysql

MySQL (MariaDB) Scenarios

#	Name	Level	Time	Type
1	"Rosario": Restore a MySQL database	Medium	15 m	Fix	"Rosario": Restore a MySQL database Scenario: "Rosario": Restore a MySQL database Level: Medium Type: Fix Access: Email Description: A developer created a database named 'main' but now some data is missing in the database. You need to restore the database using the the dump "/home/admin/backup.sql". The issue is that the developer forgot the root password for the MariaDB server. If you encounter an issue while restoring the database, fix it. Credit: Sebastian Segovia Test: The database, once restored, has a table named "solution". The "Check My Solution" button runs the script /home/admin/agent/check.sh, which you can see and execute. Time to Solve: 15 minutes.
2	"Abaokoro": Restore MySQL Databases Spooked by a Ghost	Medium	20 m	Fix Pro	"Abaokoro": Restore MySQL Databases Spooked by a Ghost Scenario: "Abaokoro": Restore MySQL Databases Spooked by a Ghost Level: Medium Type: Fix Access: Paid Description: There are three databases that need to be restored. You need to create three databases called "first", "second" and "third" and restore the databases using the file "/home/admin/dbs_to_restore.zip". If you encounter an issue while restoring the database, fix it. Credit: Sebastian Segovia Test: All databases, once restored, have a table named "foo". The "Check My Solution" button runs the script /home/admin/agent/check.sh, which you can see and execute. Time to Solve: 20 minutes.

Mastodon Follow

X (formerly Twitter) Follow

Uptime Robot ratio (30 days)

Updated: 2026-02-08 20:51 UTC – 9767742

Made in Canada 🇨🇦