My databases does not show in the MySQL Flexible Server.

Question

I have web app created using app service and that connects to the Azure Database for MySQL flexible server with compute tier Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage. It was working fine but suddenly I was not able to login through my web app, I checked the log for web app which showed DB connection error. So when I logged in to Azure Portal and check the resource for DB server, I could not see my DBs listed there. I even did restart the server, still issue is the same.

Answer 1

Hi @Parbata Bastola
Please log in to the Azure portal from a different browser or machine. Additionally, you can try checking the list of databases using the following CLI command. az mysql flexible-server db show --resource-group testGroup --server-name testserver --database-name testDatabase az mysql flexible-server db show Thank You!

Answer 2

I have now resolved this issue. I restarted the server -> Did not resolve the issue. Creating new DB using the backup and restore -> Was successful and I could see old data. As suggested by @Oury Ba-MSFT , I tried to upgrade the server but the deployment failed. After this when I refreshed the page for my DB server, I could see my databases. My applications worked fine and all data were there.