MySQL database on Azure Disappeared from my resources?

Maneesh 5

I have 2 wordpress websites running on my azure subscription which use the same Mysql database on Azure under the same subscription and resource group. which is nowhere to be found anymore? and both my websites giving error as Error establishing a database connection?!

My database just disappeared from azure!?? how? how do i bring it back? I contacted support but says I have only basic support included which includes only billing and subscription level queries- I am stressed. has anyone had this before?

Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-03-25T19:02:51.44+00:00

@Maneesh

We are sorry about the inconvenience you are experiencing, and this is a strange issue.

Could you please check though Azure CLI command: az mysql server show --resource-group myresourcegroup --name mydemoserver , if details appear up for the MySQL server.

Regards,

Oury
Maneesh 5 Reputation points

2024-03-25T19:13:11.66+00:00

@Oury Ba-MSFT thank you for your response. yes, I have tried and nothing appears. The database is just gone. Vanished!
Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-03-25T19:34:24.91+00:00

@Maneesh

In the meantime, could you please increase the value for “max_allowed_packet” from the Azure Database for MySQL server parameter pane to see if that will resolve the issue.

Regards,

Oury
Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-03-26T18:28:50.6766667+00:00

@Maneesh

Any updates on this?

1 answer

Guillaume Demicheli 126 Reputation points

2024-11-18T10:15:09.5466667+00:00

Same problem here.

Mysql DB disappeared... suddently a morning.. without any action from me.

az mysql server show --resource-group myresourcegroup --name mydemoserver

says resource not found.

It's like DB never existed, but I still have the private network and dns associated with this DB (created from WordpressDB on Azure).

I still pay for the resource... Azure for Mysql Database appear in cost manager.

How is it possible ?!
Please sign in to rate this answer.
Guillaume Demicheli 126 Reputation points

2024-11-18T11:57:55.5633333+00:00

Found out why.... Microsoft disabled Mysql Db single server on Sept. 16

Instead you have to use Flexible server.

You can use DMS (Database migration service) to "migrate" data... (in progress as I write)

Guillaume Demicheli 126 Reputation points

2024-11-18T14:17:07.0266667+00:00

Well.. my DB (loctet-wordpressdb.mysql.database.azure.com) doesn't appear anywhere... nor in the DMS project nor in Azure Portal.... nowhere.

Regarding Azure Doc, It should be accessible through portal...

Please help ! Thanks.

Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-11-20T23:44:53.4733333+00:00

@Guillaume Demicheli Thank you for reaching out.

Please file a support ticket so we can further investigate at the back end.

Regards,

Oury

Guillaume Demicheli 126 Reputation points

2024-12-10T12:15:31.18+00:00

Thanks for the reply.

I can't open ticket, no support available.

Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-12-11T18:11:13.1633333+00:00

Guillaume Demicheli

Please send an email to azcommunity@microsoft.com with your subscription ID so we can enable a one-time free support ticket.

Don't forget to mention in the subject Line ATTN: Oury so I don't miss it.

Please do let me know once done.

Regards,

Oury

Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-12-12T16:58:00.9233333+00:00

Guillaume Demicheli

Did you had the chance to send the email.? Please let me know once done.

Guillaume Demicheli 126 Reputation points

2024-12-12T17:42:38.8533333+00:00

Thanks Oury,

I've got an answer on another thread I started here:

https://learn.microsoft.com/en-us/answers/questions/2128796/issues-deleting-old-mysql-single-server-with-force

I've got chance to get a one time Support Ticket. Microsoft fixed missing resource in 2 hours...

Thanks for your help anyway.

Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-12-13T18:59:28+00:00

Thank you Guillaume Demicheli for letting me know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

MySQL database on Azure Disappeared from my resources?

1 answer

Your answer