Restore from a snapshot (either manual or automated).
NOTE: To restore the new instance with same as the original one, first the old/original instance must be renamed to something else then the new instance from snapshot can be restored with the required name (can be same as old).
Restoring from manual/automated snapshot of AWS RDS Aurora.
1. In AWS console, select the old/existing database instance (apidbauu003) and rename the instance to something new (apidbauu003-corrupted).
2. select the snapshot to be restored (e.g. apidbauu003-ort-test).
3. From snapshot actions, execute “restore snapshot”
4. Under section “Setting”
a. Enter the “DB instance identifier” name as the old name (apidbauu003).
5. Under section “Network & Security”, verify following
a. VPC
b. Subnet group
c. Publicly Accessible (Default No)
6. Click on button “Launch DB instance”.
7. Verify the new instance created by following step 1-6.
a. Connect to new Aurora instance database using MySQL client utility. Note: the old DB url should work as-is without any issue.
b. Execute sql statement to verify the data for any transaction/master table.