My database on a SQL instance is deleted after a while.

I am working on a SQL instance with MySql, I have created my database, tables, imported data as well, but my database is deleted after a certain time, around 4-5 hours. I need help to know if it is some configuration of my instance or another factor.

4 Likes

Hello @DavidRomero ,Welcome on Google Cloud Community.

Did you’ve checked the logs ? Please follow this [1]guide and back to us with output.

[1.] https://cloud.google.com/sql/docs/mysql/logging


cheers,
DamianS
LinkedIn medium.com Cloudskillsboost

3 Likes

Hi Damian,

I have reviewed each of the logs, but I cannot find any that indicate the deletion of my database.

1 Like

Hello @DavidRomero

If you used CloudSQL, there is no possibility to not having logs for instance deletion.

Which MySQL option did you’ve used? CloudSQL or MySQL installed on GCE VM ?


cheers,
DamianS
LinkedIn medium.com Cloudskillsboost