Mysql Troubleshooting Scenarios

Packages advent2025 ai ansible apache aws cli bash c caddy clickhouse cron csv data processing disk volumes dns docker elk envoy etcd financial finops ftp git gitea golang gunicorn hack haproxy harbor hashicorp vault helm java jenkins json kubernetes linux-other mongodb mysql nginx node.js php podman postgres prometheus python rabbitmq redis sql sqlite ssh ssl supervisord systemd terraform traefik

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	40 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: 40 minutes.

Mysql Troubleshooting Scenarios

Mysql

MySQL (MariaDB) Scenarios

"Rosario": Restore a MySQL database

"Abaokoro": Restore MySQL Databases Spooked by a Ghost

Send Us Feedback or Get Notified