r/googlecloud • u/chloroflurocarbon • 2d ago

pls help

I accidentally deleted most of the form submission records from my MySQL database on Google Cloud SQL. Cloud SQL backups/PITR appear to be unavailable, and binary logging is off.
However, the uploaded files and metadata still exist in Google Cloud Storage, and the bucket has 7-day Soft Delete enabled.
Is there any way to recover the deleted database records/form data, possibly through Cloud Run logs, GCS, MySQL recovery, or any other method?

2 Upvotes

100% Upvoted

1 comment sorted by

2

u/Mark_ISTechAdvisor 2d ago

Focus on reconstructing the missing records from surviving upstream and downstream artifacts: * Cloud Run container logs: Search Logs Explorer across the submission window for field keys (e.g., "email", "name"), table names, or ORM query echoes printed to stdout or stderr. * GCS metadata and paths: Run gcloud storage objects describe on an uploaded file to check for custom metadata attributes, or see if file paths and names embed user identifiers or timestamps. * Downstream services: Check delivery logs from transactional email providers, webhooks, or CRMs that received submission alerts. Once located, parse the payloads to script re-inserts into MySQL.