Lost a database after restoring from RDS snapshot

Question

After restore a RDS snapshot, a database is lost.

The snapshot is created at April 30, 2024, version Mysql 5.7.44, us-west-1c

Then I found some logs when creating the snapshot, it shows "Unknown database" just seconds before shutting down the plugins, and preparing for creating snapshot.

2024-04-30T01:40:01.919975Z 141860 [Note] **Unknown database 'portal_v2'**

**Update**: I tried Export to S3, and I got the info.json, it says totalExportedDataInGB is 0.

{"exportTaskIdentifier":"portal","sourceArn":"arn:aws:rds:us-west-1:953153256941:snapshot:billing-snapshot","exportOnly":[],"snapshotTime":"Apr 30, 2024, 1:48:23 AM","taskStartTime":"Jun 4, 2024, 8:54:33 PM","taskEndTime":"Jun 4, 2024, 8:56:00 PM","s3Bucket":"sddesign-rds","s3Prefix":"","exportedFilesPath":"portal","iamRoleArn":"arn:aws:iam::953153256941:role/service-role/rds-importing","kmsKeyId":"arn:aws:kms:us-west-1:953153256941:key/d687a723-42fa-45c7-8bb0-f721aa1e8285","status":"COMPLETE","percentProgress":100,"totalExportedDataInGB":0.0}

Any suggestions? much appreciate!

Priyanka_Sanghvi · Answer

Based on the information you've provided "Unknown database 'portal_v2'", it seems that the database 'portal_v2' was already missing or inaccessible at the time the snapshot was created. Here are some suggestions and points to consider:

1. Look for any logs around April 30, 2024, that might indicate the database was dropped or renamed.

2. Since the export to S3 shows 0 GB of data, it's possible the snapshot itself is corrupted or empty. Try restoring to a new RDS instance to confirm.

3. Look for any events around the time of the snapshot that might indicate issues with the database or instance.

4. Ensure there were no storage-related issues on the original RDS instance that could have prevented proper snapshot creation.

5. If available, try a point-in-time recovery to a time shortly before the snapshot was taken.

If you've exhausted these options, it might be worth contacting AWS Support for more in-depth investigation.

Also for future prevention, it's crucial to regularly verify the integrity of your backups and snapshots, and to maintain multiple backup strategies.

Lost a database after restoring from RDS snapshot

Add your answer

Relevant content